Google Sheets + Xero Integrations
How to connect Google Sheets + Xero
Zapier lets you send info between Google Sheets and Xero automatically—no code required.
Popular Google Sheets + Xero workflows
Create Xero invoices from new Google Sheets rows
Create Xero invoices from new Google Sheets rowsPremiumAdd rows in Google Sheets from new Xero payments
Add rows in Google Sheets from new Xero paymentsPremium
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 Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
- Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- Xero
Triggers when a new bank transaction is created.
Scheduled
Trigger
- Xero
Triggers when you add a new bill. (Accounts Payable)
Scheduled
Trigger
- Xero
Triggers when you add a new contact.
Scheduled
Trigger
- Xero
Triggers when you receive a new payment.
Scheduled
Trigger
- Xero
Triggers when a new purchase order is created or enters a status for the first time.
Scheduled
Trigger
- Xero
Triggers when a new quote is created.
Scheduled
Trigger
- Xero
Triggers when you add a new draft expense claim receipt.
Scheduled
Trigger
- Xero
Triggers when you add a new sales invoice. (Accounts Receivable)
Scheduled
Trigger
- Xero
Adds line items to an existing sales invoice.
Scheduled
Action
- Xero
Creates a new Spend/Receive Money bank transaction.
Scheduled
Action
- Xero
Transfers money between two bank accounts.
Scheduled
Action
- Xero
Creates a new contact or updates a contact if a contact already exists.
Scheduled
Action
- Xero
Creates a new quote draft.
Scheduled
Action
- Xero
Creates a new credit note for a contact.
Scheduled
Action
- Xero
Sends an invoice via email.
Scheduled
Action
- Xero
Creates a new bill (Accounts Payable).
Scheduled
Action
- Xero
Creates a new sales invoice (Accounts Receivable).
Scheduled
Action
- Xero
Applies a payment to an invoice.
Scheduled
Action
- Xero
Creates a new purchase order for a contact.
Scheduled
Action
- Xero
Finds a contact by name or account number.
Scheduled
Action
- Xero
Finds an invoice by number or reference.
Scheduled
Action
- Xero
Finds or creates a specific contact.
Scheduled
Action
How Google Sheets + Xero Integrations Work
- Step 1: Authenticate Google Sheets and Xero.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
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
About Xero
Related categories
Similar apps
QuickBooks Online
Accounting
FreeAgent
Accounting
Wave
AccountingGet started for free
You can't add more hours to the day. Zapier is the next best thing.