Send Google review request and reminder emails via Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every day at 09:00).
- ⚙️ Your settings (Edit Fields (Set)): sets 9 fields: businessName, yourName, reviewLink…
- Read all customers (Google Sheets): uses Google Sheets
- Pick who to ask (Code): runs custom JavaScript code
- One customer at a time (Loop Over Items (Split in Batches)): loops over the items in batches
- Send the review request (Gmail): uses Gmail
- Build the stamp (Code): runs custom JavaScript code
- Stamp the sheet (sent) (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs daily and reads a Google Sheets job ledger to send Google review request and reminder emails via Gmail, then updates the sheet with sent dates to prevent duplicate messages. How it works 1. Runs every day at 9am on a…