How to Send WhatsApp Messages from Google Sheets

How to Send WhatsApp Messages from Google Sheets
Reading Time: 3 minutes

WhatsApp and Google Sheets are two significant platforms used in daily life. Ever had an instance, when you had to send a number of messages to your customers or contacts and wanted to reduce the manual effort for the same?

Now, what if I tell you that you can send WhatsApp Messages from Google Sheets? Sounds interesting, right? 

This article will provide you with step-by-step assistance with a cost-free solution to send WhatsApp messages from Google Sheets.

You can also watch the following video for the same.

YouTube Video: Send WHATSAPP Messages through GOOGLE SHEETS || Latest tutorial 2022

You can also check out the spreadsheet template below to get a hands-on experience with it.

Free Google Sheet Template to Send WhatsApp Messages

How to Send WhatsApp Messages from Google Sheets:

STEP1: Adding data to the spreadsheet

Create a spreadsheet with Column 1 for storing the names of the contacts and Column 2 for their respective WhatsApp Numbers.

Note: Do not forget to add the country code in front of the phone numbers!

(Example: +91-987654321 would be written as ‘+91-987654321 in the Column 2 cells)

Adding WhatsApp Contacts Data to the Spreadsheet to send WhatsApp Messages from Google Sheets
Figure 1: Adding WhatsApp Contacts Data to the Spreadsheet

STEP2: Creating the WhatsApp Message to send from Google Sheets

Add the message in the next column using the following syntax:

=“&A5&” 

Hence, the final message Syntax for the given example would be: 

=”Hi “&A5&”, Welcome to the Team.”

Creating the WhatsApp Message to send from Google Sheets
Figure 2: Creating the WhatsApp Message to send from Google Sheets

Copy the Syntax for the rest of the rows.

STEP3: Creating WhatsApp Message Link

Create another column for linking the messages to WhatsApp by using the HYPERLINK feature.

The above syntax would enable you to send the message in cell C5 to the contact number in cell B5.

=HYPERLINK(“https://api.whatsapp.com/send?phone=”&B5&”&text=”&C5,”Send“)

Figure 3: Creating the WhatsApp Message Link to send from Google Sheets

Copy the Syntax for other rows as well. 

STEP4: Click on the Send Button

We are almost done with the process now. All you have to do is click on the Send link displayed in column D to send WhatsApp Messages from Google Sheets.

Figure 4: Sending the WhatsApp Message from Google Sheets

You will be redirected to the WhatsApp Page, where you have to click on the option Continue to Chat and select either WhatsApp Web or the WhatsApp App installed on your desktop.

Press Enter and your WhatsApp message will be sent to the contact.

You can send multiple messages just by clicking on the SEND link in the spreadsheet.

Final WhatsApp Chat Image showing Multiple messages sent on WhatsApp from Google Sheets
Figure 5: Final WhatsApp Chat Messages

Conclusion

To send WhatsApp messages from Google Sheets can prove to be quite useful if the number of people targeted is huge and messages to be sent need to be semi-personalized.

If you liked this article, you may want to check out our complete guide to Whatsapp Cloud API.

See Also

Want to know more about such cool hacks for Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics here. Enjoy reading!

Tips and Tricks: Working with Date and Time in Google Sheets: Learn how to work with dates and time in Google Sheets

Slow Google Sheets? Tricks you can use to speed up your sheet: In this article, we would look at why you are facing issues with slow google sheets. We would also look at some tips you can use to make your sheets run faster.

One response to “How to Send WhatsApp Messages from Google Sheets”

Leave a Reply