Google Sheets
When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
XeroCreate Sales Invoice

Collaborating with clients and the team in real time can be a challenge with accounting software. With this Google Sheets Xero integration, you can create Xero invoices from a Google Sheets spreadsheet and make it easier to share updates with a team.

Note: This Zapier automation doesn't create invoices from previous rows in Google Sheets, only new ones after you've set it up.

How It Works

  1. A new invoice row is added to a designated Google Sheets worksheet
  2. Zapier creates an invoice in Xero from this row

What You Need

  • Google account with a Google Sheets worksheet
  • Xero account with rights to read/write invoices

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,500+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + Xero and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Bill

Triggered when you add a new bill. (Accounts Payable)

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New Sales Invoice

Triggered when you add a new sales invoice. (Accounts Receivable)

Create Sales Invoice

Creates a new sales invoice (Accounts Receivable).

New Contact

Triggered when you add a new contact.

Create/Update Contact

Creates a new contact or updates a contact if a contact already exists.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn More

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

See Xero Integrations