Introduction
You don’t need expensive software to automate review requests. Google Sheets + Apps Script (free) can send automated review request emails/SMS after a service. This post builds a complete review request system — no coding experience required.
What you’ll build
- A Google Sheet tracking customers and service dates
- An Apps Script that sends review request emails automatically
- A daily trigger that runs the script
- Tracking of who was asked and who reviewed
Step 1: Create the Google Sheet
Create a Google Sheet with these columns:
| A: Name | B: Email | C: Phone | D: Service Date | E: Service Type | F: Review Sent | G: Reviewed? | H: Notes |
|---|---|---|---|---|---|---|---|
| Alice | [email protected] | +91 98765 43210 | 2026-03-01 | Haircut | |||
| Bob | [email protected] | +91 98765 43211 | 2026-03-02 | Massage | |||
| Carol | [email protected] | +91 98765 43212 | 2026-03-03 | Facial |
Setup:
- Create a new Google Sheet
- Add headers in row 1
- Add customer data starting from row 2
- Name the sheet “Review Requests”
Step 2: Create the Apps Script
- In your Google Sheet, go to Extensions → Apps Script
- Delete the default code
- Paste this code:
function sendReviewRequests() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = sheet.getDataRange().getValues();
const reviewLink = "https://g.page/your-business/review";
const businessName = "Your Business Name";
const today = new Date();
today.setHours(0, 0, 0, 0);
for (let i = 1; i < data.length; i++) {
const row = data[i];
const name = row[0];
const email = row[1];
const phone = row[2];
const serviceDate = new Date(row[3]);
const serviceType = row[4];
const reviewSent = row[5];
// Skip if already sent
if (reviewSent === "Yes") continue;
// Calculate days since service
const daysSince = Math.floor((today - serviceDate) / (1000 * 60 * 60 * 24));
// Send review request 1 day after service
if (daysSince === 1) {
const subject = `How was your ${serviceType} at ${businessName}?`;
const body = `
Hi ${name},
Thank you for visiting ${businessName}! We hope you enjoyed your ${serviceType}.
If you have a minute, we'd love your feedback:
${reviewLink}
It only takes 30 seconds and helps us serve you better.
Best regards,
${businessName} Team
`;
MailApp.sendEmail(email, subject, body);
// Mark as sent
sheet.getRange(i + 1, 6).setValue("Yes");
sheet.getRange(i + 1, 7).setValue(new Date());
Logger.log(`Review request sent to ${name} (${email})`);
}
}
}
Step 3: Set up the daily trigger
- In Apps Script, click the clock icon (Triggers) on the left
- Click “Add Trigger”
- Settings:
- Function:
sendReviewRequests - Event source: Time-driven
- Type: Day timer
- Time: 9:00 AM - 10:00 AM (or your preferred time)
- Function:
- Click Save
- Authorize the script when prompted
Now the script runs daily at 9 AM, sending review requests to customers whose service was 1 day ago.
Step 4: Track responses
Add a column for “Review Received” and update it manually when a customer leaves a review:
| A: Name | B: Email | C: Phone | D: Service Date | E: Service Type | F: Review Sent | G: Sent Date | H: Reviewed? | I: Rating |
|---|---|---|---|---|---|---|---|---|
| Alice | [email protected] | +91 98765 43210 | 2026-03-01 | Haircut | Yes | 2026-03-02 | Yes | 5⭐ |
Step 5: Add WhatsApp integration (optional)
For WhatsApp, use a service like WATI or Twilio:
function sendWhatsAppReview(phone, name, businessName, reviewLink) {
const url = "https://live-server-XXXX.wati.io/api/v1/sendTemplateMessage";
const payload = {
template_name: "review_request",
broadcast_name: "review_campaign",
parameters: [
{ name: "1", value: name },
{ name: "2", value: businessName },
{ name: "3", value: reviewLink },
],
receivers: [{ whatsappNumber: phone }],
};
const options = {
method: "post",
contentType: "application/json",
headers: { Authorization: "Bearer " + WATI_API_KEY },
payload: JSON.stringify(payload),
};
UrlFetchApp.fetch(url, options);
}
Call this instead of MailApp.sendEmail() for WhatsApp messages.
Step 6: Advanced features
Follow-up (3 days later)
// Add to the script: send follow-up if no review after 3 days
if (daysSince === 4 && reviewSent === "Yes" && reviewed !== "Yes") {
// Send follow-up email
MailApp.sendEmail(email, "Quick reminder", followUpBody);
sheet.getRange(i + 1, 6).setValue("Follow-up sent");
}
Auto-detect reviews (Google Sheets + Apps Script)
Use the Google Business Profile API to check for new reviews and auto-update the “Reviewed?” column:
function checkReviews() {
// Fetch reviews from GBP API
const reviews = fetchGoogleReviews();
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = sheet.getDataRange().getValues();
for (let i = 1; i < data.length; i++) {
const email = data[i][1];
// Check if any review matches this customer
for (const review of reviews) {
if (review.reviewer_email === email) {
sheet.getRange(i + 1, 8).setValue("Yes");
sheet.getRange(i + 1, 9).setValue(review.rating);
}
}
}
}
Monthly summary email
function sendMonthlySummary() {
const data = sheet.getDataRange().getValues();
let total = 0, reviewed = 0;
for (let i = 1; i < data.length; i++) {
total++;
if (data[i][7] === "Yes") reviewed++;
}
const rate = (reviewed / total * 100).toFixed(1);
const body = `Monthly Review Summary:\nTotal customers: ${total}\nReviews received: ${reviewed}\nConversion rate: ${rate}%`;
MailApp.sendEmail("[email protected]", "Monthly Review Summary", body);
}
Common mistakes
- Not getting consent — only email customers who opted in
- Sending too soon — wait 1 day after service (not immediately)
- Sending too late — after 7 days, the experience is forgotten
- No follow-up — one request gets 10-15% conversion; one follow-up gets 25-30%
- Not tracking — if you don’t track, you don’t know what’s working
- Spammy emails — keep it short, personal, and valuable
Key Concepts
- Google Apps Script = JavaScript-based automation for Google Workspace
- Time-driven trigger = scheduled script execution
- MailApp = Apps Script service for sending emails
- UrlFetchApp = Apps Script service for HTTP requests
- Review velocity = reviews per month
What to Try Next
- Automate Google review requests with Python
- Create a Google review link and QR code
- Reply to negative reviews with templates
- Build a review tracking dashboard in Streamlit
FAQ
Is Google Apps Script free?
Yes — completely free. It runs on Google’s servers with generous quotas (100 emails/day for free accounts, 1,500/day for Google Workspace).
Can I send WhatsApp messages from Apps Script?
Not directly — Apps Script doesn’t have a native WhatsApp API. Use UrlFetchApp to call a WhatsApp provider’s API (WATI, Twilio, etc.).
How do I handle customers who don’t have email?
Use SMS or WhatsApp instead. Or collect email at the time of service. If a customer has no email, skip them or use an alternative channel.
Can I use this for other follow-ups (not just reviews)?
Yes — modify the script to send any automated follow-up: appointment reminders, birthday wishes, payment reminders, etc. The pattern is the same: trigger based on a date column. See Automate Google Reviews.