Send WhatsApp store review request from Google Sheets
.webp)
About template
Automatically request store reviews from customers after their order is delivered - once per customer.
HOW IT WORKS:
- Searches for orders with Status = "Delivered"
- Checks WhatsScale CRM for existing contact and tags
- If customer hasn't received review request → Sends message + adds tag
- If customer already has "store-review-sent" tag → Skips
ROUTES:
- Already sent → Skip (no duplicate requests)
- Existing contact, no tag → Add tag + Send review request
- New contact → Create contact with tags + Send review request
SHEET SETUP:
- Column A: Name
- Column B: Phone (with country code)
- Column C: Order ID
- Column D: Status (set to "Delivered" when order arrives)
BENEFITS:
- One review request per customer (not per order)
- No duplicate messages
- No sheet updates needed - CRM tracks everything
- Contacts synced to WhatsScale CRM
CUSTOMIZE:
- Edit review request message
- Add your Google/Trustpilot/Instagram review page link
- Connect to a scheduler to run daily or weekly
Built by WhatsScale. Questions? [email protected]
Similar templates
Find inspiration by the type of content that fits your goals.
Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. Learn more
Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. Learn more about webhooks!
Send a Gmail email from a new Google Sheets row
Effortlessly send Gmail messages when a new row is added to your Google Sheets. Just ensure your spreadsheet includes these columns: Email Address Subject Content