How to connect QuickBooks Online to Google Sheets
By Figures · Updated June 10, 2026
Your books live in QuickBooks Online. Your reporting (the client dashboard, the month-end pack, the spreadsheet your owner actually reads) lives in Google Sheets. Sooner or later every bookkeeper needs the two connected. There are three honest ways to do it, and the right one depends on how often you need fresh numbers.
Option 1: export reports by hand
The built-in path. No tools, no setup:
- In QuickBooks Online, open Reports and run the report you need (say, the Profit and Loss).
- Set the period and accounting basis, then export it to Excel.
- In Google Sheets, choose File → Import → Upload and bring the file in.
- Tidy what arrives: merged header cells, stray columns, text-formatted numbers.
For a one-off analysis or a report you pull a few times a year, this is fine. The cost shows up when it becomes a routine: every refresh is the same fifteen minutes again, the numbers are stale the moment the books change, and copies multiply until nobody is sure which “P&L final v3” is the real one.
Option 2: build it yourself on the QuickBooks API
Intuit’s API exposes the same reports you see in QuickBooks, and Google Sheets has an API too, so a developer can wire the two together. Going in, it helps to know what the project actually includes: registering a developer app with Intuit, handling the sign-in handshake and the tokens that expire and rotate, respecting API rate limits, turning deeply nested report JSON into clean rows, and scheduling the whole thing with alerts for when it fails quietly at 6 AM.
None of that is exotic, but it’s a real build: a weekend to demo, then maintenance forever. It makes sense when you have engineering time on hand and requirements no off-the-shelf tool covers.
Option 3: sync automatically with Figures
Figures is a read-only sync built for exactly this job: it pulls your QuickBooks Online reports and writes them into Google Sheets every morning. We build it, so this part is specific, so here’s the whole setup.
Step 1: sign in with Google
Start at figureshq.com and sign in with your Google account. Figures asks for Google’s narrowest Drive permission (drive.file): it can only open spreadsheets it creates or ones you explicitly pick, never the rest of your Drive.
Step 2: connect your QuickBooks company
Connect through Intuit’s official QuickBooks sign-in. The connection is read-only: Figures can run reports, and can never create, edit, or delete anything in your books. That’s a design decision, not a missing feature. More on it on our security page.
Step 3: pick a report and a destination
Choose the QuickBooks report to sync: the financial statements (P&L, Balance Sheet, Cash Flow, Trial Balance, General Ledger, P&L Detail), A/R and A/P Aging Summary, sales by customer, class, or product/service, customer and vendor balances, Transaction List by Date, and Inventory Valuation. Then pick where it lands: a new Google Sheet named after your company, or any existing spreadsheet you select from your Drive.
Step 4: set the schedule
The default is daily, during the 6:00–7:00 AM window in your time zone, so your figures are fresh before the workday starts. Prefer weekly, or manual-only with a Sync now button? Both are options. Your first sync runs right away and lands in your sheet in a moment.
Each report gets its own tab (“P&L ▸ Synced”, for example) with a header row showing when it last synced, the period it covers, and the accounting basis. Everything else in the spreadsheet stays exactly as you built it; your own tabs and formulas are never touched.
Which option fits
| Manual export | Build your own | Figures | |
|---|---|---|---|
| Setup | None | Days of build time | About five minutes |
| Each refresh | 10–15 minutes by hand | Automatic | Automatic |
| Freshness | Stale between exports | Whatever you build | Every morning |
| Cost | Your time, every time | Engineering time + upkeep | $10 per company per month |
If you’re automating the P&L specifically, we wrote a closer look: QuickBooks P&L to Google Sheets, automatically.
Common questions
Is it safe to connect QuickBooks Online to Google Sheets?
It comes down to what access a tool asks for, and any tool should name that plainly. Figures connects to QuickBooks read-only (it can run reports and can never change your books), and its Google access is limited to spreadsheets it creates or ones you pick. You can revoke either connection at any time, from QuickBooks or from your Google account.
Which reports can I sync?
Fifteen today: P&L, Balance Sheet, Cash Flow, Trial Balance, General Ledger, P&L Detail, A/R and A/P Aging Summary, Sales by Customer, Sales by Class, Sales by Product/Service, Customer and Vendor Balance, Transaction List by Date, and Inventory Valuation. Each syncs to its own tab, and reports aren’t billed individually. Connect as many as you need per company.
Can I use a spreadsheet I already have?
Yes. Pick any spreadsheet from your Google Drive and Figures adds its own synced tab to it. Your existing tabs, formulas, and formatting stay exactly as they are.
How fresh are the numbers?
Reports refresh every morning, before the workday starts. Need numbers mid-day? Sync now refreshes on demand. Figures is built for morning-fresh reporting, not minute-by-minute monitoring, and it says so rather than promising otherwise.