Export Quickbooks data into Google Sheets

Import data from Quickbooks into Google Sheets with Awesome Table. Schedule automatic refreshes to periodically update your data.

Install the Google Sheets add-on

Quickbooks data you can export into Google Sheets with Awesome Table

Accounts
Bills
Customers
Employees
Invoices
Items
Payments
Query a report
Vendors

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.

Automatic pagination handlingEasily extract as many pages of data you need (as long as it fits in a Google Sheet).

Advanced JSON to Sheet supportMultiple JSON to Sheet conversion options, and filtering with JMESPath.

Email notifications for scheduled queriesGet notified by email when your queries have run.

A growing number of user-friendly connectors

Awesome Table has a huge number of full connectors that is constantly increasing.
Also, you can connect your spreadsheet manually to any API.

Accounting

Quickbooks

Xero

CRM, Customer Service

Hubspot

Salesforce

Zendesk

Dev & Design

Any REST API

Figma

GitHub

Jira

Unsplash

Vercel

E-Commerce

Productivity

Crypto and Defi

Google Workspace

Social Media

Couldn't find the connector you were looking for?

We're constantly building new data source connectors based on our customers' needs.
If we don't yet offer a connector you'd like to use, please fill the request form.Suggest a new connector

COMING SOON

Coinglass

TikTok

Twitter

BigQuery

Slack

Google Search

Firestore

Trello

Google Analytics

Google My Business