QuickBooks
LiveConnect QuickBooks to Google Sheets — sync P&L, invoices, and financial reports
14 live connectors. Every source ships with two-way sync, AI queries, and scheduled refresh.
Pull GL entries, AR aging, and multi-entity financials from Sage Intacct into Google Sheets.
OAuth 2.0 · Read-only by default · No data stored
Capabilities
7 built-in capabilities — from live queries to scheduled syncs and AI-powered data analysis.
Technical details
Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.
Setup guide
From install to your first live query in under 5 minutes. No engineering help required.
Add Brooked from the Google Workspace Marketplace.
Open the Brooked sidebar, select Sage Intacct, and enter your Web Services sender ID and credentials.
Select the report or object type and import it into your destination sheet.
Need help? Visit support →
The Sage Web Services authorization path (Company > Setup > Company > Web Services authorizations), the five credentials Sage actually requires (User, Password, CompanyId, SenderId, SenderPassword), API tier limits (Essential/Select/Premier), multi-entity selection, and the 'XL03000006 Authentication failed' fix.
Read the full guideUse cases
From finance reporting to real-time operations dashboards — see what your team can build.
Multi-entity consolidation
Pull financials from multiple Sage Intacct entities into a single consolidated Google Sheet for board-level reporting.
Available functions
Five built-in sheet functions — from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.
=BRKD_QUERY("Sage Intacct", "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("Sage Intacct", "total accounts receivable balance by customer")
Also supported
Connect QuickBooks to Google Sheets — sync P&L, invoices, and financial reports
Connect NetSuite to Google Sheets — import saved searches and ERP reports
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free