Send WhatsApp Messages from Google Sheets for Free in 2023
In this article we will show you how to send a WhatsApp message from Google Sheets in just a few clicks. Simply follow the steps below.
How to Send WhatsApp Messages from Google Sheets
There is no official integration between WhatsApp and Google Sheets but there is a WhatsApp Application Programming Interface (API) you can connect to that allows you to send WhatsApp messages from Google Sheets for free.
Follow the Download instructions for your operating system or use WhatsApp Web in your browser (for older Mac Operating Systems).
Connect your account via your mobile app by scanning the QR code that is displayed on your desktop.
2. Create your Google Sheets Workbook
In our example spreadsheet we will add the following details:
You can add more columns if necessary.
We will leave our message column blank as we will be adding dynamic messages in the next steps. You can add static text in this column if you wish to do so.
Tip: Input your phone number with their area code in the beginning of the 10 digit mobile number.
When encoding the phone number, to ensure that the addition sign does not become a function, follow the format:
=“+(Area Code)(10 digit number)”
Remember that the quotation marks are important to display the correct number format.
3. Create your Dynamic Message
We can create dynamic messages that can change content based on other cells.
For our example, we will make messages that change based on our “Name” Column.
To be able to do so in our example, we will use this formula in cell C2 and drag it down to other cells:
="Hi "&A2&". I'm learning how to send WhatsApp Messages from Google Sheets with Lido Tutorials!"
To use this formula for other combinations of text, simply enclose your non-changing (static) text in quotation marks (“”) and add your cell references for the dynamic text by using the ampersand sign (&). Use the & sign before/after text you want to join together.
4. Create a Hyperlink to the WhatsApp API
The hyperlink to the WhatsApp API will be in the form of:
=hyperlink("https://api.whatsapp.com/send?phone="& phone number &"&text="& message,"display text")
Hyperlink: Creates a link to the WhatsApp API.
Phone number: References the cell containing the mobile number, in our example this is in column B so we will reference cell B2.
Message: This will reference the cell containing our dynamic message and will be cell C2 for our example.
Display Text: This is the text that will become our hyperlink text. We will make this display “Send Message” for our current workbook.
Following the breakdown, the final formula for cell D2 will be: