Send WhatsApp store review request from Google Sheets

Get this template

Get this template

Apps used in template

Google Sheets

WhatsScale - Whatsapp Automation

Flow Control

About

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]

Trusted by thousands of fast-scaling organizations around the globe

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action

Add a Row

Appends a new row to the bottom of the table.

Action

Add a Sheet

Adds a new sheet.

Action

Add a Tag to a CRM Contact

Adds a tag to an existing contact in your WhatsScale CRM

Action

Array aggregator

Combines multiple bundles into a single array. This is the opposite of an Iterator.

Aggregator

Bulk Add Rows (Advanced)

Appends multiple rows to the bottom of the table.

Action

Bulk Update Rows (Advanced)

Updates multiple rows.

Action

Check a WhatsApp Number

Check if a phone number has a WhatsApp account

Action

Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Action

FAQ

Start by registering for Make. As a new Make user, you’ll automatically be assigned a free account. Once your account is set up, you can start creating your first scenarios. We recommend starting with our step-by-step video tutorial.

A scenario represents a workflow or a project of your own creation, and it is made up of a series of modules that automate apps and services. Creating a scenario allows you to transfer and transform data between apps and services via these modules to automate anything and improve the way you work.

Modules are the main building blocks of automation in Make. Modules represent actions that Make performs with an app, like creating, updating, or deleting data.

Mapping links the modules in your scenario. When you map an item, you connect the data retrieved by one module to another module to perform the desired action. For example, you can map email addresses and subject lines to create a spreadsheet using this data.

How it works

Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.

Trusted by 350,000+ customers

"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."

Philipp Weidenbach

Head of Operations at Teleclinic

"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."

Cayden Phipps

COO at Shop Accelerator Martech

"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."

Erkki Markus

Product Owner at Smaily

"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."

Andreas Stryz

CTO & Co-founder at FINN

"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."

Kimberly D

Owner of Media Production