SQUARE TO GOOGLE SHEETS
Square to Google Sheets, then WhatsApp.
How to add a Google Sheets row for each new Square record, so ConvoHut can start a WhatsApp journey from it. This takes Zapier, Make or a webhook.
7-day free trial · about 15 minutes to connect your number · Meta bills message charges to you directly (you add a card in Meta)
Illustrative example. Names and details are made up.
STORES & PAYMENTS
The options.
Trigger, then Google Sheets “Create Spreadsheet Row”
Triggers you can use:
- New Order (polling)
- New Payment (polling)
- New Customer (polling)
- New Appointment (polling)
- New Invoice (polling)
Make, webhooks and more
- Square webhooks to a Google Apps Script web app
- Make
- Manual CSV export from Square Dashboard reports
THE SHEET
The columns to send.
Send one row per record, with the column names in row 1. Phone is the only required column and must include the country code.
- Name
- Phone
- Item
- Location
- Consent: that the person agreed to WhatsApp messages
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Phone | Item | Location |
| 2 | Sarah | +61 412 000 184 | Linen throw | Brunswick |
| 3 | Tom | +61 433 000 912 | Coffee grinder | Richmond |
| 4 | Ana | +64 21 000 457 | Walking shoes | Brunswick |
Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.
BUILD
Then, in ConvoHut.
- 01
Open Automations, then Create Automation, and choose New Sheet Row as the trigger.
- 02
Pick the spreadsheet and tab, and map Phone and Name.
- 03
Add your approved template, a wait for reply, and a notify step.
- 04
Pass the compliance review for your markets, then Activate Now. Test with your own number first.
Checked against Square’s, Zapier’s and Google’s documentation in September 2026. Features, plan requirements and trigger names change; check the current documentation when you set it up. ConvoHut isn’t affiliated with Square.
LIVE NOW · 7-DAY FREE TRIAL
More sales from every conversation.
WhatsApp marketing, sales and support from your own number. 7-day free trial, free onboarding and Meta verification help.
- Meta Tech Provider
- Hosted on AWS
- Australian company
- Your number stays yours
