Send Google review request and reminder emails with Gmail and Google Sheets

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 schedule.
2. Loads your email templates and timing settings, then reads all rows from the selected Google Sheets document.
3. Keeps only rows with status set to open, a valid job_date, and a customer email, and decides whether a first request (2+ days after the job) or a reminder (7+ days after the request) is due.
4. Personalizes the subject and body with the customer details and your Google review link.
5. Sends the appropriate plain-text email to each customer through Gmail.
6. Updates the matching row in Google Sheets (by job_id) to stamp request_sent or reminder_sent with today’s date so the workflow never sends the same email twice.

Setup

1. Connect Google Sheets credentials and select the target spreadsheet and sheet in both Google Sheets nodes.
2. Connect Gmail credentials for the mailbox you want to send from.
3. Ensure your sheet has headers job_id, customer_name, customer_email, job_description, job_date, status, request_sent, reminder_sent and uses status = open plus job_date in YYYY-MM-DD format.
4. In the settings step, set your business name, sender name, and Google review link, and adjust the email templates and timing offsets if needed.