Send WhatsApp order review request from Google Sheets
.webp)
About template
Automatically request order reviews from customers the day after delivery.
HOW IT WORKS:
- Searches for orders with Delivered Date = Yesterday
- Checks WhatsScale CRM for existing contact
- Sends personalized review request with order ID
- Runs daily - each order processed only once
ROUTES:
- Contact exists → Send review request
- Contact not found → Create contact + Send review request
SHEET SETUP:
- Column A: Name
- Column B: Phone (with country code)
- Column C: Order ID
- Column D: Delivered Date (YYYY-MM-DD format)
BENEFITS:
- Review request per order (not per customer)
- No duplicate messages - time-based filter
- No sheet updates needed
- Contacts synced to WhatsScale CRM
CUSTOMIZE:
- Edit review request message
- Include order ID for context
- Add your review page link
- Connect to a scheduler to run daily
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