Import Xero Data to Google Sheets
In this guide, we’ll walk through how to pull Xero accounting data data directly into Google Sheets, using the API Connector add-on for Sheets. We’ll be connecting using API Connector’s built-in OAuth2 integration for Xero (this is a paid feature, please install API Connector for a free 7-day trial or upgrade to access).
- Before You Begin
- Part 1: Connect to the Xero API
- Part 2: Get your Xero Tenant ID
- Part 3: Create your Xero Request URL
- Part 4: Pull Xero API Data into Sheets
- Part 5: More Example API URLs
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: CONNECT TO XERO API
If you haven’t connected to the Xero API before, you’ll first need to initiate the connection.
- Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
- In the list of available connections, find Xero and click Connect.
- You will be directed to Xero and asked to Allow Access.
- You’ll then be returned to your Google Sheet, and can verify that your Xero connection is active in the Connections screen.
PART 2: CREATE YOUR XERO API REQUEST URL
For our first request, we’ll get your Xero tenant ID, since you’ll need this to create subsequent requests.
- API root: https://api.xero.com
- Endpoint: /connections
Putting it all together, we get the full API Request URL.
PART 3: PULL XERO API DATA INTO SHEETS
Now let’s enter our URL into API Connector and import Xero data into Google Sheets.
- Back in the Create Request interface, enter the Request URL we just created above.
- You don’t need any headers so just leave that section blank.
- Under Authentication, choose Xero from the dropdown menu.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see some information about your Xero account populate your sheet. Pay special attention to the value located in the
tenantIdfield as you’ll need it in future requests.
- All subsequent requests need to add the tenant ID as a header, where the key is
xero-tenant-idand the value is your tenant ID, like this:
- We’ll show that again in the next section. Let’s start pulling in data about your Xero account!
PART 4: EXAMPLE API URLS
You can access the Xero Accounting API documentation here, but if you just want to get started, you can try the following example URLs.
- Bank Transactions