n8n

How to Automate Google Sheets Interview Logging?

Turn long user interviews into a simple, guided flow. An AI interviewer asks questions, captures each answer, and saves the whole transcript for your team. It fits research, marketing, and product feedback use cases where you need many insights fast.

Here is how it works. A form link starts the session and creates a unique session ID. Messages and answers are stored in Redis so the experience stays fast, even with many users. An AI agent powered by a Groq chat model asks the next question, and a form collects the reply. The loop keeps going until the user says to stop. When finished, the system sends the transcript to Google Sheets for analysis and can show a clean summary page using a webhook and HTML node. A 404 page appears if the session is not found.

Setup needs Google Sheets access, a Redis database, and a Groq API key. Teams can expect faster research, less manual note taking, and clean data for reporting. Use it for customer feedback studies, new user onboarding interviews, or exit interviews, all without booking calls or typing raw notes.

What are the key features?

  • Form trigger starts an interview and collects the participant name
  • UUID node creates a unique session ID for each interview
  • Redis nodes create and update a session that stores every message
  • AI agent uses a Groq chat model to generate the next interview question
  • Form node captures the user answer and feeds it back to the AI loop
  • If node checks for a stop request to end the interview gracefully
  • Google Sheets node writes each message to a sheet for easy analysis
  • Webhook and HTML nodes render a transcript page with a 404 fallback
  • Memory manager clears chat context so the next interview starts fresh

What are the benefits?

  • Reduce manual logging from 2 hours to 10 minutes per interview
  • Automate question flow and note taking to cut busywork by about 90%
  • Improve data accuracy by removing copy and paste errors
  • Handle many concurrent sessions with Redis backed storage
  • Connect AI, forms, Redis, and Google Sheets in one flow

How do you set it up?

  1. 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.
  2. You'll need accounts with Google Sheets, Redis and Groq. See the Tools Required section above for links to create accounts with these services.
  3. Open the Start Interview form trigger and set the path, title, and description for your interview. Copy the form URL for testing.
  4. Double click the Groq Chat Model node. In the Credential field, click Create new credential, then follow the on screen steps to add your Groq API key from your Groq account dashboard.
  5. Double click each Redis node. In the Credential field, click Create new credential and enter your Redis connection details. For hosted Redis, paste the connection URL or host, port, username, and password from your provider.
  6. Double click the Save to Google Sheet node. In the Credential field, click Create new credential and complete the Google Sheets OAuth steps. Make sure the connected Google account has edit access to the target sheet.
  7. Prepare a Google Sheet with columns that match the mapped fields such as timestamp, type, role, and content. In the node, select the spreadsheet and worksheet.
  8. Open the Set Interview Topic node and enter the topic or audience you want the AI to focus on. This steers the AI questions.
  9. Open the Redirect to Completion Screen node. Copy the webhook URL from the Webhook node used for the transcript page. In the form end settings, set the redirect URL to this webhook path.
  10. Click Execute Workflow, open the form URL, and submit a test name. Answer a few questions, then type stop to end the interview. Confirm the transcript page displays your answers.
  11. Check Google Sheets to ensure new rows are added for each message. If rows do not appear, confirm the sheet permissions and the worksheet selection in the node.
  12. If the transcript page shows 404, make sure the redirect URL includes the correct session ID and that the Redis credentials are valid.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Free tier: $0, API key usable via API (rate‑limited)

Redis

Sign up

Free plan: $0 / mo, 30 MB, single DB

Credits:
Showcase post

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.