Send WhatsApp store review request from Google Sheets

• 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? support@whatsscale.com