Summary
Need a quick way to send or schedule WhatsApp messages directly from Google Sheets? The Wati WhatsApp Message Sender add-on lets you do just that. This guide walks you through how to install the add-on, connect it with your Wati account (trial or paid), and send messages straight from your spreadsheet.
Note: Broadcasts are now Campaigns – same powerful features, updated name!
Instructions
Follow the steps below to set up and use the Wati add-on with Google Sheets.
Step 1: Install the Add-on
Open your browser and log in to your Google account.
Open a Google Sheets file - you can use an existing one or create a new file.
Click on the Extensions menu (or Add-ons, depending on your interface).
Select Get add-ons.
In the Google Workspace Marketplace, search for WhatsApp Message Sender Wati.
Click Install and follow the prompts to complete the installation.
Step 2: Launch the Add-on
In your Google Sheet, click on Extensions > WhatsApp Message Sender > WhatsApp Schedule.
This will open the Wati add-on in a sidebar on your spreadsheet.
Step 3: Select Phone Numbers
You can specify which contacts to send messages to by selecting their numbers in the sheet:
Range selection: Highlight a group of cells (e.g.,
A2:A6).Manual input: Type individual cells separated by commas (e.g.,
A2, A3, A5, A8).Mixed input: Combine ranges and individual cells (e.g.,
A2:A6, A8, A10).
Once selected, click OK to continue.
Step 4: Choose Account Type
Depending on your Wati setup, choose how you'll connect:
4.1 Using a Trial Account
If you're using the trial version of Wati:
Click Sign Up for a Free Trial if you haven't already.
Enter your WhatsApp number.
Agree to the Terms & Conditions and Privacy Policy.
Click Submit.
You’ll receive $0.50 in your wallet as a trial credit. You can also:
Click BUY CREDITS to top up your balance.
Click About template message fee to view the message pricing.
Click Next to continue.
4.2 Using a Paid Account (Live Environment)
If you're a paid user:
Go to your Wati dashboard and open the API Docs section.
Copy your Access Token and paste it into the
APIKeyfield in the add-on.Copy your API Endpoint and paste it into the
EndPointfield.Click TEST to validate your credentials.
Once successful, click Save to proceed.
Step 5: Create and Customize Message Template
Choose your WhatsApp message template from the dropdown.
Fill in the dynamic values (e.g., Name, City, Role) by referencing spreadsheet columns. Example: You could map
Nameto the rangeB2:B6.
Step 6: Preview and Send
Before sending, you’ll see a preview screen showing:
The number of recipients
Total cost
Message content list
Options to Send Now or Schedule the message
If scheduling, you can pick a specific date and time (in hours and minutes) for delivery.
Step 7: Confirmation and Tracking
After sending:
A confirmation message will appear.
Click View Details to open your Wati dashboard at app.wati.io (for trial users) and live.wati.io (for live users), where you can see the campaign status under the Campaign section.
Wrapping Up
The Wati WhatsApp Message Sender add-on is a powerful tool that brings automation and simplicity to your messaging tasks - right from Google Sheets. Whether you're running a campaign or sending personalized updates, this integration makes it easy to stay connected with your audience.
Frequently Asked Questions (FAQs)
General questions
1. What is the Wati WhatsApp Message Sender add-on for Google Sheets?
It is a Google Sheets add-on that lets you send or schedule WhatsApp messages directly from a spreadsheet using your Wati account.
2. What can I do with this add-on?
You can send WhatsApp messages, schedule them for later, use approved templates, and personalize messages using data from Google Sheets.
3. Do I need a Wati account to use the add-on?
Yes. You can connect the add-on using either a Wati trial account or a paid Wati account.
Installation and setup
4. How do I install the Wati add-on in Google Sheets?
You can install it from the Google Workspace Marketplace by searching for “WhatsApp Message Sender Wati” and completing the installation steps.
5. Where do I access the add-on after installation?
You can launch it from your Google Sheet by going to Extensions > WhatsApp Message Sender > WhatsApp Schedule.
Contact selection and messaging
6. How do I select phone numbers from my spreadsheet?
You can select phone numbers using cell ranges, individual cell references, or a combination of both.
7. Can I personalize messages using spreadsheet data?
Yes. You can map spreadsheet columns, such as name or city, to dynamic fields in your WhatsApp message template.
8. What type of messages can I send using the add-on?
You can send WhatsApp template messages that are available in your connected Wati account.
Account types and credits
9. How does the add-on work with a Wati trial account?
You can sign up for a free trial, verify your WhatsApp number, and use the included wallet credit to send messages.
10. How do I connect a paid Wati account to the add-on?
You need to copy the Access Token and API Endpoint from the API Docs section in your Wati dashboard and validate them in the add-on.
Sending and tracking messages
11. Can I schedule messages instead of sending them immediately?
Yes. You can choose to send messages instantly or schedule them for a specific date and time.
12. Can I preview messages before sending them?
Yes. The preview screen shows the message content, number of recipients, and total cost before you send or schedule the message.
13. Where can I track the status of sent messages?
You can view message and campaign status in your Wati dashboard under the Campaign section, depending on whether you are using a trial or live account.