Summary
Want to automatically send WhatsApp messages when a new row is added to Google Sheets? With Make (formerly Integromat) and Wati, you can build this workflow in just a few simple steps. This guide will walk you through setting up a scenario in Make that monitors your Google Sheets and sends a WhatsApp template message through Wati when new data is added.
Instructions
What You'll Need
A Make account (a free plan is enough) – Sign up here
A Wati account with WhatsApp Business API access
Access to your Wati API endpoint and Bearer token (available under API Docs in your Wati dashboard)
Steps to Set Up the Workflow
1. Create a New Scenario in Make
Log into your Make dashboard.
Click Create a New Scenario.
Click the + icon and search for Google Sheets.
Select Watch Rows as the trigger event.
https://www.loom.com/share/e950019fe5b34286b2c1d5153eb3928a?sid=99dbcb09-41f2-4950-a791-a483a2d8eb20
2. Prepare Your Google Sheet
Before moving forward:
Create a new Google spreadsheet in your Google Drive.
Add a header row with column titles like
Name,Phone Number, etc.
3. Connect Your Google Sheets Account
In Make, click Add to create a connection to your Google account.
Once connected, choose the Spreadsheet ID and Sheet Name you just created.
Click OK to confirm.
4. Add the HTTP Request to Send a WhatsApp Message
Click the + icon to add another module.
Search for and select the HTTP module.
Choose Make a request.
Configure the HTTP Request
URL:
https://live-server-<wati_number>.wati.io/api/v1/sendTemplateMessage?whatsappNumber=<phone_number>Replace
<wati_number>with your Wati number (find this in API Docs).
Replace
<phone_number>with the WhatsApp number you want to send the message to (in international format, no "+" sign).Method:
POSTHeaders:
Header 1:
Name:
Content-TypeValue:
application/json-patch+jsonHeader 2:
Name:
AuthorizationValue:
Bearer <your_token_here>(Replace<your_token_here>with your Wati Bearer token)Body Type:
RawContent-Type:
application/json
Sample Request Body
This JSON structure will vary depending on your use case and template. Here's a general example:
json { "template_name": "<your_template_name>", "broadcast_name": "your_broadcast_name", "parameters": [ { "name": "<param_1_name>", "value": "<param_1_value>" } ] }
Replace the placeholder values with your actual approved template name and parameter values.
5. Test Your Automation
Add a new row to your Google Sheet with sample data.
Go back to your scenario in Make and click Run once.
If everything is set up correctly, both modules should display a green checkmark, and the WhatsApp message will be sent successfully.
Final Notes
This setup is just one example of how you can integrate Make.com and Wati to automate your workflows. You can apply similar steps for other triggers and actions, like sending messages when a form is submitted or when a CRM lead is added.
Happy automating!
Frequently Asked Questions (FAQs)
General Questions
1. What is Make.com?
→ Make.com (formerly known as Integromat) is an online automation platform that allows you to connect different apps and automate workflows without writing code.
2. What is Wati?
→ Wati is a customer engagement platform that provides WhatsApp Business API solutions, enabling businesses to send automated messages, notifications, and customer support messages via WhatsApp.
Setup Requirements
3. What accounts do I need to complete this setup?
→ You will need:
A Make.com account (the free plan is sufficient).
A Wati account with access to the WhatsApp Business API.
Access to your Wati API endpoint and Bearer token.
4. Where can I find my Wati API token and number?
→ You can find your Wati API token and Wati number in your Wati dashboard under the API Docs section.
Google Sheets Configuration
5. What should my Google Sheet look like?
→ Create a new Google Sheet with a header row. This row should contain column titles like Name and Phone Number. Each new row you add under this header will trigger the WhatsApp message.
6. How does Make.com detect new rows in Google Sheets?
→ In your Make scenario, use the Watch Rows trigger for Google Sheets. This monitors your sheet and triggers the automation when a new row is added.
WhatsApp Message Setup
7. What URL should I use for sending WhatsApp messages?
→ Use the following URL in the HTTP request module:https://live-server-<wati_number>.wati.io/api/v1/sendTemplateMessage?whatsappNumber=<phone_number>Replace <wati_number> with your Wati number and <phone_number> with the recipient's WhatsApp number (in international format without the "+" sign).
8. What HTTP headers do I need to set?
→ Add the following headers:
Content-Type: application/json-patch+jsonAuthorization: Bearer <your_token_here>(replace with your Wati API token)
9. How do I structure the request body for the WhatsApp message?
→ Use the following JSON format:
json { "template_name": "<your_template_name>", "broadcast_name": "your_broadcast_name", "parameters": [ { "name": "<param_1_name>", "value": "<param_1_value>" } ] }
Replace the placeholders with your approved template name and parameter values from Wati.
Troubleshooting
10. How do I test if my setup is working correctly?
→ After setting up the scenario in Make, add a new row to your Google Sheet. Then click Run once in Make. If the setup is correct, both modules should show a green checkmark, and the WhatsApp message will be sent.
11. What should I do if the message is not sent?
→ Check the following:
Ensure your API URL, Wati number, and phone number are correct.
Verify that your Bearer token is valid.
Confirm that your WhatsApp template is approved in Wati.
Review any error messages in Make for more details.
Additional Information
12. Can I use this process for other use cases besides Google Sheets?
→ Yes, you can apply similar steps in Make to send WhatsApp messages using Wati with other triggers, such as form submissions, new CRM leads, or any supported Make module.