Overview
Mixed Analytics' API connector turns Google Sheets into a powerful, flexible API client that pulls API data directly into your spreadsheet. View and manage data from multiple data sources in a familiar spreadsheet interface, without requiring manual exports, custom scripts, or a complicated data warehouse. Achieve dynamic, code-like functionality by setting up refresh schedules, activating auto-pagination, and basing request URLs on the cells in your sheet.
This add-on for Sheets is designed for spreadsheet power users and technical analysts.
Mixed Analytics API Client for Sheets + Xero
This add-on for Google Sheets connects directly to Xero's Accounting API. Once it's connected, it pulls Xero data directly into your spreadsheet. It can fetch accounting reports, business transactions, organization settings, and contact data.
Getting started
In Google Sheets, navigate to Add-ons > API Connector > Manage Connections > Xero and click "Connect". After successfully connecting, you will be able to pull data in to Google Sheets from Xero's Accounting API endpoints.
To make your first request, enter your API endpoint and header, select "Xero" from the drop-down OAuth menu, and click Run.
Reviews & ratings
Sort and filter
Most recent reviews
ND