See llms.txt for all machine-readable content.
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.
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.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.sent with review_requested_at and reads that write back, so each client is asked once, across all their visits and on re-runs.opt_out = TRUE on every row for that email. Tampered links change nothing.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.optout_url and type a random optout_secret of 16 or more characters. Nothing is sent until both are set.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.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