Send bulk personalized WhatsApp messages from Google Sheets using Walution add-on
Watch 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 Google Sheets using Walution add-on.
Step 1: Open Google Sheets file
Open the Google Sheets file that is going to be used to send 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 (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.
Before sending messages, you need to set up your phone.
WhatsApp Web must remain open and connected while Walution add-on is being used.
Send Bulk Messages
How do I send bulk personalized WhatsApp messages using Walution add-on?
Step 2: Open Default Country Code dialog box
Click on Extensions > Walution > Default Country Code to open the Default Country Code dialog box.
Step 3: Select default country
Select the default country in the Default Country Code dialog box, and 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: Start Walution add-on
Click on Extensions > Walution > Start to open the Sheet dialog box.
A new column called Message Status is automatically created.
Step 5: Select Phone column
From the WhatsApp Number drop-down menu, 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). For information on formatting phone numbers, refer to this article.
Step 6: Type WhatsApp message
Type a WhatsApp message.
Step 7: Personalize WhatsApp message
Personalize the WhatsApp message by clicking in a desired location within the message template, selecting a field from the Add Personalized Field drop-down menu, and then clicking on Add. Repeat this step as required.
Step 8: Send Test or Send Messages
Once all the required personalized fields have been inserted, there are two options:
A. Send Test: This shows how a WhatsApp message appears to the recipients, before WhatsApp messages are sent in bulk. It sends a test message based on the first row of data in the Google sheet (row 2 since row 1 only contains column names).
B. Send Messages: This queues WhatsApp messages that are going to be sent.
Select one of the options above to send WhatsApp Messages.
NOTE: When 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, refer to this article.