Google Sheets + Xero

Save new Xero invoices to Google Sheets rows

Collaborating with clients and the team in real time can be a challenge with typical accounting software. With this Xero-Google Sheets integration, you'll automatically save new Xero invoices to a Google Sheets spreadsheet row and easily share updates!

When this happens...
New Sales Invoice
Triggers when you add a new sales invoice. (Accounts Receivable)
TriggerScheduled
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Bank Transaction
Triggers when a new bank transaction is created.
Trigger
Scheduled
Try It
New Contact
Triggers when you add a new contact.
Trigger
Scheduled
Try It
- Quote Status
Trigger
Scheduled
Try It
- Status
Trigger
Scheduled
Try It
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write

- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Write
- TypeRequired
- ContactRequired
- Date
Action
Write

- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Url
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- Welcome
Action
Write
- Search ByRequired
Action
Search
- Search ByRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write

- Status
Trigger
Scheduled
Try It
- Payment Type
Trigger
Scheduled
Try It
New Expense Claim Receipt
Triggers when you add a new draft expense claim receipt.
Trigger
Scheduled
Try It
- InvoiceRequired
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Account
- Tax Rate
Action
Write
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Item Code
- DescriptionRequired
- Quantity
- Unit Price
- Discount %
- Account
- Tax Rate
- Terms
Action
Write
- Invoice NumberRequired
Action
Write
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Url
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Account
- Tax Rate
- Tracking
Action
Write
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Account
- Tax Rate
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search ByRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Welcome
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write

About Google Sheets

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

Learn more Help

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Xero

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.

Learn more Help

Related categories

Accounting

Similar apps

QuickBooks Online

Accounting

FreeAgent

Accounting

Wave

Accounting

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Google Sheets + Xero

Save new Xero invoices to Google Sheets rows

New Bank Transaction

New Contact

New Quote

Quote Status

New Sales Invoice

Status

Create Bank Transaction

Transaction TypeRequired

ContactRequired

Bank AccountRequired

Date

Create/Update Contact

Contact NameRequired

Account Number

Primary Person - First Name

Primary Person - Last Name

Primary Person - Email

Phone - Country Code

Phone - Area Code

Phone Number

Fax - Country Code

Fax - Area Code

Fax - Number

Mobile - Country Code

Mobile - Area Code

Mobile - Number

Direct Dial - Country Code

Direct Dial - Area Code

Direct Dial - Number

Address Type Of

Address - Attention

Address - Line 1

Address - Line 2

Address - City/Town

Address - State/Region

Address - Postal/Zip Code

Address - Country

Tax Number

Bank Account Number

Groups

Create Credit Note

TypeRequired

ContactRequired

Date

Create Bill

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Reference

Url

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Account

Tax Rate

Tracking

Create Payment

Document Type

Document ID or NumberRequired

Paid ToRequired

Date

Currency Rate

AmountRequired

Reference

App Extensions (Beta)

Welcome

Find Contact

Search ByRequired

Find or Create Contact

Search ByRequired