Typeform to Google Sheets, feedback sorted instantly
You ask for feedback, it comes in… and then it sits. Not because you don’t care, but because digging through responses, copying rows, and deciding what’s “good” vs “needs help” is tedious.
Marketing managers feel it when testimonial hunting turns into a weekly scavenger hunt. Customer success teams feel it when unhappy users get noticed too late. And if you run a small business, you’re the one doing all the sorting. This Typeform Sheets sorting automation fixes that.
You’ll see exactly how the workflow takes each Typeform submission, scores it, and drops it into the right Google Sheets tab automatically (so follow-up and social proof get way easier).
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Typeform to Google Sheets, feedback sorted instantly
flowchart LR
subgraph sg0["Typeform Intake Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/typeform.dark.svg' width='40' height='40' /></div><br/>Typeform Intake Trigger"]
n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Map Feedback Fields", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Feedback Score Check", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Log Positive Responses", pos: "b", h: 48 }
n4@{ icon: "mdi:database", form: "rounded", label: "Log Negative Responses", pos: "b", h: 48 }
n2 --> n3
n2 --> n4
n1 --> n2
n0 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n2 decision
class n3,n4 database
classDef customIcon fill:none,stroke:none
class n0 customIcon
The Problem: Feedback Piles Up Because Sorting Is Manual
Typeform makes it easy to collect feedback. The messy part starts after the form is submitted. Someone has to open responses, check the rating, decide if it’s “positive” or “negative,” then log it somewhere your team can actually use. It’s not hard work. It’s the kind of work that gets postponed, which means glowing testimonials don’t make it into your marketing, and low ratings don’t get handled quickly. Worse, manual sorting leads to mistakes. A 2/5 gets filed as “fine,” or a great quote gets lost in a sea of “pretty good.”
Individually these problems look small. Put together, they slow everything down.
- You spend about 10 minutes per batch of responses just deciding where each one belongs.
- Teams miss the window to follow up with unhappy customers while the context is still fresh.
- Testimonial-worthy comments are scattered, so publishing social proof turns into a monthly chore.
- Manual copy-paste creates dirty data, which means your “feedback dashboard” can’t be trusted.
The Solution: Auto-Sort Typeform Feedback Into Google Sheets
This workflow watches for new Typeform submissions and routes each one into the right place automatically. The moment someone hits submit, n8n pulls the key fields you care about (like name, comment, and rating) and standardizes them so your spreadsheet stays clean. Then it checks the score against a simple rule: ratings above 3 out of 5 are treated as positive, and ratings 3 or below go to a negative/needs-attention tab. Finally, it appends the submission to the correct Google Sheet, so you end up with two living lists: praise you can reuse and issues you can act on. Honestly, it feels like hiring an invisible assistant whose only job is sorting feedback.
The workflow starts with a Typeform trigger. It maps and cleans the submission fields, then runs a score check to decide the path. From there, Google Sheets logs the response into either the Positive or Negative sheet, without you touching a thing.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you get about 20 Typeform responses a week. Manually, you might spend 2 minutes opening each response, another minute checking the rating, and a minute pasting it into the right tab. That’s roughly 80 minutes weekly, plus the mental overhead of keeping it consistent. With this workflow, sorting happens automatically after each submission, and your “after” time is basically just checking the sheet for 5 minutes to see what’s new. You get back about an hour most weeks, and the follow-ups happen sooner.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Typeform for collecting feedback submissions
- Google Sheets to store positive/negative tabs
- Google account access (authorize via Google Sheets credentials in n8n)
Skill level: Beginner. You’ll connect accounts and choose which fields map into your sheet.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A new Typeform submission triggers the workflow. As soon as someone submits your feedback form, n8n catches the event and pulls in the response payload.
The submission fields get cleaned and mapped. The workflow extracts the bits you actually care about (like rating and written feedback) and formats them so every row in Google Sheets looks the same.
A simple score check routes the feedback. An IF step evaluates the rating and chooses the positive path for scores above 3, otherwise it sends the response to the negative tab for review.
Google Sheets stores it in the right place. The final step appends a new row into the correct worksheet, so your team always has an up-to-date view without sorting anything manually.
You can easily modify the rating threshold to match your business (for example, treat only 5/5 as “positive”). See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Typeform Trigger
Set up the Typeform intake so new submissions enter the workflow.
- Add the Typeform Intake Trigger node as your workflow trigger.
- Set Form ID to
[YOUR_ID]. - Credential Required: Connect your typeformApi credentials.
- Save the node so n8n can generate the webhook URL for Typeform.
⚠️ Common Pitfall: Replace [YOUR_ID] with your actual Typeform form ID or the trigger will never receive submissions.
Step 2: Connect Google Sheets
Prepare the Google Sheets destination for logging positive and negative feedback.
- Open Log Positive Responses and set Authentication to
oAuth2. - Set Sheet ID to
[YOUR_ID]and Range topositive_feedback!A:C. - Set Operation to
append. - Credential Required: Connect your googleSheetsOAuth2Api credentials.
- Repeat the same credentials in Log Negative Responses, and set Range to
negative_feedback!A:Cwith Operation asappend.
⚠️ Common Pitfall: Both sheets must exist in the spreadsheet and match the ranges positive_feedback!A:C and negative_feedback!A:C.
Step 3: Set Up Map Feedback Fields
Map incoming Typeform fields to a clean structure for routing and logging.
- Add the Map Feedback Fields node after Typeform Intake Trigger.
- Set Keep Only Set to
true. - Create a number field named usefulness with value
={{$json["How useful was the course?"]}}. - Create a string field named opinion with value
={{$json["Your opinion on the course:"]}}.
Step 4: Configure Feedback Score Check and Routing
Route responses based on the usefulness score and log them to the correct Google Sheet.
- Add the Feedback Score Check node after Map Feedback Fields.
- Set the number condition: Value 1 to
={{$json["usefulness"]}}, Operation tolargerEqual, and Value 2 to3. - Connect the true output of Feedback Score Check to Log Positive Responses.
- Connect the false output of Feedback Score Check to Log Negative Responses.
Feedback Score Check routes positive scores (≥3) to Log Positive Responses and lower scores to Log Negative Responses.
Step 5: Test and Activate Your Workflow
Validate the full flow from Typeform submission to Google Sheets logging.
- Click Execute Workflow and submit a test Typeform response.
- Confirm the data appears in positive_feedback when
usefulnessis ≥3 and in negative_feedback when it is lower. - Check the execution data to ensure Map Feedback Fields and Feedback Score Check output the expected fields and routing.
- Toggle the workflow Active to enable production execution.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credential settings and your Google account security alerts first.
- If you add extra branching later (or use wait-style delays for batching), processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- If you decide to classify sentiment with OpenAI later, default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Typeform and Google account are ready.
No. You’ll mostly connect accounts and map fields to columns. The rating filter is a simple condition you can choose from a menu.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Typeform and Google Workspace costs (if you’re on paid plans).
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s quick. Change the condition in the “Feedback Score Check” step to use your threshold (like 4+ only), or add another branch for “neutral” scores. You can also tweak “Map Feedback Fields” to store extra fields such as product, plan type, or NPS-style reasons.
Usually it’s expired Google authorization or the spreadsheet permissions changed. Reconnect the Google Sheets credential in n8n, then confirm the target sheet is still shared with the same account. If you renamed tabs, update the sheet name in both “Log Positive Responses” and “Log Negative Responses.” Rate limits can also show up if you suddenly import a backlog.
A lot for most small teams. On n8n Cloud, your limit is based on executions per month, and each Typeform submission is typically one execution. If you self-host, there’s no execution cap; it mainly depends on your server and how many submissions come in at once.
Sometimes. If all you want is “Typeform to Sheets,” Zapier or Make can be fine. But n8n is nicer when you want branching logic (positive vs negative), extra data cleanup, or more complex routing without paying extra for every path. It also gives you the option to self-host, which can matter when volume grows. The trade-off is that n8n feels a bit more “builder-y” than plug-and-play. Talk to an automation expert if you want help choosing.
Once this is live, feedback stops being a pile and starts being a system. The workflow handles the sorting so you can handle the follow-up.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
