Just takes 30 seconds to connect Google Sheets & Xero
Give it a try. 7000+ customers use Automate.io to connect their business apps.
Product Overview
Explore all the benefits and features of Automate.io
Generate invoices and automatically process payments in Xero. Create new rows, search and update them in Google Sheets. Do much more by connecting Google Sheets and Xero.
Looking for something else?
Connect Google Sheets and Xero the way you want. Start by selecting the trigger and action events listed here.
New Row
Triggers when a new row is added in a worksheet.
New or Updated Row
Triggers when a new row is added or existing row is updated in a worksheet
Updated Row
Triggers when an existing row is updated
New Spreadsheet
Triggers when a new spreadsheet is created.
New Worksheet
Triggers when a new worksheet is created.
New Comment
Triggers when a new comment is added in a spreadsheet
New or Modified Contact
Triggers when a new contact is created or an existing one is modified
New Overpayment
Triggers when a new overpayment is generated
New Payment
Triggers when a new payment is added to xero
Invoice Status Change
Triggers when a the status of the sales invoice changes to a particular value
New Sales Invoice
Triggers when a new sales invoice is added to xero
New Invoice Line Item
Triggers when there is a Invoice, for each line item. If there is an order with 5 line items, the Bot will run 5 times, each time with details of one line item.
New Purchase Order
Triggers when a new purchase order is added to xero
Invoice Overdue
Triggers when the invoice is overdue by a specified number of days
New Bill
Triggers when a new bill is added to xero
New or Modified Credit Note
Triggers when a new credit note is added or an existing credit note is updated
Add Or Update a Contact
Create or Update a Contact
Search Contact
Search A Contact Based On Contact ID Or Email Address
Add a Payment
Apply payments to approved AR and AP invoices
Add a Sales Invoice
Create a new Sales Invoice
Add a Bill
Creates a new Bill
Add a Purchase Order
creates a new purchase order
Search Invoices
search invoices based on invoice id or invoice number
Update an Invoice
Updates an existing Invoice by Invoice ID or Invoice Number
Add Credit Note
Adds a new credit note
Add an Item
Add a new item in to inventory
Add Line Item To Sales Invoice
Add a new line item to an existing sales invoice
Search Bill
Search bill by Bill Invoice ID, Reference or Contact ID
Search Credit Note
Search credit note by Credit Note Id or Credit Note Number
Search An Item
search a item/product with its name or id
Search Payments
Search payments by Payment Id or Reference
Send an Invoice
Send Invoice by Invoice Id to the Invoice email address
Add Row
Adds a new row to a given Worksheet
Search Row
Searches a row based on column value
Update Row
Updates a row in a given worksheet based on row number
Add Column
Adds a new column into a specific worksheet.
Add a Worksheet
Adds a new worksheet to a given spreadsheet
Share a Spreadsheet
Shares a spreadsheet with a specified email address
Add a comment
Adds a comment to a specified spreadsheet
Delete Row
Deletes a row from the specified worksheet based on the row number
Create your custom integration by selecting the Trigger event and Action to be performed.
Say goodbye to those busy days.
Get Started for FREENo credit card required.
