Xero + Google Sheets Integrations
How to connect Xero + Google Sheets
Zapier lets you send info between Xero and Google Sheets automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Quickly automate Xero and Google Sheets workflows with Zapier's templates
Our most popular Zap!
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
New Bank Transaction
Triggers when a new bank transaction is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Contact
Triggers when you add a new contact.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planQuote Status
If left empty, Zapier will trigger on all new quotes, regardless of status.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTransaction TypeRequired
ContactRequired
Bank AccountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
Bank Account Number
Groups
Add contact to selected group(s). Does not replace contact's existing groups.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
ContactRequired
Date
Defaults to today's date if not specified.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Email Address
Status
Defaults to Draft if not specified.
Date
Defaults to creation date if not specified.
Due Date
A due date is required for approved invoices.
Currency
Default currency for organization will be used if not specified.
Url
URL link to a source document.
Attachment
Branding Theme
The branding theme to use for this invoice.
Reference
Non-unique alpha numeric code identifying the bill.
Url
URL link to a source document.
Line Items Type
Line amounts are exclusive of tax by default if you don't specify this element.
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
Tracking
For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document Type
What you'll you provide the ID or number for via the next field.
Document ID or NumberRequired
The ID or Number for the selected Document Type.
Paid ToRequired
The bank account or clearing account the payment is being made to.
Date
Currency Rate
Exchange rate when payment is received. Only used for non base currency invoices.
AmountRequired
Reference
An optional description for the payment.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch 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
Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.
Bank Account Number
Groups
Add contact to selected group(s). Does not replace contact's existing groups.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Expense Claim Receipt
Triggers when you add a new draft expense claim receipt.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoiceRequired
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From AccountRequired
The bank account the payment is being made from.
To AccountRequired
The bank account the payment is being made to.
AmountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
Date
Defaults to current date if not specified.
Expiry
Quote Number
If you want Xero to auto-generate a Quote Number for you, leave this field blank.
Reference
Theme
Title
Summary
Currency
Amounts Are
Defaults to Tax Exclusive if not specified
Item Code
DescriptionRequired
Quantity
Unit Price
Discount %
Account
Tax Rate
Terms
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice NumberRequired
To email an invoice, it must have a status of Awaiting Approval, Awaiting Payment or Paid. The email will be sent to the primary email address of the contact on the invoice and any others marked as "Include in emails." The subject and body of the email will be based on the default email template.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Email Address
Status
Defaults to Draft if not specified.
Date
Defaults to creation date if not specified.
Due Date
A due date is required for approved invoices.
Currency
Default currency for organization will be used if not specified.
Url
URL link to a source document.
Attachment
Branding Theme
The branding theme to use for this invoice.
Number
Unique alpha numeric code identifying invoice - leave blank for auto-generated value.
Reference
An additional reference number
Url
URL link to a source document.
Sent To Contact
Mark invoice as "sent" (note: does not actually send an email). This can be set only on invoices that have a status of "approved" You can set this in the Status field above.
Line Items Type
Line amounts are exclusive of tax by default if you don't specify this element.
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
Tracking
For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact (supplier)Required
Date
When the purchase order was issued. Defaults to today's date if not specified.
Delivery Date
Order Number
If left blank, Xero will auto-generate this from your default invoice numbering.
Reference
Theme
Currency
Tax Type
Item Code
You must provide either an Item Code or both a Description and a Unit Price.
Description
If no Item Code is provided, this field is required.
QuantityRequired
Unit Price
If no Item Code is provided, this field is required.
Discount %
Account
Tax Rate
Only specify if you want to override the default tax type for the account above.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Xero are located here https://developer.xero.com/documentation/api/accounting/overview
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
How Xero + Google Sheets Integrations Work
- Step 1: Authenticate Xero and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Google Sheets Tutorials
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 moreRelated categories
Similar apps
QuickBooks Online
Accounting
FreeAgent
Accounting
Wave
Accounting
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreRelated categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
DocumentsGet started for free
You can't add more hours to the day. Zapier is the next best thing.
Other Xero + Google Sheets Integrations
- trello
- pipedrive
- ebay
- webhook
- typeform
- shopify
- code
- zapier-chrome-extension
- schedule
- hubspot
- google-drive
- airtable
- wufoo
- mailchimp
- jotform
- email-parser
- pandadoc
- keap-max-classic
- gravity-forms
- google-forms
- google-contacts
- sms
- moxtra
- microsoft-outlook
- excel
- zendesk-sell
- woocommerce
- thrivecart
- paypal
- mysql
- monday
- magento
- looping
- google-docs
- glide-apps
- freshdesk
- clickup
- activecampaign
- zoho-inventory
- zoho-forms
- zendesk
- wpforms
- upkeep
- teamwork
- sugarcrm
- streak
- signrequest
- salesmsg
- salesforceiq
- ronin
- proposify
- podio
- pdffiller
- ontraport
- onedrive
- neto
- nethunt-crm
- lead-information
- knack
- kartra
- jira
- insightly
- highrise
- harvest
- google-tasks
- google-maps
- getresponse
- formstack-documents
- fastfield
- evernote
- eventbrite
- dubsado
- dropbox
- docparser
- dext
- devicemagic
- desk
- dear-inventory
- closeio
- clicksend
- clickfunnels
- clickatell
- chargebee
- capsule-crm
- campaign-monitor
- calendly
- bubble
- asana
- amazon-seller-central-le
- convertapi
Other Xero + Google Sheets Integrations
Workflows From Zapier Users
- Create bill from invoice
- New payment in Xero (all) > add to Google Sheet
- Tareo New B2B deals
- Stripe to Xero Integration
- Copy: RC CN Post to Xero
- RC CN Post to Xero
- AU Ecommerce - ($1,400) - Incorporation & Company Accounting Plan
- Sheets to Xero treasury check
- JP - FN - Extra Service Invoice Automation
- Sign a Proposal In Better Propsals - Xero - AC
- BHT New Customer Registration
- Invoices
- Create spreadsheet row in Google Sheets when new sales invoice in Xero
- Update Contacts in Xero
- treasury deposit campaign
- ITIN Invoice to Other Address
- Xero → Google Sheet with AR Data