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.
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 broadcast status under the Broadcast 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)
Installation & Setup
1. How do I install the Wati WhatsApp Message Sender add-on in Google Sheets?
→ Open your Google Sheet, go to Extensions > Get add-ons, search for WhatsApp Message Sender Wati, and click Install.
2. Do I need a Wati account to use the add-on?
→ Yes. You can use either a trial account or a paid (live) account with Wati to send messages through the add-on.
3. Where can I find the add-on after installation?
→ Once installed, open your spreadsheet and go to Extensions > WhatsApp Message Sender > WhatsApp Schedule to launch it.
Using the Add-on
4. How do I select phone numbers from my spreadsheet?
→ You can:
Select a range (e.g.,
A2:A6)Input individual cells separated by commas (e.g.,
A2, A3, A5)Combine both (e.g.,
A2:A6, A8, A10)
5. What are the differences between using a trial and a paid account?
→ Trial users get $0.50 in free credits and can top up via the BUY CREDITS button. Paid users connect using API credentials for access to their live Wati environment.
6. How do I connect using a trial account?
→ Click Sign Up for Free Trial, enter your WhatsApp number, agree to the terms, and submit. You'll get $0.50 in credits to start sending messages.
7. How do I connect a paid Wati account?
→ From your Wati dashboard, copy your Access Token and API Endpoint from the API Docs section. Paste them into the respective fields in the add-on, then click TEST and Save.
Message Templates & Sending
8. Can I use message templates with dynamic values?
→ Yes. Select a template and link its variables (e.g., Name, City, Role) to spreadsheet columns like B2:B6.
9. Can I preview my message before sending it?
→ Yes. The add-on shows a preview with the total number of recipients, cost, message content, and available send options.
10. Can I schedule messages instead of sending them immediately?
→ Yes. You can choose to Send Now or Schedule the broadcast by setting a specific date and time.
Delivery & Tracking
11. How do I know if my message was sent successfully?
→ After sending, you'll see a confirmation message. You can also click View Details to see the broadcast status in your Wati dashboard.
12. Where can I find the sent message details?
→ Trial users can view details at app.wati.io, while paid users should check live.wati.io, under the Broadcast section.