SyncWith

Export Xero Invoices to Google Sheets

Colin Dellow

Colin Dellow

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.

GET

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

Add data sources

Build reports & dashboards

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

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

Type
InvoiceID
InvoiceNumber
Reference
Payments
CreditNotes
Prepayments
Overpayments
AmountDue
AmountPaid
AmountCredited
CurrencyRate
IsDiscounted
HasAttachments
HasErrors
Contact
DateString
Date
DueDateString
DueDate
BrandingThemeID
Status
LineAmountTypes
LineItems
SubTotal
TotalTax
Total
UpdatedDateUTC
CurrencyCode
                             
                             
                             

Get a live Google Sheet

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

Automatically updated

Add data sources

Build reports & dashboards