XERO TO GOOGLE SHEETS

Xero to Google Sheets, then WhatsApp.

How to add a Google Sheets row for each new Xero 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)

Insurance broker meeting a client at his desk
Sheet · Renews in 14 days

Illustrative example. Names and details are made up.

STORES & PAYMENTS

The options.

Recommended · Zapier

Trigger, then Google Sheets “Create Spreadsheet Row”

Triggers you can use:

  • New Sales Invoice
  • New Payment (polling)
  • New Contact (polling)
Other ways

Make, webhooks and more

  • Make
Watch out for
  • Some Xero triggers are premium on Zapier.
  • Build a due list: a filtered view of invoices due in three days.

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
  • Invoice
  • Due date
  • Amount
  • Consent: that the person agreed to WhatsApp messages
Xero → Sheet1
ABCDE
1NamePhoneInvoiceDue dateAmount
2Sarah+61 412 000 184INV-30825 Nov$49.00
3Tom+61 433 000 912INV-30836 Nov$29.00
4Ana+64 21 000 457INV-30908 Nov$49.00

Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.

BUILD

Then, in ConvoHut.

  1. 01

    Open Automations, then Create Automation, and choose New Sheet Row as the trigger.

  2. 02

    Pick the spreadsheet and tab, and map Phone and Name.

  3. 03

    Add your approved template, a wait for reply, and a notify step.

  4. 04

    Pass the compliance review for your markets, then Activate Now. Test with your own number first.

Checked against Xero’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 Xero.

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
Three colleagues working together around a laptop