Skip to content
Flowmanic
Customer OperationsStructurally Validated

Review Request Email

When you change an order's Status to Delivered in your orders sheet, this sends the customer a short, friendly email with your review link, then marks the row so they're never asked twice. It only reacts to Status changes, and it never sends without a real review link.

Automation flow

How it works

  1. 1Every minute, n8n checks the Status column for changes. Edits to other columns don't trigger anything.
  2. 2The email goes out only if the new status is Delivered (any capitalisation), Review Requested isn't already Yes, the row has an email, and there's a review link.
  3. 3The row's Review Requested is set to Yes, so changing the status back and forth never sends a second email.

Services used

Google SheetsGmail

What you'll need

  • An n8n Cloud or self-hosted account
  • A Google account (Sheets + Gmail)

What's included

  • Never asks the same customer twice
  • Only reacts to Status changes, not other edits
  • Per-row review link, or one default link for every order
  • Completely free — part of the Starter Pack

Estimate what this could save you

3.6 hours/month

≈ $108/month in your time

A rough estimate based on what you enter above — not a guarantee. Actual time saved depends on your process.

Questions about this template

Free

No account needed — the download link lands in your inbox instantly.

Structurally validated: automatically checked for valid n8n format before every deploy.

Difficulty
Easy
Setup time
~10 min
Integrations
2
Node count
6
Format
.json + guide