Export Xero data into Google Sheets
Import data from Xero into Google Sheets with Awesome Table. Schedule automatic refreshes to periodically update your data.Xero data you can export into Google Sheets with Awesome Table
- Accounts
- Bank transactions
- Bank transfers
- Batch payments
- Budgets
- Contact groups
- Credit notes
- Contacts
- Employees
- Invoices
- Items
- Linked transactions
- Overpayments
- Payments
- Prepayments
- Purchase orders
- Quotes
- Repeating invoices
- Users
What you can do with Awesome Table
Friendly authentication helperSign in with OAuth2, basic authentication and API keys.
Multi accountsSave and use multiple accounts on the same data source.
Intuitive data fetcherWe make it very easy for you to choose the data you want to import.
Precise schedulerYour queries will run at the exact time you want them to run thanks to our top-notch scheduler.
Interactive query historyEasily track and reuse queries you've run before.
Saved queriesSave queries for later, easily reuse in a different spreadsheet.
Email notifications for scheduled queriesGet notified by email when your queries have run.
Your data is kept private and secure with Awesome Table
Secure credentials storage
Your credentials (API key, OAuth token, Username/Password) are stored securely (AES-256 encryption) on Awesome Table servers. They are not accessible from within the add-on or a spreadsheet.Learn moreEncrypted source data processing
Data is securely encrypted while it is in transit from the source to your spreadsheet. All communication with our servers is encrypted.Learn moreIsolated user data access
Your Awesome Table user data (account information, request and schedule configuration) can only be accessed by you and are stored encrypted on our servers.Learn moreSecure-by-design infrastructure
Awesome Table infrastructure is hosted on Google Cloud Platform to take advantage of the same secure-by-design infrastructure, built-in protection, and global network that Google uses.Learn moreA growing number of user-friendly connectorsAwesome Table has a huge number of full connectors that is constantly increasing.
Also, you can connect your spreadsheet manually to any API.
Also, you can connect your spreadsheet manually to any API.
Accounting
CRM, Customer Service
Dev & Design
E-Commerce
Productivity
Crypto and Defi
Google Workspace
Marketing
Databases
COMING SOON
Don't see your tool of choice listed above?We're adding connectors for new data sources continuously.
If you have a specific connector in mind, please let us know.Suggest a new connector
If you have a specific connector in mind, please let us know.Suggest a new connector