Send bulk personalized WhatsApp messages from a Google Sheet.
Watch a Video Tutorial
Watch this quick tutorial, or follow the step-by-step instructions below to find out how to send bulk personalized WhatsApp messages from a Google Sheet.
Open the Google Sheets data file from which you want to send your WhatsApp messages.
You can import your Google Contacts into a Google Sheet by following the steps in this article.
Make sure the first row in your sheet contains column names, such as Name, Phone etc. These column names will be used as personalized fields in your WhatsApp message template.
To be able to send WhatsApp messages, you need to have at least one row of data under your column names.
Before sending messages, you will need to setup your phone
WhatsApp Web must remain open, and connected while you are using Walution
Send Bulk Messages
How do I send bulk personalized WhatsApp messages using Walution?
Click on Extensions > Walution > Default Country Code.
This will open the Default Country Code dialog box.
Select your default country from the Default Country Code dialog box, and then click on Save.
For any phone numbers in your sheet where the country code is not specified, the default country code will be used.
Click on Extensions > Walution > Start.
This will open the Walution sidebar, and a new column will be created in your sheet called Message Status.
From the Sheet drop-down, select the sheet from which you want to send your messages.
From the WhatsApp Number drop-down, select the column containing the recipients' phone numbers.
Typically, this is a column named Phone. All cells in this column must have a valid phone number (except the column name of course). For information on formatting phone numbers, please refer to this article.
Write your WhatsApp message.
Add personalized fields to your WhatsApp message by clicking in the desired location within the message template, selecting a field from the Add Personalized Field to Message drop-down and clicking on Add.
Repeat this step for all the required personalized fields.
Once you have inserted all your personalized fields, you have two options:
A. Send Test: This will give you a good idea of how your WhatsApp message will appear to recipients, before sending the messages in bulk. It will send a test message based on the first row of data in your sheet (that is row 2 since row 1 only contains column names).
B. Send Messages: This will queue your WhatsApp messages for sending.
Select one of the options above to send your WhatsApp Messages.
NOTE: When your messages are sent, the empty cells in the Message Status column are populated with the date/time the messages were sent. To send messages for these rows again, you will need to clear/delete the date/time values. For more information on filtering and tracking rows, please refer to this article.