See llms.txt for all machine-readable content.

Back to Templates

Send post-visit Google review requests from Google Sheets via Gmail

Quick overview

For small service businesses (clinics, salons, studios, contractors) that log visits in Google Sheets: automatically email each client a Google review request after a completed visit, once per client, with quiet hours, double-send protection and a signed unsubscribe link.

How it works

  1. Runs every hour and reads the Visits tab, picking rows with status = completed whose visit_end was at least delay_hours ago (default 3) and no more than max_age_days old (default 14), that haven't been asked yet and haven't opted out.
  2. Holds emails during quiet hours in your business timezone and sends them the next morning.
  3. Claims each row before sending: it writes sending <execution ID> into review_status, waits 15 seconds, reads the sheet again and only sends if the row still holds this run's own claim. If any check fails, the whole batch stops before anything is sent and the owner gets an alert email.
  4. Emails the client a link to your Google review page, then marks the row sent with review_requested_at and reads that write back, so each client is asked once, across all their visits and on re-runs.
  5. If the email server fails, the attempt is recorded on the row, the run is marked failed and the owner gets an alert email. The row is retried on later runs, up to 3 recorded attempts.
  6. Every email has a signed unsubscribe link (the link doesn't contain the email address). It opens a confirm page, and the opt-out is saved only after the person confirms; it then sets opt_out = TRUE on every row for that email. Tampered links change nothing.

Setup

  1. Create a Google Sheet with a Visits tab and columns: visit_id, client_name, email, visit_end, timezone, status, review_requested_at, opt_out, review_status. Import the workflow and connect your Google Sheets and SMTP credentials on the nodes that ask for them.
  2. In Config, set the sheet URL, timezone, business name, sender email, owner email (for alerts), review link, delay and quiet hours.
  3. Copy the Production URL of Unsubscribe link into optout_url and type a random optout_secret of 16 or more characters. Nothing is sent until both are set.
  4. Set the same timezone in Workflow settings. While the workflow is inactive, test with a row using your own email, status = completed and visit_end 4 hours ago: you should get exactly one email, and a second run sends nothing. Then activate. Don't trigger manual runs while the schedule is active.

Requirements

  • Self-hosted n8n (tested on 2.43.7 and 2.44.6), core nodes only
  • A Google account (Google Sheets)
  • An SMTP mailbox
  • No credentials are included

Customization

  • Change the email text in Select visits to ask
  • Adjust the delay and quiet hours
  • Change the schedule

Additional info

What's new in this update: fixes a double-send. In the earlier version, a row was only marked after its email went out, so two overlapping runs could email the same client twice. Rows are now claimed and re-checked before sending; in tests, three runs started at once send exactly one email. The unsubscribe link is now signed and has a confirm step. The sheet needs one new column, review_status, and Config needs owner_email, optout_url and optout_secret. The canvas and sticky notes were re-laid out so nothing overlaps in current n8n.

Testing: this version passed all 29 of its automated tests on a real n8n 2.44.6 instance on Oct 26, 2026, with a mock standing in for Google Sheets and email; the same workflow logic passed them on n8n 2.43.7 on Oct 22, 2026. Its email was also delivered through Gmail SMTP (587/STARTTLS) to a real inbox on Oct 22, 2026. Google Sheets is tested against mock data only; a live Sheets test is pending.

Limits: Google Sheets has no row locking, so the duplicate protection is best effort. Don't add, delete or sort rows in Visits while a run is in progress.

Support: [email protected]

Want more? This is one of five workflows in the Service-Business Ops Pack for n8n by Agentica (paid), which adds appointment reminders, lead intake, invoice follow-ups and a weekly KPI digest: https://agenticasolutions.gumroad.com/l/ops-pack-n8n?utm_source=n8n-hub&utm_medium=template&utm_campaign=ops-pack&utm_content=f1-review