Ask every customer for a Google review automatically after the job

Short answer: Use a free Google Apps Script that emails a short Google review request when you tick a job as done in Google Sheets, after a wait you choose, and only once per job. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Jobs tab; Add your review link; Paste the script; Turn on review requests; Tick jobs as you finish them.

How to set it up

1. Make a Jobs tab. Add a tab called Jobs with these columns from A to E: Date, Customer, Email, Done, Review asked. Make Done a checkbox (Insert, then Checkbox).
2. Add your review link. Add a tab called Settings: your business name in B1, your Google review link in B2, and in B3 how many hours to wait after the job is ticked done, such as 2. Your review link is in your Google Business Profile, under Ask for reviews.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Reviews menu appears.
4. Turn on review requests. Choose Reviews, then Start review requests. Once an hour, every job ticked done more than your wait ago gets one email asking for a review, and the date goes in Review asked.
5. Tick jobs as you finish them. Tick Done when the job is finished. Untick it before the wait is up and no email goes. A job that already has a date in Review asked is never emailed again.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• The email greets the customer by first name, thanks them for choosing your business, and gives the review link.
• Google's rules say to ask every customer, not only happy ones, and never to offer anything in return for a review.

Questions

What does this script do?

It is a free Google Apps Script that emails a short Google review request when you tick a job as done in Google Sheets, after a wait you choose, and only once per job.

How do I set it up?

In 5 steps: 1. Make a Jobs tab; 2. Add your review link; 3. Paste the script; 4. Turn on review requests; 5. Tick jobs as you finish them. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.