Connect Google Sheets and WhatsApp Cloud API

Send WhatsApp messages from the sheet you already run the business from. A new booking row can send a confirmation, a status change can tell the customer their order is ready, and a daily run can remind tomorrow's appointments. FlowMattic sends through the WhatsApp Cloud API from your WordPress site and can write what it sent back to the row.

Try FlowMattic free See example workflows

6 triggers 24 actions 6 example workflows 4 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in WhatsApp Cloud API5 actions

1. TriggerNew Spreadsheet Row

2. ActionSend Template Message

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Send Template Message in WhatsApp Cloud API with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Google Sheets and WhatsApp Cloud API workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Send a WhatsApp booking confirmation for each new row

Salons, clinics and tutors add bookings to a sheet. Each new row sends the customer an approved template message with their date and time.

New Spreadsheet RowSend Template Message

Tell customers their order is ready when the status changes

Staff change the status column to Ready and the customer gets a WhatsApp message to come and collect, without anyone typing a number into a phone.

Update Specific Column ValueFilterSend Template Message

Remind tomorrow's appointments every evening

A daily run reads the bookings sheet, loops over the rows and a Filter keeps those dated tomorrow, so each of those customers gets a reminder.

ScheduleGet Row DataIteratorFilterSend Template Message

Send the invoice PDF listed in the row

When a row gets an invoice link, the PDF is sent as a WhatsApp document to the customer in an open conversation, which suits businesses that already chat with clients there.

Update Specific Column ValueSend Document Message

Record the send time back on the row

After the message goes out, Update Cell Data writes the time into a sent column. Staff can see at a glance who has been messaged and who has not.

New Spreadsheet RowSend Template MessageUpdate Cell Data

Alert the owner when stock drops below a level

A stock sheet holds a reorder cell per product. When that cell changes and the number is under your level, the owner gets a WhatsApp text to reorder.

Update Specific Cell DataFilterSend Text Message

Set up: a booking confirmation per row

At the end, each new booking row in your sheet sends the customer a WhatsApp template message.

Prepare a template
In your WhatsApp Business account, create and get approval for a message template with placeholders for the name, date and time.
Connect WhatsApp Cloud API
Under Connects, add WhatsApp Cloud API with the details of your WhatsApp Business phone number.
Connect Google Sheets
Add a Google Sheets connection and give the bookings sheet columns for name, phone, date and time.
Trigger and send
Create a workflow with New Spreadsheet Row, then add Send Template Message, pick the template and map the columns to its placeholders.
Test on your own number
Add a row with your own phone number, check the message arrives, then switch the workflow on.

From Google Sheets	To WhatsApp Cloud API
Phone	Recipient number
Name	Template placeholder 1
Date	Template placeholder 2
Time	Template placeholder 3

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

WhatsApp Cloud API has no triggers in FlowMattic, so customer replies cannot start a workflow here. Workflows start from the sheet, a Schedule or a Webhook.
The text, image, video and document actions send into an existing conversation. To message someone first, use Send Template Message with an approved template.
Store phone numbers with the country code and no spaces, so the recipient field gets a number WhatsApp accepts.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

WhatsApp Cloud API

Integration page

Actions (5)

Send Template MessageSend template message to user's WhatsApp
Send Text MessageSend text message to user created or replied session
Send Image MessageSend image message to user created or replied session
Send Video MessageSend video message to user created or replied session
Send Document MessageSend document message to user created or replied session

Why run this pair with FlowMattic

Google Sheets and WhatsApp Cloud API connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Run messaging from a spreadsheet

Staff who already keep bookings or orders in a sheet send WhatsApp updates by adding rows and changing a status.

Reminders add nothing to FlowMattic's cost

Runs are unlimited on your WordPress server, so a month of confirmations and reminders costs the same in FlowMattic as a single message.

Add site data when you need it

Pull a WooCommerce order or a booking from your WordPress site into the same workflow before the message is sent.

Common questions

Can I send WhatsApp messages from Google Sheets automatically?

Yes. Use a Google Sheets trigger such as New Spreadsheet Row or Update Specific Column Value, and add a WhatsApp Cloud API step. Template messages are used to start a conversation, and text messages work in an open one.

Why do I need a message template?

WhatsApp only allows businesses to start a conversation with an approved template. The other send actions in FlowMattic work in a conversation the customer has already opened.

Can I send bulk messages to everyone on a sheet?

You can loop over rows with Get Row Data and Iterator, sending a template message to each. Only message people who agreed to hear from you on WhatsApp.

Can customer replies be saved to the sheet?

Not with this app, because WhatsApp Cloud API has no triggers in FlowMattic. Replies arrive in the WhatsApp Business inbox you use.

Can I send an image or a video instead of text?

Yes. Put the file URL in a column and use Send Image Message or Send Video Message in an open conversation.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Google Sheets and WhatsApp Cloud API

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, WhatsApp Cloud API integration 1.0.1.