Draft a Google review request when a job is marked done
When a job row in Google Sheets is marked done, the flow writes a Gmail draft asking for a review. You read it and send it.
A guide, not professional advice. Test before you use it for real. See terms.
A local service business that tracks jobs in Google Sheets and has a Google Business Profile.
Not sure which one to use? See Make vs n8n.
Problem
Happy customers never get asked for a review because nobody remembers to write the email.
What you need
How it connects
- Google SheetsNative app
Make: Search Rows on a schedule, then Update a Row. n8n: Google Sheets Trigger, Row updated, then Update Row.
- GmailNative app
Make: Create a draft email. n8n: Gmail node, Draft > Create. Nothing is sent automatically.
Steps
Add two columns
Your job sheet needs status (done) and review draft (empty until the flow writes the date). The customer's email must be in the row.
Find finished jobs
Make: a scheduled scenario with Search Rows where status is done and review draft is empty. n8n: Google Sheets Trigger on Row updated, then a Filter node with the same two conditions.
Write the draft
Make: Create a draft email. n8n: Draft > Create. Short and personal: thanks for the job, one line asking for an honest review, and your review link from Google Business Profile.
Ask everyone the same way
Google's policy says businesses may not discourage negative reviews or selectively solicit positive ones. Don't add a "were you happy?" step that only sends the link to happy customers.
Mark the row
Update the row with today's date in review draft, so the same customer doesn't get a second draft.
Time
Build time is about 25 minutes, estimated by the recipe’s author. It is not a measured average.
Saves writing the same email after every job. Sending stays a manual click.
Cost
Gmail and Google Sheets come with the Google account. Make or n8n per their current pricing.
What it doesn’t do
It doesn’t send the email, offer incentives, or post or answer reviews. Only email customers who gave you their address for this kind of message.
Build it
The account is yours. The Make link is an affiliate link.
Sources
- Google Sheets modules in Make
- Gmail modules in Make
- n8n Google Sheets Trigger node
- n8n Filter node
- n8n Gmail node
- Google Business Profile prohibited and restricted content
Similar recipes
Accounting
Alert the team and draft an email when a Stripe invoice payment fails
On invoice.payment_failed, Slack gets an alert and Gmail gets a draft to the customer. A person reviews and sends it.
Services
Summarize a new HubSpot form lead with OpenAI and post it to Slack
OpenAI reads the form answers and drafts a short summary with a suggested fit. A person reads it in Slack and decides.
Services
Turn a Calendly booking into a HubSpot contact and a Slack note
When someone books through Calendly, the flow creates or updates the contact in HubSpot and tells the team in Slack.