Sage Intacct
LiveConnect Sage Intacct to Google Sheets — export GL, AR, and multi-entity financials
Live~3 minutes
QuickBooks → Google Sheets
Import P&L, invoices, and balance sheet data from QuickBooks Online directly into Google Sheets.
OAuth 2.0 · Read-only by default · No data stored
~3 minutesSetup time
OAuth 2.0Authentication
15 minutesMin sync interval
Read-onlyDirection
Capabilities
Everything in the QuickBooks connector
6 built-in capabilities — from live queries to scheduled syncs and AI-powered data analysis.
Import invoices, bills, payments, and expenses
Pull customer and vendor lists
Sync P&L, Balance Sheet, and Cash Flow reports
Scheduled auto-refresh to keep data current
Secure OAuth 2.0 connection to QuickBooks Online
AI agent can answer questions, run variance analysis, and alert you when financials change
Technical details
Built for IT teams to approve in one read
Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.
- Authentication
- OAuth 2.0 (Intuit)
- Supported editions
- Simple Start · Plus · Advanced
- Connected objects
- Invoices · Bills · Customers · Vendors · P&L · Balance Sheet · Cash Flow
- Write-back
- Not supported (read-only)
- Min sync interval
- 15 minutes
- Multi-company
- One connection per company file
- Data residency
- Read-only — data flows directly to your Sheet
Setup guide
Connect in 3 steps
From install to your first live query in under 5 minutes. No engineering help required.
1
Install the extension
Add Brooked from the Google Workspace Marketplace.
2
Connect QuickBooks
Open the Brooked sidebar, select QuickBooks, and authorize via Intuit's OAuth flow.
3
Choose your data
Select the report or object type (invoices, P&L, etc.) and pick your destination sheet.
Need help? Visit support →
Use cases
How teams use QuickBooks + Brooked
From finance reporting to real-time operations dashboards — see what your team can build.
Monthly close
Auto-import your P&L and balance sheet into a template each month-end so your close process never misses a beat.
Live in Google Sheets
QuickBooks → Sheets · auto-refresh
Available functions
Query QuickBooks from a cell
Five built-in sheet functions — from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.
fx
=BRKD_QUERY("QuickBooks", "total accounts receivable balance by customer")
Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.
=BRKD_QUERY("QuickBooks", "total accounts receivable balance by customer")
Also supported
More Finance & ERP integrations
Get your spreadsheet hours back
Brooked installs in seconds. Your team is querying live data before lunch.
Install for Google Sheets