“The client loved the project. Then nobody asked for a review.”
Project closed → 7 days → a Google review request
Now every client is asked at the right moment.
A week after a project is marked "done", the client gets a personal email with a direct link to write a review. Once, at the right moment.
Get the ready-to-import blueprint by email
The full build is on this page, free, no email needed.
Short answer
A week after a project is marked "done", the client gets a personal email with a direct link to write a review. Once, at the right moment.
- Tools
- Make, Google Sheets, Gmail
- Cost to run
- 3 Make credits (operations) per run
The problem
Reviews get requested when someone remembers — months later, after the client forgot how pleased they were. The right moment is a week after delivery, and at that moment nobody is free to ask.
What happens when it runs
- Schedule: every morning 10:00
- Read the projects sheet: status "done", end date exactly 7 days ago, "review" column empty
- A personal email to the client with the business review link
- Mark "sent" in the review column
The tools inside
Disclosure: links marked "paid link" pay us a commission from the vendor if you sign up. Your price is unchanged, and every file here works without them. How we choose tools →
- Make — the automation engine · Sign up (one month of Core free) → paid link · we earn a commission
- Google Sheets — log and lists
- Gmail — email
Before you start
Three things to have ready before importing, or Make will ask and you will have to leave halfway:
- The projects spreadsheet id
- The Google Business review link
- The email wording
Sheet templates
The file maps columns by position. Start from exactly these headers, in this order — a column in the wrong place writes a phone number into the email column.
- Projects sheet ·
project | client | email | status | end_date | review(Sent with the blueprint by email)
How to import (2 minutes)
- In Make: Scenarios → Create a new scenario
- At the bottom, the three dots (⋯) → Import Blueprint → choose the file you downloaded
- Click every module with an exclamation mark: choose your connection (Google, Telegram) — Make creates one in a click if you have none
- Replace every value in double curly braces ({{…}}) with your own from the list above
- Run once with a test row in the sheet. Only when it passes — Schedule and ON
The video
Watch on YouTube → · Subscribe to BuilderStack · Telegram channel
Read more
What does not work in it
- An unhappy client gets the same request, on purpose. Leaving them out so only happy clients review is review gating, which Google prohibits ("selectively solicit positive reviews from customers") and can answer by removing reviews. If a project went badly, deal with the client directly; do not skip them. Source: https://support.google.com/contributionpolicy/answer/7400114?hl=en
- "Exactly 7 days ago" means that if the scenario skips a day, that day's client is never asked. "Between 7 and 10 days" with a marker column is safer.
Questions
What does not work in "Project closed → 7 days → a Google review request"?
An unhappy client gets the same request, on purpose. Leaving them out so only happy clients review is review gating, which Google prohibits ("selectively solicit positive reviews from customers") and can answer by removing reviews. If a project went badly, deal with the client directly; do not skip them. Source: https://support.google.com/contributionpolicy/answer/7400114?hl=en "Exactly 7 days ago" means that if the scenario skips a day, that day's client is never asked. "Between 7 and 10 days" with a marker column is safer.
What do I have to fill in after importing the blueprint?
The projects spreadsheet id; The Google Business review link; The email wording.
Which tools does it use, and what does a run cost?
Make, Google Sheets, Gmail. Each run uses 3 Make credits (operations).
Is the blueprint free?
Yes. The ready-to-import file is sent free to the email address you enter; the newsletter is a separate box you can leave unticked. The full build is on this page without any email. The file contains no connections and none of our ids, and works whether or not you use the paid Make link on the page.
Build your automation plan →Four questions, three automations ranked for your business.
Paid link. If you sign up through it we earn a commission from Make; your price is the same, and the link gives you one month of Core free.
Next step
All automations →
AUTO WELCOMENew client → welcome email → onboarding checklist → alert
A client signs and hears nothing until someone is free. On signing, they get an email saying what comes next, a checklist opens and the team is alerted.
QUOTE FOLLOW-UPQuote unanswered for 3 days → one follow-up, automatic
Every quote sent and unanswered within three days gets one short follow-up email, and the consultant gets an alert. Nothing to remember, nobody to chase.
NO-SHOW SHIELDA meeting tomorrow → a reminder 24 hours ahead, with a "can't make it" link
A no-show is a slot nobody could refill. Every morning, each of tomorrow's meetings gets a reminder email with the time and a "can't make it" link.
Get one new Make automation each week
Get the full 27-blueprint pack (ZIP) by email, then one new automation a week. Every build on the site stays open and free without it.