You can automate Google review requests by connecting a Google Sheet (customer log) to Gmail via n8n or Make.com. When a new customer row is added, the workflow waits a set delay — then sends a personalised review request email automatically. Setup takes under 30 minutes.
Most local businesses miss 80% of potential reviews simply because they never ask. Customers who had a great experience rarely think to leave a review unprompted — but when asked within a few hours of their visit, 15–35% of them will. Manually sending those emails is impractical. Automation makes it effortless.
This guide walks you through building a working review request automation from scratch — no coding required. You'll use free tools: n8n (free self-hosted) or Make.com (free tier), Google Sheets, and Gmail.
Why does automating review requests matter for local businesses?
Google reviews directly affect your local search ranking. Businesses with more recent, high-rated reviews appear higher in Google Maps results and in the local "3-pack" shown in organic search. The effect is compounding: more reviews → higher rank → more visibility → more customers → more reviews.
The problem is consistency. Manually emailing each customer after a visit takes time, gets forgotten during busy periods, and stops entirely when the business owner is overwhelmed. An automated workflow runs 24/7 and never forgets.
Key stat: According to BrightLocal's 2025 Local Consumer Review Survey, 88% of consumers use reviews to evaluate local businesses — and businesses that ask for reviews get 4× more of them than those that don't.
What tools do you need to automate Google review requests?
You need three things — all free to start:
- Google Sheets — your customer log. New rows trigger the automation.
- Gmail — sends the review request emails via OAuth (no SMTP setup).
- n8n or Make.com — the automation platform that connects everything and handles the timing logic.
Optional: if you have a POS system, booking app (Calendly, Acuity), or form tool (Typeform), you can feed new customer data into the Sheet automatically — making the whole process completely hands-off.
| Tool | Cost | What it does in this workflow |
|---|---|---|
| Google Sheets | Free | Stores customer names, emails, visit dates |
| Gmail | Free | Sends review request emails from your address |
| n8n (self-hosted) | Free | Runs the workflow logic and timing delay |
| Make.com | Free tier (1,000 ops/mo) | Alternative to n8n — same functionality |
| bit.ly or similar | Free | Shortens your Google review URL for emails |
How do you set up a Google review automation — step by step?
Create your customer tracking spreadsheet
Create a new Google Sheet with these column headers in row 1: Customer Name, Email, Visit Date, Review Sent, Review Link. The "Review Sent" column will be marked "Yes" by the workflow after it sends each email — preventing duplicates.
Get your direct Google review link
Search your business name on Google Maps. Click the star rating section, then "Write a review." Copy the full URL from your browser. Shorten it with bit.ly. This shortened link goes directly to your business's review form — customers don't need to search for you.
Import the workflow into n8n or Make.com
In n8n: go to Workflows → Import from File, and upload the JSON file from your template. In Make.com: go to Scenarios → Import Blueprint. The workflow appears pre-built with all nodes already connected — you just need to add your credentials.
Connect Google Sheets and Gmail
Click the Google Sheets node → Credentials → Add New. Sign in with your Google account and allow access. Repeat for the Gmail node. Both use OAuth — no API keys to manage, no password exposure. Your credentials are stored securely in your n8n or Make.com account.
Configure the email template and delay
Open the Email node and edit: replace [BUSINESS NAME] with your name, replace the placeholder review URL with your bit.ly link. Set the timing delay — 2 hours after visit date is the recommended default. Save.
Activate and test the workflow
Add your own name and email as a test row in the Sheet. Set the visit date to "now." Toggle the workflow to Active. Within the configured delay, you should receive the review request email at your inbox. Check the Executions log in n8n (or Scenario History in Make.com) to verify it ran successfully.
What should the review request email say?
The best review request emails are short, warm, and direct. Don't over-explain. The customer knows what you do — you just need to make it easy for them to act.
Here's a proven template structure:
Subject: How was your visit to [Business Name]?
Hi [First Name],
Thanks for coming in — it was great to have you. If you have 60 seconds, we'd really appreciate a Google review. It helps other local people find us and makes a big difference to a small business like ours.
→ [Leave a Review] (linked to your review URL)
Thanks again,
[Your Name] at [Business Name]
Keep the subject line neutral — avoid "Please leave us a review!" which reads as desperate. Questions ("How was your visit?") get higher open rates because they feel personal, not automated.
How do you connect a booking system to trigger the automation automatically?
If you use a booking app, you can make the entire process hands-off — no manual sheet entries needed.
- Calendly: Use the Calendly trigger node in n8n or Make.com. When an appointment is marked complete, it sends the customer data straight to the workflow.
- Acuity Scheduling: Same approach — use the Acuity webhook trigger. Filter for "appointment complete" events only.
- Square POS: Square's webhook sends a transaction event on each completed sale. Map the customer email from the transaction data.
- Typeform / JotForm: If you collect emails at checkout via a form, connect the form's "new submission" trigger to the workflow.
In each case, the booking system replaces the manual Google Sheet entry. The review email still goes out on the same timed delay — just with zero manual effort.
Should you use n8n or Make.com for this workflow?
| Factor | n8n (Self-Hosted) | Make.com (Free Tier) |
|---|---|---|
| Monthly cost | Free (self-hosted) | Free up to 1,000 ops/month |
| Setup time | ~20 min (Docker install) | ~5 min (cloud, instant) |
| Technical requirement | Basic server comfort | None — browser-only |
| Emails per month on free | Unlimited | ~300–500 (depending on scenario) |
| Scheduling flexibility | Cron + manual triggers | Polling every 15 minutes (free) |
| Best for | High volume, power users | Beginners, small volume |
Recommendation: Start with Make.com if you're new to automation — it's browser-based, no install, and the free tier handles most small businesses comfortably. Switch to n8n when you're sending more than 500 review requests per month.
Skip the build — get the pre-built template
The Local Business Review Aggregator template includes the complete n8n and Make.com workflow JSON, a Google Sheets dashboard, and a plain-English setup guide. Live in 20 minutes.
See what's included →
How do you track which customers have already been sent a review request?
Duplicate prevention is handled in the Google Sheet via the "Review Sent" column. When the workflow successfully sends an email, it writes "Yes" back to that cell. The next time the workflow runs, it checks each row — if "Review Sent" is already "Yes", that row is skipped automatically.
This means you can safely add new rows to the same sheet every day without worrying about accidental re-sends. The workflow is idempotent — running it twice produces the same result as running it once.
What results should you expect from automated review requests?
Based on data from local businesses using this type of workflow:
- Review conversion rate: 15–35% of customers emailed will leave a review (vs. under 5% with no ask)
- Time to see results: Most businesses double their review count within 60–90 days
- Ranking impact: Businesses in competitive local markets typically move up 3–8 positions in Google Maps within 3 months of consistent review growth
- Email open rate: Post-visit review requests average 45–60% open rates — far above the 20–25% typical of marketing emails
The compounding effect is what makes this automation particularly valuable. Unlike a paid ad that stops working when you stop paying, a consistent stream of genuine reviews builds an asset that improves your ranking permanently.
Frequently asked questions
Ready to automate your review collection?
Get the pre-built workflow template, Google Sheets dashboard, and step-by-step setup guide. Works with n8n and Make.com. No code required.
Full product details →