Meta Pixel
psa-verified-blue

Want to get a blue tick on your WhatsApp number?

Get it now!
cover for the blog post

Send WhatsApp Message From Google Sheets - Easy Guide

author Rohan Rajpal

Rohan Rajpal

Last Updated: 9 December 2024

Everyone maintains their databases on Google sheets. You'd be happy to know that now you can send WhatsApp messages to users by changing value on Google sheets itself! Let's Dive in

  1. A Spur account, you can sign up here.
  2. A Google Sheets account. Link to our template here.
  3. A Zapier paid account. To minimize the steps on Zapier, I have created a template of the Zap we're going to build. Link here.

That's it, now let's setup things on the Spur & WhatsApp side first.

This is the simplest part. Just clone this Google Sheets template.

At the end of this tutorial

  1. You just add a row to this sheet
  2. Change the "Send Now?" column to "Yes"
  3. Wait 2 minutes
  4. As soon as the message is sent, the column value will change to Done
Image

The message column can get quite long, so don't forget to wrap the text, here's a guide for that. As simple as that! Now let's set up the other stuff.

On WhatsApp, there is a concept of a conversation window. Meaning, you cannot message a person any free form message, like you can do with the normal WhatsApp Business App, unless they message you first.

So how do you overcome this? You can however send template messages outside the conversation window. Templates can be of three types, majorly

  1. Utility
  2. Marketing
  3. Authentication

Depending on your use case, you should build the template type, for this tutorial, we'll create a simple Utility template.

We have a detailed guide and video on how to create WhatsApp template. For brevity, I'll mention the steps required for this guide

Image
Image

Now select the number you want to send the message from, name the template "user_account_update_2" or a relevant name to your use case.

Image

Here is the info of the template I've created, you can just copy paste this while testing

    
  
Image

Go to Automations > New Flow > Select the WhatsApp Number > hit "Start From Scratch"

Image

Now we add the trigger, we'll be using Webhooks for this

Image

Now we will select the WhatsApp message to send

Image

Now we connect the trigger to this step

Image

Search for the respective template and hit "Select this Template"

Image

Now we fill in the variables

  1. {{1}} is for the first name, I'll fill it in with `{{contact.firstName||"there"}}`
  2. {{2}} is for the actual message, we will pull in info from the "Message" column in Google Sheets and just replace here
    1. Keep in mind that a variable can have 60 characters max
    2. You can of course use multiple columns in a Google sheet and multiple variable to surpass these limits. I've kept things simple for the sake of this tutorial.
Image

First, clone this Zap Template that I've built.

  1. Change the Google sheets source to your own
  2. Go to the Spur Workflow, click on the trigger an copy the URL
  3. Paste the URL in the "Webhook" action

Image

Image

Select changes to which column will trigger the message
Select changes to which column will trigger the message

Test and select a row with all correct details to move on
Test and select a row with all correct details to move on

Filter out and execute only when the Value is yes, to avoid executions by mistake
Filter out and execute only when the Value is yes, to avoid executions by mistake

Copy the webhook URL, this tells Zapier where to send the data
Copy the webhook URL, this tells Zapier where to send the data

Paste the Webhook URL in the webhook action. Add these fields to the Data part, make sure the payload type is "json"

Make sure you sent the name, message, phone from google sheets to spur's webhook
Make sure you sent the name, message, phone from google sheets to spur's webhook

The moment you hit test here, you should get a message

Test the webhook action, this should send the whatsapp message
Test the webhook action, this should send the whatsapp message

Select which row ID to update
Select which row ID to update

Set the value of the column to "Done" after message is sent
Set the value of the column to "Done" after message is sent

Make sure to PUBLISH the Zap for it to work automatically.

Hit Publish to make the Zap live
Hit Publish to make the Zap live

This requires a bit of an effort to set up, I know. But the convenience of edition from Google Sheets, and it's instantly triggering a WhatsApp message, is super productive. If you can any doubts, reach out to us via the chat widget on the bottom left!

Boost sales this festive season with the Whatsapp BFCM Playbook

Marketing automation, customer support, and WhatsApp Commerce all in one place. Instagram, Facebook, and WhatsApp Business API.

BFCM Playbook

Hi there 👋 How can we help you?

We typically reply in a few mins.

Chat with us on WhatsApp

Chat with us on Email

Powered️ by Spur ⚡️