Integrate Xero with Google Sheets to automate your work

Triggers when a contact is created or updated.

Triggers when a quote is created or updated.

Creates a new Spend/Receive Money bank transaction.

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

Creates a new credit note for a contact.

Creates an inventory item.

Creates a new sales invoice (Accounts Receivable).

Creates a new project for a contact.

Creates a repeated sales invoice (Accounts Receivable)

Updates existing sales invoice (Accounts Receivable).

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a Purchase Order

Returns a list of History Records for a given Invoice ID.

Finds or creates a specific contact.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

Triggers when a new spreadsheet is created.

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

Create a new column in a specific spreadsheet.

Create one or more new rows in a specific spreadsheet (with line item support).

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Permanently deletes all data in a selected row. This action cannot be undone.

Update a row in a specific spreadsheet.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Triggers when a Sales Invoice is updated.

Adds line items to an existing sales invoice.

Transfers money between two bank accounts.

Creates a new quote draft.

Send Sales Invoice by Email

Creates a new bill (Accounts Payable).

Applies a payment to an invoice.

Creates a new purchase order for a contact.

Updates an existing Purchase Order.

Uploads an attachment to a selected Xero resource. Resources can have a maximum of 10 attachments.

Finds a contact by name or account number.

Finds an invoice by number or reference.

Finds an item by name or code.

Finds or creates an item.

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

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

Triggers when a worksheet is created in a spreadsheet.

Create a new row in a specific spreadsheet.

Creates a new worksheet by copying an existing worksheet.

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

Format a row in a specific spreadsheet.

Update one or more new rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Return up to 500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.