Typeform to Gemini Classifier: Log Results in Google Sheets

Automatically classify new Typeform answers with Gemini and log everything to Google Sheets

This n8n workflow watches for every new Typeform submission, sends the response to Google Gemini for classification, and then appends the results (plus the original submission data) as a new row in Google Sheets.

What this workflow does

• Triggers on new Typeform responses as soon as a respondent submits your form.
• Loads your target Google Sheets settings, including the Google Sheets document ID and the sheet name.
• Sends the Typeform submission payload to Google Gemini with a prompt to classify the answer.
• Appends a new row to Google Sheets containing the Gemini classification output along with the incoming Typeform data—so you can review results in real time.

Use cases

• Lead intake enrichment: Classify Typeform responses (e.g., intent/category) and store both the label and the raw submission in Google Sheets.
• Support triage: Turn free-text answers into structured categories using Gemini, then track them alongside the original fields.
• Feedback analysis pipelines: Classify survey feedback and keep a searchable log for reporting or downstream automation.
• SaaS ops reporting: Maintain an always-up-to-date Google Sheets dataset of classified submissions without manual copy/paste.

Technical details

• n8n Typeform Trigger to detect new form submissions.
• Google Gemini integration (via n8n-nodes-langchain: Google Gemini) to classify the response using your selected Gemini model ID.
• Google Sheets to append rows to a specified document ID and sheet name.
• Uses supporting workflow nodes such as Set and Sticky Note for configuration and clarity.

Set it up once by connecting Typeform, Google Gemini credentials, and Google Sheets details (document ID, sheet name, and column mapping), then let the workflow handle classification and logging automatically.