Send Automated WhatsApp Messages from Google Sheets by Using BotSailor

Many businesses use Google Sheets to securely store their data and ensure easy access. It can even serve as a data warehouse to streamline business operations. Often, we need to communicate with or send details to leads stored in Google Sheets, but doing this manually can be a major hassle. This is where Google Sheets integrations come in, enabling the automated sending of WhatsApp messages directly from the sheet’s data.

In this article, I will explain how to automatically send a WhatsApp message from Google Sheets. Not only will it send a text message, but it will also pull data from specific Google Sheets columns and use it in the WhatsApp message. Once the campaign is set up on BotSailor, messages will be sent automatically whenever new data is added or any specific events happen to the sheet.

Please follow the below steps to create a successful automation campaign.

Create a Message Template:

First of all, we need a WhatsApp message template because WhatsApp only allows Message Templates for business-initiated messages. If we want to include data from Google Sheets columns in the message, we must use variables within the message template. To create a message template please follow the bellow steps:, 

1. Go to the Bot Manager and then go to Message Template and click on the create button.
2. Provide a name to the template, select the Locale, select template category as marketing, and select header type if you want use any header for the Message Template.
3. Write the message body with variables in it. (These variables will be replaced with Google sheet column data.)
4. Finally, save the message template and close the window.
5. Click on the Sync Template button and see if It’s approved or not. If the template is approved, then it’s good to use it for the automation campaign.

Create Webhook Workflow:

1. From the left side menu click on the Webhook Workflow and then click on the Create button.
2. Give a name to the workflow.
3. Select the appropriate WhatsApp number, if you have multiple numbers.
4. Then select the “Message Template” that you have created for sending the message.
5. Click on the “Create Workflow”.

It will create a Webhook and provide a “Google Sheet trigger Instructions” button. Click on this button to get instructions. This will provide a clear instruction and a block of code. Just copy that code and go to the Google Sheet.

Google sheets must have a column named Phone Number, and other columns data can be used as variable data to use in the message template.

Configure the Google Sheet:

1. From the Google Sheet’s top menu, go to Extensions and click on the App Script. Paste the code that we have copied from the BotSailor. (Replace the existing function). After pasting the code, we must save it by pressing the CTRL + S.

2. After saving the code, from the left side menu, click on the “Triggers” option and then click on “Add Trigger”. From there, select the event type as “On Change” and finally save it.

3. While saving, it may ask to select the google account and verify the app. Just select your google account and then click on the Advanced option and then select “Go to project”. And then just click on Allow button.

Webhook Workflow Mapping:

1. Go back to the BotSailor and click on the “Capture Webhook Response” And then switch back to Google sheet and add sample data to the sheet. This data will be received on BotSailor as raw data, this data will help to Map the data to Message Template.
2. On the phone number field, select the Phone number column data. In the same way, map the row data for the variables that were used in the message templates.
3. Finally, Save the Workflow.

That's it! Now, whenever a row is added to the Google Sheet, BotSailor will send a message to the phone number. This is how we can integrate Google Sheets with BotSailor to automatically send WhatsApp messages.

Watch the Video Tutorial:

Related Articles:

Verify Shopify cash on delivery orders by WhatsApp with BotSailor Webhook Workflow.

How to Send Shopify Order Notifications to WhatsApp by BotSailor Webhook Workflow

Send WooCommerce Order Notifications to WhatsApp by BotSailor Webhook Workflow

Convert WooCommerce COD Order into prepaid order via WhatsApp with BotSailor Webhook Workflow

How to Verify a WooCommerce Cash On Delivery Order by WhatsApp with BotSailor

How to Send a WhatsApp Message When an Elementor form Submission is Recieved

How to Recover a Shopify Abandoned Cart by WhatsApp with BotSailor