QuickBooks
LiveConnect QuickBooks to Google Sheets, sync P&L, invoices, and financial reports
Live~2 minutes
ERPNext → Google Sheets
Import contacts from ERPNext
API key · Read-only by default · No data stored
~2 minutesSetup time
API keyAuthentication
15 minMin sync interval
Read-onlyDirection
Capabilities
Everything in the ERPNext connector
3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.
Import Contacts & Documents (any DocType) (2 data types available)
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
- API key
- Direction
- Read-only
Setup guide
Connect in 3 steps
From install to your first live query in under 5 minutes. No engineering help required.
1
Connect your account
Authorize Brooked to access your ERPNext data using an API key or token.
2
Choose what to import
Pick from 2 available data types, like Contacts, Documents (any DocType).
3
Schedule your sync
Run it once, or set a recurring schedule. Data flows straight into your Google Sheet.
Need help? Visit support →
Use cases
How teams use ERPNext + Brooked
From finance reporting to real-time operations dashboards, see what your team can build.
Keep ERPNext data current in Sheets
Automatically sync your finance & accounting data from ERPNext into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in ERPNext, no manual exports.
Live in Google Sheets
ERPNext → Sheets · auto-refresh
Available functions
Query ERPNext 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("ERPNext", "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("ERPNext", "total accounts receivable balance by customer")
Also supported
More Finance & ERP integrations
Sage Intacct
LiveSync Sage Intacct to Google Sheets free: auto-refresh GL, AR aging and multi-entity
NetSuite
LiveSync NetSuite to Google Sheets free: auto-refresh saved searches and SuiteAnalytics
Get your spreadsheet hours back
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free
