Summary
Want to automatically send WhatsApp template messages when data in Google Sheets changes? Using Wati and Zapier integration, you can create an automated workflow that triggers a WhatsApp template message when a relevant row or column is added or updated in Google Sheets.
A template message can be triggered when:
A column in an existing row is updated.
New rows are imported into the Google Sheet.
A new row is added by submitting a form.
This guide explains how to connect Google Sheets with Wati using Zapier and configure the workflow to send WhatsApp template messages automatically.
Note: Broadcasts are now called Campaigns. The functionality remains the same, but the name has been updated.
Instructions
Ready to automate your WhatsApp messages? Here's how to set up a Zap using Zapier, Google Sheets, and Wati.
What you'll need
A Zapier account
A Google Sheets account
A Wati account with WhatsApp Business API access
Your Wati API endpoint and access key, available under API Docs in your Wati dashboard
Steps to create the Zap
1. Go to the Wati integration page on Zapier
Open the Wati integration page on Zapier.
Click Make a Zap to begin setting up your automation.
2. Choose Google Sheets as the trigger app
Select Google Sheets as the trigger app.
Select the Google Sheets trigger event that matches the change you want to monitor.
Configure the trigger to monitor the spreadsheet and worksheet you want to use.
The Google Sheets integration can trigger the workflow when:
A column in an existing row is updated.
New rows are imported into the Google Sheet.
A new row is added by submitting a form.
Choose the trigger that matches your workflow.
3. Connect Google Sheets and Wati
Click Connect Wati + Google Sheets.
Click Continue to start configuring your trigger.
4. Authenticate your Google Sheets account
Sign in or select your existing Google account.
Click Continue after authenticating your account.
5. Set up the Google Sheets trigger
Select the spreadsheet and worksheet you want to monitor.
Configure the trigger based on the Google Sheets event you selected.
Click Continue to proceed.
6. Test the trigger
Zapier will fetch sample data from Google Sheets to verify that the trigger is configured correctly.
If the test is successful, click Continue.
Configure the action to send a WhatsApp template message
7. Set Wati as the action app
In the Do this section, select Wati as the app.
Select Send a Template Message via Wati as the action event.
Click Continue.
8. Connect your Wati account
Click Connect a new account.
A pop-up will ask for your Wati API endpoint and access key.
You can find both in your Wati account under API Docs.
Enter the required details and click Continue in the pop-up.
9. Set up the WhatsApp message
In the Zapier setup page, configure the required fields:
template_name: The name of the WhatsApp template you want to send.broadcast_name: A reference name for the message.parameters: Values used to personalize the template message.
These 3 fields are mandatory.
10. Test the action
Click Test & Continue to verify that the WhatsApp template message is sent successfully.
If the configuration is correct, the WhatsApp message will be delivered.
11. Turn on your Zap
Click Turn on Zap to activate the automation.
Once the Zap is active, the configured WhatsApp template message will be automatically sent through Wati when the selected Google Sheets trigger occurs.
Examples of Google Sheets triggers
You can use the Google Sheets and Wati integration for different workflows.
Send a message when an existing row is updated
If a customer record already exists in Google Sheets and a relevant column is updated, the Zap can trigger a WhatsApp template message.
Send a message when new rows are imported
When new rows are imported into the connected Google Sheet, the Zap can trigger the configured WhatsApp template message.
Send a message when a form adds a new row
If a form submission creates a new row in the connected Google Sheet, the Zap can trigger a WhatsApp template message.
Pro Tip
You can create multiple Zaps for different workflows. For example, you can:
Send a WhatsApp message when a new lead is added.
Send an update when information in an existing row changes.
Send a confirmation when a form submission creates a new row.
By connecting Google Sheets with Wati through Zapier, you can automatically send WhatsApp template messages based on changes to your spreadsheet instead of sending each message manually.
Frequently Asked Questions (FAQs)
Google Sheets and Wati Integration
1. What Google Sheets changes can trigger a WhatsApp template message?
A configured Zap can trigger a WhatsApp template message when:
A column in an existing row is updated.
New rows are imported into the Google Sheet.
A new row is added by submitting a form.
2. Can I send a WhatsApp template message when a column in an existing row is updated?
Yes. The Google Sheets and Wati integration can trigger a WhatsApp template message when a relevant column in an existing row is updated.
3. Can I send a WhatsApp template message when new rows are imported or added through a form?
Yes. The integration can trigger a WhatsApp template message when new rows are imported into the connected Google Sheet or when a form submission creates a new row.
Setting Up the Integration
4. What do I need to connect Google Sheets with Wati using Zapier?
You need:
A Zapier account.
A Google Sheets account.
A Wati account with WhatsApp Business API access.
Your Wati API endpoint and access key, available under API Docs in your Wati dashboard.
5. How do I set up Google Sheets as the trigger and Wati as the action in Zapier?
Create a Zap and select Google Sheets as the trigger app. Choose the Google Sheets event you want to monitor, configure the spreadsheet and worksheet, and test the trigger. Then select Wati as the action app and choose Send a Template Message via Wati.
6. Which fields are required to send a WhatsApp template message through Zapier?
The following 3 fields are mandatory:
template_name: The name of the WhatsApp template.broadcast_name: A reference name for the message.parameters: Values used to personalize the template message.
7. How do I activate the Google Sheets and Wati automation?
After configuring and testing the Google Sheets trigger and Wati action, click Turn on Zap. Once active, the configured WhatsApp template message is automatically sent when the selected Google Sheets trigger occurs.
Troubleshooting and Use Cases
8. How can I verify that my Google Sheets trigger is working?
Zapier fetches sample data from Google Sheets when you test the trigger. If the test is successful, click Continue and proceed with configuring the Wati action.
9. What workflows can I create with Google Sheets and Wati?
You can create workflows that automatically send WhatsApp template messages when:
A new lead is added to Google Sheets.
Information in an existing row is updated.
A form submission creates a new row.
You can also create multiple Zaps for different workflows.