Google Sheets, Xero Integrations

Google Sheets
Xero
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

Google Sheets

Watch a worksheet

Triggers when a user adds a new row to a selected worksheet.

Xero

Watch receipts

Triggers when a new receipt is added or an existing receipt is updated.

Xero

Watch invoices

Triggers when a new invoice is added or an existing invoice is updated.

Xero

Watch credit notes

Triggers when a new credit note is added or an existing credit note is updated.

Xero

Watch bank transactions

Triggers when a new transaction is added or an existing transaction is updated.

Xero

Watch bank transfers

Triggers when a new bank transfer is created.

Xero

Watch employees

Triggers when a new employee is added or an existing employee is updated.

Xero

Watch purchase orders

Triggers when a new order is added or an existing order is updated.

Xero

Watch contacts

Triggers when a contact is created or updated.

Xero

Watch payments

Triggers when a payment is created or updated.

Actions

Google Sheets

Add a row

Google Sheets

Update a row

Google Sheets

Delete a row

Google Sheets

Select rows

Returns rows that match the criteria specified in a selected worksheet.

Google Sheets

Update a cell

Google Sheets

Add a worksheet

Google Sheets

Delete a worksheet

Google Sheets

Get a cell

Returns the contents of a specified cell.

Google Sheets

List worksheets

Gets a list of worksheets in spreadsheet.

Xero

Create a receipt

Creates a new receipt.

Xero

Get a receipt

Returns information about a receipt with a given ID.

Xero

Create an invoice

Creates a new invoice.

Xero

Get an invoice

Returns information about an invoice with a given ID.

Xero

Create a credit note

Creates a new credit note.

Xero

Get a credit note

Returns information about a credit note with a specified ID.

Xero

Create a bank transaction

Creates a new bank transaction.

Xero

Get a bank transaction

Returns information about a transaction with a specified ID.

Xero

Create a bank transfer

Transfers a specified amount from one account to another.

Xero

Create an employee

Creates a new employee.

Xero

Create a purchase order

Creates a new purchase order.

Xero

Get a purchase order

Returns information about a purchase order with a specified ID.

Xero

Create a contact

Creates a new contact.

Xero

Update a contact

Updates a contact by ID.

Xero

Archive a contact

Archives a contact with a given ID.

Xero

Create a contact group

Creates a new contact group.

Xero

Add a contact to a contact group

Adds a contact to a specified contact group.

Xero

Remove a contact from a contact group

Removes a contact from a contact group.

Xero

Delete a contact group

Deletes a contact group with a specified ID.

Xero

Create a history note

Adds a note to a record.

Xero

Create an item

Creates a new item.

Xero

Get a contact

Retrieves contact information by ID.

Xero

Get an account

Returns information about an acccount with a specified ID.

Xero

Get an invoice URL

Retrieves Xero online invoice URL.

Xero

Get an item

Searches for an item by item ID or item code.

Xero

Get a payment

Retrieves information about a payment with a specified ID.

Xero

Get bank statements report

Returns bank statements for a selected bank account.

Xero

Get bank summary

Returns the balances and cash movements for each bank account.

Xero

Get history of changes

Retrieves the changes made to a given object.

Xero

Search for a contact

Searches for a contact by name or email.

Xero

Search for an account

Finds an account by ID, name, or code.

Xero

Search for an invoice

Searches for an invoice

Xero

Search for a tax rate

Finds a tax rate by name.

Xero

Send an invoice via email

The email will be sent to the primary email address of the contact on the invoice. The invoice must be of Type ACCREC and a valid Status for sending (SUMBITTED,AUTHORISED or PAID).

Xero

Update an employee

Updates an employee by ID.

Xero

Update an invoice

Updates an invoice with a given ID.

Xero

Update an item

Updates an item by ID.

Xero

Update a payment

Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.

Xero

Upload a file

Uploads a file to an invoice, receipt, contact or another item.

Integrate Google Sheets, Xero with these services