Summary
Want to automatically send WhatsApp messages when a new row is added to Google Sheets? If you're using Wati and have an approved WhatsApp Business API account, you can easily create a Zap (an automated workflow) using our native Zapier integration. This guide walks you through connecting Google Sheets with Wati to send WhatsApp template messages every time a new row is added.
Note: Broadcasts are now Campaigns – same powerful features, updated name!
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
Click Make a Zap to begin setting up your automation.
2. Choose Your App and Trigger
For this example, select Google Sheets as your trigger app.
Choose the trigger event: New Spreadsheet Row.
This means the Zap will activate every time a new row is added to your selected sheet.
3. Connect Google Sheets and Wati
Click the Connect Wati + Google Sheets button.
Press Continue to start configuring your trigger.
4. Authenticate Your Google Sheets Account
Sign in or choose your existing Google account.
Click Continue once authenticated.
5. Set Up the Trigger
Choose the spreadsheet and worksheet you want to monitor for new rows.
Click Continue to proceed.
6. Test the Trigger
Zapier will fetch a sample row to make sure everything is connected properly.
If the test works, click Continue.
Configure the Action to Send a WhatsApp Message
7. Set the Action to Use Wati
In the Do this section, choose Wati as the app.
Select the action event: Send a Template Message via Wati.
Click Continue.
8. Connect Your Wati Account
Click Connect a new account.
A pop-up will appear asking for your Wati API endpoint and access key.
You can find both in your Wati account under API Docs.
Enter the details and click Continue in the pop-up.
9. Set Up the WhatsApp Message
In the Zapier setup page, fill in the following required fields:
template_name: The name of the template you want to send.broadcast_name: A reference name for this message.parameters: Values that personalize the message content.These 3 fields are mandatory.
10. Test the Action
Click Test & Continue to see if the message is sent successfully.
If everything is configured correctly, the WhatsApp message will be delivered.
11. Turn On Your Zap
Click Turn on Zap to make your automation live.
Whenever a new row is added to your selected Google Sheet, a WhatsApp template message will be automatically sent through Wati.
Pro Tip
You can create multiple Zaps to match different workflows. For instance, you might set up a Zap to message new leads added to your CRM or send updates when a form is submitted.
By automating WhatsApp messages using Wati and Zapier, you'll save time and streamline communication with your users.
Frequently Asked Questions (FAQs)
General questions
1. What does this integration help me do?
It allows you to automatically send WhatsApp template messages through Wati whenever a new row is added to a Google Sheet using Zapier.
2. Who is this guide meant for?
This guide is for users who have a Wati account with WhatsApp Business API access and want to automate WhatsApp messaging using Google Sheets and Zapier.
3. Do I need technical knowledge to set this up?
No. The setup uses Zapier’s no-code interface and only requires following step-by-step configuration instructions.
Requirements and setup
4. What accounts do I need before creating the Zap?
You need active accounts on Zapier, Google Sheets, and Wati, along with WhatsApp Business API access enabled on your Wati account.
5. Where can I find my Wati API endpoint and access key?
Both are available in your Wati dashboard under the API Docs section.
6. What triggers the WhatsApp message to be sent?
The message is triggered every time a new row is added to the selected Google Sheets worksheet.
Message configuration
7. What type of WhatsApp message is sent using this Zap?
The Zap sends a WhatsApp template message using Wati.
8. Which fields are mandatory when setting up the message?
The required fields are template_name, broadcast_name, and parameters. All three must be filled for the action to work.
9. Can I personalize the WhatsApp message content?
Yes. You can use the parameters field to map values from Google Sheets and personalize the message.
Testing and usage
10. How do I know if the Zap is working correctly?
Zapier allows you to test both the trigger and the action. A successful test confirms that the message is sent correctly.
11. What happens after I turn on the Zap?
Once the Zap is live, a WhatsApp template message is automatically sent every time a new row is added to the selected sheet.
12. Can I create more than one Zap using Wati?
Yes. You can create multiple Zaps for different workflows, such as notifying new leads or sending updates when forms are submitted.