Chat with us by clicking on the bottom right? 🚀Install Chrome Extension
(Try for free)
In this guide article, we will show you how to send WhatsApp messages from Google Sheets.
To send WhatsApp Messages through Google Sheet, you just need the rocketsend.io Chrome extension installed on your Chrome browser.
To do this, just go to rocketsend.io, and click the Install Chrome Extension button.
After successful installation, go to your WhatsApp web by visiting web.whatsapp.com. Click the Sender button on the top left corner of the page to open the rocketsend.io pane. This will be shown on the right hand side of your WhatsApp Web which can be used in sending messages.
Let’s now prepare the Google Sheet file to be uploaded via rocketsend.io Chrome extension. Head to sheets.google.com, and create a blank sheet to create a new file. After which, a new Google Sheets spreadsheet will be opened.
Create the Phone Number and Name column, as the list of the people you want to send WhatsApp messages to. Have shown a sample below.
After filling out the sheet, click File > Download > Comma Separated Values (.CSV). This will download the file of phone numbers and names in .CSV format.
The same file preparation can also be done through Microsoft Excel. Check out this related article for more details.
Send the WhatsApp Messages through rocketsend.io. After preparing the file, go back to web.whatsapp.com, click the Sender button to open the rocketsend.io pane. Click the Upload CSV button.
Select the file you downloaded, and map the numbers column where the contact details will be based from. You can also verify the imported list of phone numbers on the Phone Numbers section.
Create the message in Message fields and when all are set, click Send WhatsApp
With its powerful and customizable WhatsApp messaging features, you can send announcements, events, and even use this for marketing and customer service needs of our business.
This will send the WhatsApp message to each phone number across the contact list you uploaded via the .CSV file.
Even when you don’t have MS Excel installed on your computer, you can still use the Upload CSV feature of rocketsend.io with Google Sheets. All you need is your Chrome browser, and an internet connection.