Chat with us by clicking on the bottom right? 🚀Install Chrome Extension
(Try it free)
In this guide article, we will show you how to send WhatsApp messages from Google Sheets.
To send WhatsApp Messages from 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 which, you will be redirected to the Chrome store page of rocketsend.io, and click Add To Chrome.
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.
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 the message to. Have shown a sample below.
After filling out the sheet, click File > Download > Comma Separated Values (.CSV). This will download the file in .CSV format.
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
This will send the message 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.
Wanna know more? Check out our guide about how to send WhatsApp from Microsoft Excel.