SyncWith

Sync marketing data to Google Sheets and Looker Studio

Export Xero Invoices to Google Sheets

Colin Dellow

Oct 08, 2021

In this tutorial you will make two API requests, ending with a list of recent invoices for your Xero account.

Xero is a multi-tenant service. This means that a single account can have access to multiple, different organizations. In order to make most API requests to Xero, you must send a Xero-Tenant-Id header identifying your organization.

You can use SyncWith to determine your tenant ID:

List Xero Tenant IDs

Please fill in any necessary fields and click Run.

Endpoint

GET

Authentication

Preview

View the API data, get a live Google Sheet dashboard

id	authEventId	tenantId	tenantType	tenantName	createdDateUtc	updatedDateUtc

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

Your tenant ID value is located in the tenantId column, it will be a long series of letters and numbers, similar to e1d73665-aaa9-4a4e-89ca-61dc47ac70bb.

Once you have your tenant ID, you can then get a list of recent invoices using the Xero Invoices API:

Get Xero Invoices