Google Sheets
arrows-integration

Google Sheets and Xero Integration

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.

Get Started

Popular Integrations

  • Xero - New or Modified Contact
    arrow
    Google Sheets - Add Row

    Add Row in Google Sheets on a New or Modified Contact in Xero

  • Google Sheets - New Row
    arrow
    Xero - Add Or Update a Contact

    Add Or Update a Contact in Xero on a New Row in Google Sheets

  • Xero - New Payment
    arrow
    Google Sheets - Add Row

    Add Row in Google Sheets on a New Payment in Xero

  • Xero - New Overpayment
    arrow
    Google Sheets - Add Row

    Add Row in Google Sheets on a New Overpayment in Xero

  • Google Sheets - New or Updated Row
    arrow
    Xero - Add Or Update a Contact

    Add Or Update a Contact in Xero on a New or Updated Row in Google Sheets

  • Xero - New or Modified Contact
    arrow
    Google Sheets - Update Row

    Update Row in Google Sheets on a New or Modified Contact in Xero

  • Google Sheets - Updated Row
    arrow
    Xero - Add Or Update a Contact

    Add Or Update a Contact in Xero on a Updated Row in Google Sheets

  • Xero - Invoice Status Change
    arrow
    Google Sheets - Add Row

    Add Row in Google Sheets on a Invoice Status Change in Xero

Looking for something else?

Create your own Integration

Connect Google Sheets and Xero the way you want. Start by selecting the trigger and action events listed here.

When this happens

TRIGGERS
  • Google Sheets - New Row

    New Row

    Triggers when a new row is added in a worksheet.

  • Google Sheets - New or Updated Row

    New or Updated Row

    Triggers when a new row is added or existing row is updated in a worksheet

  • Google Sheets - Updated Row

    Updated Row

    Triggers when an existing row is updated

  • Google Sheets - New Spreadsheet

    New Spreadsheet

    Triggers when a new spreadsheet is created.

  • Google Sheets - New Worksheet

    New Worksheet

    Triggers when a new worksheet is created.

  • Google Sheets - New Comment

    New Comment

    Triggers when a new comment is added in a spreadsheet

  • Xero - New or Modified Contact

    New or Modified Contact

    Triggers when a new contact is created or an existing one is modified

  • Xero - New Overpayment

    New Overpayment

    Triggers when a new overpayment is generated

  • Xero - New Payment

    New Payment

    Triggers when a new payment is added to xero

  • Xero - Invoice Status Change

    Invoice Status Change

    Triggers when a the status of the sales invoice changes to a particular value

  • Xero - New Sales Invoice

    New Sales Invoice

    Triggers when a new sales invoice is added to xero

  • Xero - New Invoice Line Item

    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.

  • Xero - New Purchase Order

    New Purchase Order

    Triggers when a new purchase order is added to xero

  • Xero - Invoice Overdue

    Invoice Overdue

    Triggers when the invoice is overdue by a specified number of days

  • Xero - New Bill

    New Bill

    Triggers when a new bill is added to xero

  • Xero - New or Modified Credit Note

    New or Modified Credit Note

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

Do this

ACTIONS
  • Xero - Add Or Update a Contact

    Add Or Update a Contact

    Create or Update a Contact

  • Xero - Search Contact

    Search Contact

    Search A Contact Based On Contact ID Or Email Address

  • Xero - Add a Payment

    Add a Payment

    Apply payments to approved AR and AP invoices

  • Xero - Add a Sales Invoice

    Add a Sales Invoice

    Create a new Sales Invoice

  • Xero - Add a Bill

    Add a Bill

    Creates a new Bill

  • Xero - Add a Purchase Order

    Add a Purchase Order

    creates a new purchase order

  • Xero - Search Invoices

    Search Invoices

    search invoices based on invoice id or invoice number

  • Xero - Update an Invoice

    Update an Invoice

    Updates an existing Invoice by Invoice ID or Invoice Number

  • Xero - Add Credit Note

    Add Credit Note

    Adds a new credit note

  • Xero - Add an Item

    Add an Item

    Add a new item in to inventory

  • Xero - Add Line Item To Sales Invoice

    Add Line Item To Sales Invoice

    Add a new line item to an existing sales invoice

  • Xero - Search Bill

    Search Bill

    Search bill by Bill Invoice ID, Reference or Contact ID

  • Xero - Search Credit Note

    Search Credit Note

    Search credit note by Credit Note Id or Credit Note Number

  • Xero - Search An Item

    Search An Item

    search a item/product with its name or id

  • Xero - Search Payments

    Search Payments

    Search payments by Payment Id or Reference

  • Xero - Send an Invoice

    Send an Invoice

    Send Invoice by Invoice Id to the Invoice email address

  • Google Sheets - Add Row

    Add Row

    Adds a new row to a given Worksheet

  • Google Sheets - Search Row

    Search Row

    Searches a row based on column value

  • Google Sheets - Update Row

    Update Row

    Updates a row in a given worksheet based on row number

  • Google Sheets - Add Column

    Add Column

    Adds a new column into a specific worksheet.

  • Google Sheets - Add a Worksheet

    Add a Worksheet

    Adds a new worksheet to a given spreadsheet

  • Google Sheets - Share a Spreadsheet

    Share a Spreadsheet

    Shares a spreadsheet with a specified email address

  • Google Sheets - Add a comment

    Add a comment

    Adds a comment to a specified spreadsheet

  • Google Sheets - Delete Row

    Delete Row

    Deletes a row from the specified worksheet based on the row number

Let's Integrate

Create your custom integration by selecting the Trigger event and Action to be performed.

Automate Work. Have Fun!

Say goodbye to those busy days.

Get Started for FREE

No credit card required.

have fun have fun have fun