Integration · Forms and sheets
Google Sheets + WhatsApp: send messages when a row changes
Trigger WhatsApp messages from Google Sheets, or let a bot read and write a sheet. Official Google video plus WA.Expert setup steps.
What is Google Sheets?
Google Sheets is Google's online spreadsheet app, part of Google Workspace, that lets several people edit the same spreadsheet together.
Watch
Official video from Google Workspace
Set up conditional notifications in Google SheetsWatch on YouTube
WA.Expert tutorial
Trigger WhatsApp from a Google Sheet column changeWatch on YouTube
Videos load from YouTube only when you press play.
What businesses do with it on WhatsApp
- Send a WhatsApp when a status column changes, for example Paid or Dispatched
- Let a chatbot look up an order or booking in a sheet and reply
- Save chatbot answers into a sheet row
- Build buttons and lists from sheet data
- Daily reminders from a list of names and dates
How to connect Google Sheets with WA.Expert
- Open the Google Sheet you want to watch.
- In WA.Expert, create an automation with a Custom Webhook trigger and copy the URL.
- In the sheet, open Extensions, then Apps Script, and paste the trigger script linked in our video. Set the column number to watch and the webhook URL.
- Add an onEdit trigger in Apps Script and authorise it.
- Click Capture Incoming Webhook in WA.Expert, change the column once to test, then add a Send Template Message step and enable.
Full walkthrough with screenshots: Trigger automations on a sheet column change.
Questions
Do I need to code?
Only to paste a short ready-made script into Apps Script. You change two values: the column to watch and your webhook URL.
Can a bot read my sheet?
Yes. Google Sheet blocks in the Bot Builder can search a sheet and reply with the matching row.
Is it real time?
Yes. The script fires when the cell is edited, and the message goes out within seconds.