Tech With Galvan
Back to Articles
AutomationJan 3, 2029 • 5 min read

How to Build a Review Request System With Google Sheets

Build an automated Google review request system using Google Sheets and Apps Script — send review requests automatically after a service.

Galvan
Galvan

Founder & Creator

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:

  1. Create a new Google Sheet
  2. Add headers in row 1
  3. Add customer data starting from row 2
  4. Name the sheet “Review Requests”

Step 2: Create the Apps Script

  1. In your Google Sheet, go to Extensions → Apps Script
  2. Delete the default code
  3. 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

  1. In Apps Script, click the clock icon (Triggers) on the left
  2. Click “Add Trigger”
  3. Settings:
    • Function: sendReviewRequests
    • Event source: Time-driven
    • Type: Day timer
    • Time: 9:00 AM - 10:00 AM (or your preferred time)
  4. Click Save
  5. 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

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.