Marketing

Google Review Requests on Autopilot: A Freelancer's n8n Flow Emails Each Client 2 Days After a Project Is Done

  • Level Beginner
  • Setup~30 min (estimated)
  • Evidence Some evidence
  • CostNot stated in source
  • No-codeNo
n8nSource-linkedBeginner-friendly

What they did

A freelancer in India shared the n8n workflow he uses in his own business. Every day at 11:00 it reads a Projects Google Sheet, finds projects marked Completed at least 2 days ago with no review requested yet, sends the client a short personal thank-you email with his Google review link, and writes the date back so nobody is asked twice. He also flags a date bug: a plain YYYY-MM-DD date is read as UTC midnight, which silently broke the 2-day filter for him until he parsed dates as local.

How it went

n8n community post by the freelancer (Oct 26, 2026 UTC): daily 11:00 schedule, Google Sheet filter (Completed, 2+ days, not yet asked), Gmail thank-you with review link, date written back; UTC date-parsing bug explained. No review counts given

Worth knowing

  • n8n community post by the freelancer (Oct 26, 2026 UTC): daily 11:00 schedule, Google Sheet filter (Completed, 2+ days, not yet asked), Gmail thank-you with review link, date written back; UTC date-parsing bug explained. No review counts given.

Prompt

Cleaned version rewritten from the source — not a direct quote.

Every morning, read my [Projects] sheet. For each project with status Completed, finished at least 2 days ago and no review requested yet, draft a short, personal thank-you email to the client that mentions the project by name and includes my Google review link: [link]. Send it from my email, then write today's date in the 'review requested' column so no one gets asked twice. Treat dates as my local time zone.

Recommended

Try it in Grok Bot

  1. Copy the prompt (button below).
  2. Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
  3. Connect the listed tools (Gmail, Google Sheets, Email) as connectors when Grok Bot asks.
  4. If the task repeats, ask: "Make this a daily routine."

Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.

Set it up

Tools: Gmail, Google Sheets, Email · Stack: n8n + Google Sheets + Gmail

  1. Read the original source for full context.
  2. Connect the tools your agent needs.
  3. Paste the prompt and replace [bracketed] placeholders.
  4. Run once manually and check the output before scheduling it.

Generic suggested steps, not from the source.

Evidence

n8n community post by the freelancer (Oct 26, 2026 UTC): daily 11:00 schedule, Google Sheet filter (Completed, 2+ days, not yet asked), Gmail thank-you with review link, date written back; UTC date-parsing bug explained. No review counts given

Source: Web · Verified by us: not yet · Report broken or outdated

Related use cases

Inbox & communicationReddit

6-class email router for a 22-person consultancy

An IMAP trigger feeds an OpenAI classifier that routes 80–120 emails a day to Slack, Pipedrive and Zendesk. It hit 94% accuracy on 500 emails and saves 11 hours a week.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nSource-linked
MoneyReddit

Invoice capture for a distributor: 4m12s down to 38s each

A shared Gmail label feeds an extractor, totals are validated to €0.01, low-confidence fields go to a human, and results push to Sage. 87% need no human touch.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nMakeSource-linkedNeeds verification