Typeform Feedback Router to Google Sheets

Overview

This workflow automatically captures new Typeform feedback submissions, evaluates the usefulness rating provided by respondents, and routes each submission to one of two Google Sheets worksheets — one for positive feedback (rating ≥ 3) and one for negative feedback (rating < 3). It’s an ideal solution for course creators, product managers, or event organizers who want to instantly segment feedback without manual sorting, enabling faster analysis and action on responses.

How It Works (Step by Step)

1. Typeform Trigger (Webhook – No Auth) — Listens for new submissions from a specific Typeform form (configured via the form ID). Every time a respondent completes the form, the trigger fires and passes the raw response data downstream. No authentication is required because Typeform sends data directly to the public webhook URL generated by n8n.
2. Set (Internal – No Auth) — Extracts two key fields from the Typeform payload: "How useful was the course?" (mapped as usefulness) and "Your opinion on the course:" (mapped as opinion). The node is configured to keep only these two mapped values (keepOnlySet: true), discarding all other form data to reduce clutter.
3. IF (Conditional Logic – No Auth) — Checks whether the usefulness value is greater than or equal to 3 (largeEqual operation). This simple numeric condition acts as the routing decision point: the true branch (first output) receives high‑rated feedback, while the false branch (second output) receives low‑rated feedback.
4. Google Sheets (positive feedback) (OAuth2) — Appends the usefulness and opinion values to a worksheet named positive_feedback (columns A:C). The operation is append, so each new submission adds a new row. Authentication uses OAuth2, so you must have a Google account and authorize n8n to write to the target spreadsheet.
5. Google Sheets1 (negative feedback) (OAuth2) — Identical in structure to the previous node but writes to a different worksheet named negative_feedback. This keeps positive and negative responses completely separate for easy analysis.

Setup Instructions

• Typeform: You will need a Typeform account and a form (e.g., a course feedback form) with at least two questions: a numeric rating (e.g., "How useful was the course?") and an open‑ended opinion question. The form ID (formId) is found in the Typeform form URL or in the Typeform admin panel.
• Google Sheets: You must have a Google account and a spreadsheet with two worksheets named exactly positive_feedback and negative_feedback. Create those sheets (with headers like usefulness, opinion, etc.) before activating the workflow. In n8n, configure OAuth2 credentials for Google Sheets (follow n8n’s Google service account guide).
• n8n: Once the workflow is imported, set the webhookId in the Typeform Trigger (n8n will generate one automatically after you activate the workflow) and update the sheetId in both Google Sheets nodes with your spreadsheet’s ID (found in the sheet URL after /d/).

Use Cases & Adaptations

• Course or training feedback – Instantly separate enthusiastic attendees from those who struggled, allowing targeted follow‑up.
• Product NPS surveys – Replace the numeric condition with a threshold (e.g., 7 out of 10) to route promoters and detractors to different CRM lists.
• Event feedback – Add more conditions (e.g., multiple IF nodes) to handle nuanced ratings or to trigger email notifications for very low scores.
• Customization – Add an HTTP Request node after the IF branches to send data to a webhook, a Slack message, or a database. You can also enrich the Set node with additional fields (e.g., timestamp, respondent email) by referencing other Typeform fields.

This workflow is a flexible foundation for any scenario where you need to automatically classify and store form responses based on a numerical score.

{
  "id": "1001",
  "name": "typeform feedback workflow",
  "nodes": [
    {
      "name": "Typeform Trigger",
      "type": "n8n-nodes-base.typeformTrigger",
      "notes": "course feedback",
      "position": [
        450,
        300
      ],
      "webhookId": "1234567890",
      "parameters": {
        "formId": "yxcvbnm"
      },
      "credentials": {
        "typeformApi": "typeform"
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "name": "IF",
      "type": "n8n-nodes-base.if",
      "notes": "filter feedback",
      "position": [
        850,
        300
      ],
      "parameters": {
        "conditions": {
          "number": [
            {
              "value1": "={{$json[\"usefulness\"]}}",
              "value2": 3,
              "operation": "largerEqual"
            }
          ],
          "string": [],
          "boolean": []
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "positive feedback",
// ... truncated (copy to see full JSON)