Send Bulk Messages
How do I send bulk personalized WhatsApp messages using WhatsApp Sender?
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.
NOTE: Using the free limited version of the add-on, messages are sent from a generic phone number. When you buy the full version of the add-on, you can send unlimited messages from your own WhatsApp number.
Click Extensions > WhatsApp Sender > Default Country Code.
This will open the Default Country Code dialog box.
Select your default country from the Country Code dialog box and then click Save.
For any phone numbers in your sheet where the country code is not specified, the default country code will be used.
Click Extensions > WhatsApp Sender > Start.
This will open the WhatsApp Sender 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 Add.
Repeat this step for all 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.