Skip to content
ClickRuntime

Connect Google Sheets to WhatsApp Business

WhatsApp is where many customers and staff actually reply, and a Google Sheet is often where the list, the catalogue or the numbers live. Connecting them sends reminders, alerts and broadcasts to the people in your sheet, and logs what comes back in on WhatsApp.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and WhatsApp Business

Reminders, broadcasts, alerts and support answers between your sheets and WhatsApp. These are ready-made starting points. Anything else you can describe works too.
The moment it happensAI

Answer WhatsApp questions from a product sheet

Customers who message your WhatsApp number get an instant answer drawn from the products and FAQs in your Google Sheet.

See how it works
On a schedule

Send WhatsApp messages to everyone in a sheet

Everyone marked pending in your sheet gets a personalised WhatsApp template message, and the sheet records whether it was sent.

See how it works
The moment it happensAI

Log WhatsApp requests in a sheet with a category

Each request sent to your WhatsApp number is sorted by type and urgency, added to a sheet and acknowledged with a reference number.

See how it works
Daily

Get a WhatsApp alert when a sheet value crosses a limit

When a number you track in your sheet goes past its limit, you get one WhatsApp message about it.

See how it works
The moment it happensAI

Follow up unhappy customers on WhatsApp

Feedback is scored for sentiment and logged in your sheet, and customers who were unhappy get a WhatsApp message offering to put it right.

See how it works
Weekly

Get a weekly sales summary on WhatsApp

Every Monday morning your sales totals, the change on last week and a simple forecast arrive on WhatsApp.

See how it works
Daily

Send WhatsApp reminders on the dates in a sheet

People in your sheet get a WhatsApp reminder on the day you set, and the sheet marks it as sent.

See how it works
The moment it happens

Get website leads on WhatsApp and log them in a sheet

Each contact form lead is added to your sheet and sent to your phone on WhatsApp straight away.

See how it works
Every 5 minutes

Monitor endpoints from a sheet with WhatsApp alerts

The addresses in your sheet are checked every 5 minutes, their status is written back, and you get a WhatsApp message when one fails or recovers.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and WhatsApp Business, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and WhatsApp Business automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and WhatsApp Business in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Send WhatsApp reminders only to rows where Status is Booked and the appointment is tomorrow, and mark Reminded with the time sent.

When a WhatsApp message comes in, log it to my sheet and reply only if the AI is confident the answer is in my FAQ sheet, otherwise mark it for a person.

Use cases

Why people connect Google Sheets and WhatsApp Business

How the two apps work together

  • Incoming WhatsApp messages reach a trigger link right away through the WhatsApp Business Platform webhook.
  • The script checks the sheet every few minutes for rows due a message, such as reminders or broadcasts.
  • Replies and delivery status are written back to the matching row.

  • Clinics send appointment reminders

    Appointment times in a sheet trigger WhatsApp reminders the day before. Fewer patients miss their slot.

  • Small shops track orders from WhatsApp

    Incoming WhatsApp orders are logged to a sheet with name, phone and items. The owner packs from one list.

  • Event organisers confirm attendance

    Guests in a sheet get a WhatsApp message and their reply is written back as Yes or No. Headcounts update without calls.

  • Support teams answer common questions

    A sheet of questions and answers is used to reply to WhatsApp messages. The team updates answers by editing the sheet.

More apps

Google Sheets, WhatsApp Business and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Calendar reminders over WhatsApp with a sheet log

Each evening, send a WhatsApp reminder to everyone with an appointment tomorrow on my Google Calendar and log who confirmed in my Reminders sheet.

Payment links sent by WhatsApp from a sheet

For each row in my Invoices sheet marked Send, create a Stripe payment link and send it to the customer on WhatsApp.

Hand off WhatsApp requests to Slack

When a WhatsApp message logged in my sheet is classified as a complaint, post it in #support on Slack with the customer's phone number.

Setup

Connect Google Sheets and WhatsApp Business once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

WhatsApp Business

Messaging

  1. At developers.facebook.com/apps, create a Business app and add the WhatsApp product to it.
  2. In business.facebook.com, open Business Settings, go to System users and add one. Assign it the app with Manage app and your WhatsApp account with Manage WhatsApp Business accounts.
  3. Generate a token for that system user, select the app and add business_management, whatsapp_business_messaging and whatsapp_business_management, then copy it.
  4. Under WhatsApp, API Setup, note your Phone Number ID and WhatsApp Business Account ID.
  5. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for WhatsApp Business, along with the two IDs.

FAQ

Questions about connecting Google Sheets and WhatsApp Business

Do I need the WhatsApp Business API?
Yes. These automations use the WhatsApp Business Platform from Meta, not the WhatsApp Business phone app. You set up a number in Meta's developer dashboard and save its access token in your ClickRuntime dashboard.
Why do some messages need an approved template?
WhatsApp only lets businesses start a conversation, or write more than 24 hours after the customer last messaged, with a template Meta has approved. Replies within 24 hours can be free text.
What format should phone numbers be in the sheet?
International format with the country code and no spaces or plus sign, for example 447700900123.
Does WhatsApp charge for messages?
Meta charges per conversation for some message types, depending on the country and category. Check Meta's pricing for your numbers.
Can it reply to customers automatically?
Yes, within 24 hours of the customer's last message you can reply freely. After that, WhatsApp requires an approved message template.
Can it handle images or voice notes?
Yes. Media from incoming messages can be downloaded and stored, and the built-in AI can describe images.
Does it work with the WhatsApp Business app?
No. It uses the WhatsApp Business Platform (Cloud API), which is separate from the phone app.

Related pages

Keep exploring

Tell your assistant what Google Sheets and WhatsApp Business should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude