Sync QuickBooks to Google Sheets automatically.
Stop exporting CSVs every Monday. SheetsSync pulls your QuickBooks Online invoices, customers, payments, bills and reports straight into Google Sheets, keeps them fresh on a schedule (as often as hourly), and lets you push edits back to QuickBooks.
What SheetsSync does
SheetsSync is a Google Sheets add-on that connects to QuickBooks Online and writes your accounting data into ordinary sheet tabs. Each tab is tied to one QuickBooks data type or report. You pick the columns, the date range, filters and sort order, then click Sync. From there you can build AR aging reports, cash dashboards, pivot tables or client reports with the formulas you already know.
On the Free plan you sync by hand. Pro adds scheduled syncs (hourly, every 6 hours, daily or weekly), webhook sync that refreshes a sheet after QuickBooks reports a change, and two-way sync so you can edit customers, vendors, invoices, bills and items in the sheet and send the changes back to QuickBooks. New to this? Read the step-by-step QuickBooks to Google Sheets setup guide, see how to sync QuickBooks invoices, or visit the help center.
Everything You Need to Sync QuickBooks Data to Sheets
Built for accountants, bookkeepers, and business owners who need their QuickBooks data in spreadsheets.
One-Click Sync
Pull your latest QuickBooks data with one click. No CSV exports or copy-pasting. The sheet is rewritten with current values each time it syncs.
Two-Way Sync
Edit rows in Google Sheets and push the changes back to QuickBooks. Create or update customers, vendors, invoices, bills and items from your spreadsheet (Pro).
Scheduled Auto-Sync
Schedule automatic syncs hourly, every 6 hours, daily at the hour you choose, or weekly on the day you choose. Hourly is the fastest schedule Google allows for add-ons (Pro).
Webhook Sync
QuickBooks tells SheetsSync when a record changes, and the affected sheets are refreshed on the next hourly check, so quiet sheets are not re-pulled for nothing (Pro).
Fields, Filters & Sorting
Choose exactly which fields to sync and rename column headers. Filter by date range, amount, paid status and more. Sort the data your way, and group report rows where the report supports it.
Secure Sign-In
You connect through Intuit's official OAuth 2.0 screen, so SheetsSync never sees your QuickBooks password. Traffic is encrypted in transit, and you can disconnect at any time.
Two-Way QuickBooks Sync, Visualized
QuickBooks data comes into Google Sheets, and on Pro your edits can go back to QuickBooks.
9 QuickBooks Data Types and 3 Reports
Each sheet tab syncs one data type or report, with the fields you choose. Free covers any one of them; Pro covers all of them.
Invoices
Numbers, dates, customers, totals, balances, due dates, terms
Customers
Contact info, balances, addresses, notes
Vendors
Supplier details, balances, 1099 flag
Items
Products, services, SKUs, prices, quantity on hand
Payments
Customer payments received, amounts, dates
Bills
Vendor bills, payables, due dates
Purchases
Expenses, credit card charges, checks
Accounts
Chart of accounts, balances, classifications
Journal Entries
Journal numbers, dates, totals, adjustments
Profit & Loss
Income and expenses report for the period
Balance Sheet
Assets, liabilities and equity report
Transaction List
Every transaction in a date range, one per row
How to Connect QuickBooks to Google Sheets
Four steps, all inside Google Sheets. The full setup guide has screenshots of each one.
Install the Add-on
Get SheetsSync from the Google Workspace Marketplace. Free to install, no credit card required.
Connect QuickBooks
Open SheetsSync from the Extensions menu and sign in to QuickBooks Online on Intuit's own approval screen.
Configure a Sheet
Pick a data type or report, then choose fields, date range, filters and sort order for that tab.
Sync & Automate
Click Sync to fill the sheet. On Pro, add a schedule, webhook sync or two-way sync.
Simple, Transparent Pricing
Start free. Upgrade when you need automation or write-back. Prices are in USD.
- 1 QuickBooks entity type (your choice)
- Up to 3 configured sheets
- Manual sync (pull from QB)
- Field selection, filters & sorting
- Last 5 syncs in sync history
- All 9 entity types + 3 reports
- Scheduled auto-sync
- Webhook sync
- Two-way sync & bulk push
- All 9 QuickBooks entity types + 3 reports
- Unlimited configured sheets
- Scheduled auto-sync (hourly to weekly)
- Webhook sync (refreshes on the next hourly check)
- Two-way sync for customers, vendors, invoices, bills & items
- Bulk push operations
- Last 20 syncs in sync history
Pro is $19.99 a month or $159.99 a year. The trial needs no card; if you don't subscribe, the account goes back to Free and your sheet settings stay in place. Not sure which tool fits? Compare SheetsSync with Coupler.io, LiveFlow or Coefficient.
Frequently Asked Questions
Common questions about syncing QuickBooks Online with Google Sheets.
Install SheetsSync from the Google Workspace Marketplace, open it from the Extensions menu in a Google Sheet, and connect your QuickBooks Online company. Then pick a data type such as Invoices, choose the fields and date range, and click Sync. The setup guide walks through every screen.
On Free, a sheet updates when you click Sync. On Pro you can schedule syncs hourly, every 6 hours, daily or weekly. Hourly is the fastest schedule, because Google only lets add-ons run timed jobs once an hour. Webhook sync also refreshes a sheet on the next hourly check after QuickBooks reports a change.
Free covers 1 QuickBooks data type, up to 3 configured sheets and manual sync. Pro ($19.99/month or $159.99/year) adds all 9 data types and 3 reports, unlimited sheets, scheduled auto-sync, webhook sync, two-way sync and bulk push. Pro has a 14-day free trial that does not ask for a credit card.
SheetsSync works with QuickBooks Online: Simple Start, Essentials, Plus and Advanced. It does not connect to QuickBooks Desktop.
With Pro, you can edit rows in a synced sheet and push the changes back to QuickBooks, or add new rows to create records. Write-back works for customers, vendors, invoices, bills and items. A status column shows whether each row is synced, pending or has an error. Calculated fields such as totals and balances are never sent back.
You connect through Intuit's OAuth 2.0 approval screen, so SheetsSync never sees your QuickBooks password, and data is encrypted in transit. The synced data lives in your Google Sheet. SheetsSync's backend keeps what it needs to run the sync, such as connection tokens, sheet settings, sync logs and the rows you push back with two-way sync. The privacy policy has the details.
If you don't subscribe, the account goes back to the Free plan. Your sheets and their settings stay in place; Pro features such as auto-sync, webhook sync and two-way sync switch off until you upgrade.
Disconnect from the add-on sidebar in Google Sheets, or revoke access in your Intuit account settings. Disconnecting deletes the stored QuickBooks tokens. Your spreadsheet data stays where it is. For anything else, see the help center.
Ready to Sync Your QuickBooks Data?
Install free, or start the 14-day Pro trial. No credit card required.
Install Free