How to Automate Google Sheets Interview Insights?
Description
Run user interviews at scale without a live moderator. An AI asks questions, collects answers, and saves every step to a central sheet for research and reporting. Ideal for product teams, marketers, and operations who need structured feedback fast.
The flow starts with a form that creates a unique session ID. Redis stores the full conversation so the experience stays fast even with many users. An AI agent generates the next question, the user replies on a form, and an If node checks if the interview should stop. When finished, the workflow writes the transcript to Google Sheets and shows a custom completion page through a webhook. A memory manager clears context so the next interview starts clean.
Setup needs Redis access, a Groq API key for the chat model, and a Google Sheets connection. Expect big time savings since logging and formatting are automatic. Use this for discovery research, onboarding feedback, training reviews, or satisfaction interviews. Follow the steps to set your interview topic, map columns, and point your form to the transcript page.
Tools Required
What this workflow does?
- Form trigger starts each interview and collects the participant name.
- UUID generator assigns a unique session ID to track each conversation.
- Redis creates and updates the session to store all questions and answers.
- AI agent powered by a Groq chat model writes the next question based on prior answers.
- Form node captures each answer and feeds it back to the AI loop.
- If check detects when the user wants to stop and ends the loop.
- Google Sheets node saves the full transcript with timestamps and message types.
- Webhook and HTML nodes render a custom completion page with the transcript.
- 404 path returns a clear message when a session ID is not valid.
- Memory manager clears context so the next interview starts fresh.
What are the benefits?
- Reduce manual logging from 30 minutes per interview to under 2 minutes with automatic sheet updates.
- Automate 90 percent of repetitive interview tasks including question delivery and data entry.
- Improve data quality by capturing answers directly from forms with timestamps and roles.
- Support many concurrent interviews using Redis session storage without slowing down.
- Connect AI, forms, Redis, and Google Sheets in one flow for clean, structured data.
- Speed up analysis by saving transcripts in rows ready for filters and charts.
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Google Sheets, Redis and Groq. See the Tools Required section above for links to create accounts with these services.
- Open the Start Interview node and set the form title, description, and path. Save the node and note the public form URL.
- Double click any Redis node, click Credential to connect with, choose Create new credential, then follow the on screen instructions to add your Redis connection. Use your host, port, and password or your managed Redis provider details.
- Double click the Groq Chat Model node, create a new Groq credential, and paste your API key from the Groq dashboard. Test the connection.
- Open the Save to Google Sheet node, create a new Google Sheets OAuth credential, sign in, and allow access. Select your spreadsheet and sheet tab.
- Map the fields to columns. Include session_id, timestamp, type, question, and answer using the values produced by the Generate Row nodes.
- Open the Set Interview Topic node and write the topic or prompt that the AI should use to guide questions.
- Copy the URL from the Redirect to Completion Screen webhook node. In the Start Interview node, set the form ending to redirect to this URL so users see their transcript.
- Activate the workflow. Open the public form URL, enter a name, answer the first question, and continue. Type stop when you want to end.
- Check your Google Sheet to confirm new rows appear with correct timestamps and message types.
- If the transcript page shows a 404, confirm the webhook URL is correct and the session_id parameter is present. If the AI does not ask new questions, verify the Groq credential and network access.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
