Skip to main content

How to Send WhatsApp Messages from Google Sheets Using Zapier and Wati

Updated this week

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.

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)

Getting Started

1. What do I need before setting up the Zap?

→ You'll need a Zapier account, a Google Sheets account, a Wati account with WhatsApp Business API access, and your Wati API endpoint and access key (available in your Wati dashboard under API Docs).

2. Where can I find my Wati API details?

→ You can find your Wati API endpoint and access key by logging into your Wati account and navigating to the API Docs section.

Trigger Setup (Google Sheets)

3. What triggers the WhatsApp message to send?

→ The message is triggered when a new row is added to the selected Google Sheet.

4. Can I choose which spreadsheet and worksheet to monitor?

→ Yes, during setup, you'll be asked to select the specific spreadsheet and worksheet you want Zapier to monitor for new rows.

5. Do I need to test the trigger?

→ Yes, Zapier will run a test to make sure it can detect a new row in your selected sheet before you proceed.

Action Setup (Wati)

6. What is the action in this Zap?

→ The action is sending a WhatsApp template message via Wati when a new row is added to your Google Sheet.

7. What fields do I need to fill out to send the WhatsApp message?

→ You must fill out three fields:

  • template_name: The name of the message template.

  • broadcast_name: A reference name for the broadcast.

  • parameters: Values used to customize the message content.

8. How do I connect my Wati account to Zapier?

→ When setting up the action, click Connect a new account and enter your Wati API endpoint and access key when prompted.

9. How do I know if the setup is working?

→ After configuring your action, click Test & Continue in Zapier. If successful, the WhatsApp message will be sent using your template and data.

Troubleshooting and Tips

10. What should I do if the test fails?

→ Double-check your Wati API credentials, make sure your template name and parameters match what's configured in Wati, and ensure the Google Sheet has valid data in the test row.

11. Can I create more than one Zap for different workflows?

→ Yes, you can create multiple Zaps to handle different scenarios—for example, sending messages for new CRM leads or form submissions.

12. Do I need to turn the Zap on manually?

→ Yes, once testing is complete, click Turn on Zap to make it active. The automation won't run until it's turned on.

Did this answer your question?