App Holder
Google Sheets

Google Sheets and Xero Integration

Automate invoicing and payment processing. Connect Google Sheets and Xero. Run workflows.

Get Started

Popular Integrations

  • Google Sheets Xero

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

  • Xero Google Sheets

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

  • Google Sheets Xero

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

  • Xero Google Sheets

    Add a Row in Google Sheets on a New Payment in Xero

  • Xero Google Sheets

    Add a Row in Google Sheets on a New Overpayment in Xero

  • Xero Google Sheets

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

  • Google Sheets Xero

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

  • Xero Google Sheets

    Update a Row in Google Sheets on a New Payment 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

    Triggers when a new row is added in a worksheet (recommended)
  • Google Sheets

    New or Updated Row

    Triggers when a new Row is added or an existing Row is updated
  • Google Sheets

    New Spreadsheet

    Triggers when a Spreadsheet is created
  • Google Sheets

    New Worksheet

    Triggers when a Worksheet is created
  • Google Sheets

    New Row (old version)

    Triggers when a new row is added in a worksheet
  • Xero

    New or Modified Contact

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

    New Overpayment

    Triggers when a new overpayment is generated
  • Xero

    New Payment

    Triggers when a new payment is added to xero
  • Xero

    Invoice Status Change

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

    New Sales Invoice

    Triggers when a new sales invoice is added to xero
  • 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.
  • Xero

    New Purchase Order

    Triggers when a new purchase order is added to xero
  • Xero

    Invoice Overdue

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

    New Bill

    Triggers when a new bill is added to xero

Do this

ACTIONS
  • Xero

    Add Or Update a Contact

    Create or Update a Contact
  • Xero

    Search Contact

    Search A Contact Based On Contact ID Or Email Address
  • Xero

    Add a Payment

    Apply payments to approved AR and AP invoices
  • Xero

    Add a Sales Invoice

    Create a new Sales Invoice
  • Xero

    Add a Bill

    Creates a new Bill
  • Xero

    Add a Purchase Order

    creates a new purchase order
  • Xero

    Search Invoices

    search invoices based on invoice id or invoice number
  • Xero

    Add Line Item To Sales Invoice

    Add a new line item to an existing sales invoice
  • Xero

    Search An Item

    search a item/product with its name or id
  • Google Sheets

    Add Row

    Adds a new Row. Use this only if you have an issue with the other ‘Add Row’ action.
  • Google Sheets

    Add a Worksheet

    Adds a new Worksheet to a given Spreadsheet
  • Google Sheets

    Search Rows

    Searches a row based on column value
  • Google Sheets

    Update a Row

    Update a row in a given Worksheet based on row id
  • Google Sheets

    Add Row (older version)

    Adds a new row to a given Worksheet
  • Google Sheets

    Delete a Row

    Delete a Row from the specified Worksheet based on the Row ID

Let's Integrate

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

Run Workflows

Typeform
Wufoo
Google Forms

Forms

Google Sheets Workflow
Xero Workflow
Gmail
Office 365
Zoho Mail

Email

Connect Google Sheets and Xero with your other apps and run workflows across them. Trigger workflows automatically when things happen in any of the apps.

Try Now

Why Automate.io?

Easy

No coding. No change in your apps. Setup and get going in 2 minutes.

Secure

Runs on secure HTTPS channel & all sensitive data is stored in an encrypted format.

Reliable

Used by 1000+ organizations globally - big and small. Live chat support available.

Automate Work. Have Fun!

Say Goodbye to those busy days

Get Started for FREE

No credit card required.