Send bulk personalized WhatsApp messages using 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 using a Google Sheet.

Step 1

Open the Google Sheets file that is going to be used to send the WhatsApp messages.

Google Contacts can be imported into a Google Sheet by following the steps in this article.

Make sure the first row in the Google sheet contains column names, such as Name, Phone etc. These column names are used as personalized fields in the WhatsApp message template.

To be able to send WhatsApp messages, there needs to be at least one row of data under the column names.

NOTES:

Send Bulk Messages

How do I send bulk personalized WhatsApp messages using the Walution add-on?

Step 2

Click on Extensions > Walution > Default Country Code to open the Default Country Code dialog box.

Step 3

Select the default country from the Default Country Code dialog box, then click on Save.

For any phone number in the Google sheet where the country code is not specified, the default country code is used.

Step 4

Click on Extensions > Walution > Start to open the Sheet dialog box.

A new column called Message Status is automatically created.

Step 5

From the WhatsApp Number drop-down, select the Phone column containing the recipients' phone numbers.

All rows in the Phone column must have a valid phone number (except the column name of course). For information on formatting phone numbers, please refer to this article.

Step 6

Enter the WhatsApp message.

Step 7

Personalize the WhatsApp message by clicking in a desired location within the message template, selecting a field from the Add Personalized Field drop-down, then clicking on Add. Repeat this step as required.

Personalized fields are the column names found in the first row of data in the Google Sheet. The WhatsApp message can be further customized by formatting the message text and adding attachments.

Step 8

Once all the required personalized fields have been inserted, there are two options:

A. Send Test: This gives a good idea of how the WhatsApp message appears to recipients, before the WhatsApp messages are sent in bulk. It sends a test message based on the first row of data in the Google sheet (that is row 2 since row 1 only contains column names).

B. Send Messages: This queues the WhatsApp messages for sending.

Select one of the options above to send the WhatsApp Messages.

NOTE: When the WhatsApp messages are sent, the empty rows in the Message Status column are populated with the dates/times the WhatsApp messages were sent. To send WhatsApp messages for these rows again, the date/time values need to be cleared/deleted. For more information on filtering and tracking rows, please refer to this article.