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
- STEP2: Creating the WhatsApp Message to send from Google Sheets
- STEP3: Creating WhatsApp Message Link
- STEP4: Click on the Send Button
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)
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.”
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(“//api.whatsapp.com/send?phone=”&B5&”&text=”&C5,”Send“)
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.
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.
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.