How to
-
5
 min read

How Send WhatsApp Messages From Google Sheets?

In this guide article, we will show you how to send WhatsApp messages from Google Sheets.

Getting started

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. 

This screenshot shows the RocketSend.io homepage.

After which, you will be redirected to the Chrome store page of rocketsend.io, and click Add To Chrome.

This screenshot shows the extension installation page.

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.

The screenshot above shows where you need to click to open the RocketSend.io panel.

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.

The screenshot above shows Google Sheet.

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.

The screenshot above shows a sample Google Sheet.

After filling out the sheet, click File > Download > Comma Separated Values (.CSV). This will download the file in .CSV format.

The screenshot above shows how you can export a CSV file.

Go back to web.whatsapp.com, click the Sender button to open the rocketsend.io pane. Click the Upload CSV button.

The screenshot above shows the upload CSV option.

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.

The gif above shows how you can import the file you exported from Google Sheet previously.

Create the message in Message fields and when all are set, click Send WhatsApp

The screenshot above shows a pane that is ready for sending.

This will send the message across the contact list you uploaded via the .CSV file.

Video Description

Conclusion

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.

John D.
Verified writer
Contact us

Chat with us by clicking on the bottom right? 🚀

Install Chrome Extension
(Try it free)