How to connect Xero + Google Sheets
Zapier lets you send info between Xero and Google Sheets automatically—no code required.
Popular Xero + Google Sheets 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 Bank TransactionTriggers when a new bank transaction is created.Trigger
- New BillTriggers when you add a new bill. (Accounts Payable)Trigger
- New ContactTriggers when you add a new contact.Trigger
- New PaymentTriggers when you receive a new payment.Trigger
- New Purchase OrderTriggers when a new purchase order is created or enters a status for the first time.Trigger
- New QuoteTriggers when a new quote is created.Trigger
- New Expense Claim ReceiptTriggers when you add a new draft expense claim receipt.Trigger
- New Sales InvoiceTriggers when you add a new sales invoice. (Accounts Receivable)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
- Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
- Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
- Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
- Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
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
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
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.