Feedback to Google Reviews with n8n + Gemini (free workflow)

What this workflow does

Customers fill a short form from a QR code, a bill or a WhatsApp link. Gemini reads the star rating and the comment together and returns the sentiment, topic, urgency, a one-line summary, a suggested next step and a personal reply. Every response is saved to Google Sheets. Happy customers get a thank-you email with a Leave a Google review button. Unhappy customers get a personal apology that promises a follow-up, and you get an alert (marked URGENT when it is serious) with everything you need to call them.

A 4 star rating with "it arrived broken" still counts as unhappy, because the comment is read too.

Who it is for

Restaurants, cafes, salons, clinics, gyms, hotels, shops and any local business that lives on Google reviews and word of mouth.

What you need

• n8n (Cloud or self-hosted)
• A Google account with Gmail and Google Sheets
• A Google AI Studio API key for Gemini (the free tier works for small volumes)
• A Google Business Profile, for the review link

The workflow, step by step

Step 1 · Collect feedback

• Customer Feedback Form (n8n Form): name, email, optional phone, what they visited or bought, a 1 to 5 rating and a comment.
• Workflow Configuration (Set): business name, sender name, owner email, Google review link, minimum happy rating and email language.

Step 2 · Analyze with Gemini

• Analyze Feedback with AI (Basic LLM Chain) with Google Gemini Chat Model and Feedback Analysis Parser.
• Use Rating-Based Fallback (Set): if Gemini fails, the star rating decides, so no feedback is lost.

Step 3 · Log every response

• Build Feedback Record and Save Feedback to Google Sheets: one row per response, easy to filter by topic or urgency.

Step 4 · Route by happiness

• Is Customer Happy? (IF): rating at or above happyMinRating and the comment is not negative.
• Send Thank-You and Review Request (Gmail) for happy customers.
• Send Personal Apology to Customer and Alert Owner About Unhappy Customer (Gmail) for everyone else.

Setup

1. Download the JSON below and import it in n8n (Create workflow > ⋯ > Import from File).
2. Create a Google Sheet with a tab named Feedback and these headers: Submitted At, Name, Email, Phone, Visit, Rating, Feedback, Sentiment, Topic, Urgency, Summary, Suggested Action, Route, AI Status.
3. Add Gmail OAuth2, Google Sheets OAuth2 and Google Gemini (PaLM) API credentials, and pick your spreadsheet in Save Feedback to Google Sheets.
4. Fill in Workflow Configuration. For the review link, open Google Business Profile, choose Ask for reviews and copy the link.
5. Test it with your own email: submit "5 - Excellent, amazing food and very friendly staff" and you should get the review request. Then submit "4 - Good, product is good but it arrived broken and support never replied" and you should get the apology plus an URGENT alert.
6. Activate and share the form's production URL as a QR code on tables, bills or receipts.

How to customise

• The prompt and emails are a starting point. Rewrite them for your business.
• Customer Feedback Form: the questions. Keep the "5 - Excellent" style labels on the rating, because the number is read from the first character.
• Analyze Feedback with AI: analysis and reply rules.
• Send Thank-You and Review Request, Send Personal Apology to Customer and Alert Owner About Unhappy Customer: the email text.
• happyMinRating: raise it to 5 to ask only your happiest customers. emailLanguage: Hindi, Spanish or any language.

Why Gemini

Reading one short comment and writing a 50 to 90 word reply is a light task. Gemini Flash does it quickly, handles mixed-language comments and has a free tier.

Guardrails

• Google does not allow review gating. Every customer can still leave a review; this flow just makes sure an unhappy customer hears from you first.
• Never offer rewards for reviews. Google doesn't allow it.

Troubleshooting

• Everyone counted as unhappy: the rating labels were changed. Keep the number as the first character.
• AI Status says fallback: the Gemini credential is missing or the key is wrong.
• Review button goes nowhere: paste the full link from Google Business Profile into googleReviewLink.