The short answer
Intuit's help article for exporting reports to Google Sheets describes it as a QuickBooks Online Advanced feature. If your company is on Simple Start, Essentials or Plus, the option may be missing, greyed out or may lead to a message you can't get past. On Advanced, the usual blockers are a pop-up blocker, the Google sign-in step, or a user role that is not allowed to export.
Quick test: open Settings (gear) > Account and settings > Billing & subscription in QuickBooks. If the plan shown is not Advanced, skip to the workarounds; there is nothing to fix on your side.
Common causes and fixes
| What you see | Likely cause | What to try |
|---|---|---|
| No "Export to Google Sheets" option, only Excel and PDF | Your QuickBooks Online plan does not include it | Use one of the workarounds below, or move to Advanced if you need other Advanced features too. |
| "Set up through admin" or a permissions message | Your user role cannot export or connect apps, or the company admin has not finished the Google connection | Ask the primary admin to run the export once, or to give your role permission to export reports. |
| Nothing happens after you click it | The browser blocked the Google pop-up | Allow pop-ups for qbo.intuit.com, then try again. |
| A Google sign-in or verification code loop | You are signed in to several Google accounts, or third-party cookies are blocked | Try a private window signed in to just one Google account, or allow cookies for Intuit and Google. |
| A sheet is created but it is empty or out of date | The export is a one-time copy | Export again each time, or use a sync tool that refreshes the sheet. |
Intuit also notes that the first export needs an existing Google account and that pop-ups from QuickBooks Online must be allowed. If you have tried all of the above on Advanced, Intuit support is the right next step, because the export runs on Intuit's side.
Workaround 1: export to Excel, then import into Google Sheets
This works on every QuickBooks Online plan and costs nothing.
- In QuickBooks, open the report (for example Profit and Loss or Invoice List) and set the date range.
- Click the Export icon and choose Export to Excel. An
.xlsxfile downloads. - In Google Sheets, open File > Import > Upload and pick the file.
- Choose Insert new sheet(s) so you don't overwrite an existing tab.
- Delete the title rows QuickBooks adds at the top, so the column headers sit in row 1 and formulas can find them.
The downside is that the copy never changes. Next week you repeat all five steps, and formulas pointing at the old tab need fixing if the columns moved. Our guide to exporting QuickBooks to Google Sheets compares this with automation tools in more detail.
Workaround 2: sync with a Google Sheets add-on
A Sheets add-on connects to QuickBooks Online itself, so it does not depend on Intuit's export button or on your plan. SheetsSync is one; it works on Simple Start, Essentials, Plus and Advanced.
- Install SheetsSync from the Google Workspace Marketplace.
- In your sheet, open Extensions > SheetsSync > Open SheetsSync and click Connect QuickBooks. You approve access on Intuit's own sign-in screen.
- Open Configure This Sheet, pick a data type (Invoices, Customers, Bills and so on) or a report (Profit & Loss, Balance Sheet or Transaction List), tick the columns and set the date range.
- Click Sync. Next time you need fresh numbers, click Sync again instead of exporting.
On the Free plan you can sync one data type or report into up to 3 sheets, by hand. Pro adds schedules (hourly, every 6 hours, daily or weekly), so the sheet refreshes without anyone clicking. QuickBooks Desktop is not supported.
Which option to use
| Option | QuickBooks plans | Refresh | Cost |
|---|---|---|---|
| Intuit Export to Google Sheets | Advanced (per Intuit's help) | One-time copy each export | Included in Advanced |
| Export to Excel and import | All plans | Manual, every time | Free |
| SheetsSync add-on | All QuickBooks Online plans | Click Sync (Free) or scheduled, hourly at the fastest (Pro) | Free plan; Pro $19.99/month |
If you are on Advanced and work in Excel, Intuit's own Spreadsheet Sync may suit you better; see our Spreadsheet Sync alternative for Google Sheets page for an honest comparison.