Brooked logo

Brooked

Freemium

A tool for linking data sources and analyzing spreadsheets.

Type
Saas
Founded
2024

About Brooked

Brooked is an AI-powered Google Sheets extension that connects 138+ data sources (including Snowflake, QuickBooks, Sage Intacct, Databricks) to your spreadsheets with two-way sync, scheduled auto-refresh (every 15 min, hourly, daily), and data validation. Its integrated AI agent (multi-model: Claude, GPT, Gemini) allows you to query live data in plain English, write SQL, run Python analyses in a secure sandbox (pandas, numpy), and set Slack/email alerts for threshold-based monitoring. Brooked also offers BRKD spreadsheet functions (BRKD_QUERY, BRKD_SQL, BRKD_SUMMARIZE, BRKD_LOOKUP) and full audit trails. Founded in 2024, it is Google Workspace Verified with a 5.0 rating on the Marketplace. Pricing includes a free tier (100 imports/month, all sources, GLM AI) and Pro at $29/user/month (unlimited imports, Claude/OpenAI, scheduled syncs, alerts). Enterprise plans add SSO, real-time sync, custom models, and 99.9% uptime SLA.

Key Features

Connects 138+ data sources including Snowflake, QuickBooks, Sage Intacct, Databricks, NetSuite, HubSpot, Stripe, Salesforce
Two-way sync with full audit trail — push updates back to source, not just pull
Multi-model AI (Claude, GPT, Gemini) for natural language queries, SQL generation, and Python analysis
Scheduled auto-refresh: every 15 minutes, hourly, or daily
Data alerts: set threshold-based Slack and email notifications
BRKD functions: BRKD_QUERY, BRKD_SQL, BRKD_SUMMARIZE, BRKD_LOOKUP directly in Google Sheets
Python sandbox with pandas and numpy for advanced analysis
OAuth, API key, and key-pair authentication with encrypted credentials
No Chrome extension or IT ticket required — works via Google Workspace add-on
Enterprise features: SSO/SAML, audit logs, custom integrations, 99.9% uptime SLA

Pros & Cons

Pros
  • Free tier includes all 141+ data sources, unlike competitors that gate premium connectors
  • Two-way sync allows pushing changes back to source, not just pulling data
  • Multi-model AI lets users choose or auto-select between Claude, GPT, and Gemini
  • Scheduled auto-refresh keeps sheets up to date without manual intervention
  • Data alerts via Slack/email reduce need to constantly monitor dashboards
  • Quick setup with OAuth and API keys — no middleware or IT tickets required
  • Google Workspace Verified with 5.0 rating and strong user reviews
  • Python sandbox enables advanced data manipulation and analysis within Sheets
Cons
  • Free tier is limited to 100 imports/month, manual refresh only, and GLM AI model
  • Pro plan costs $29/user/month, which may be expensive for larger teams
  • Only supports Google Sheets — no Excel or other spreadsheet applications
  • Number of supported connectors (141) may be fewer than some enterprise data integration tools
  • Enterprise features require custom pricing and sales contact

Best For

Automating financial reports from QuickBooks, Snowflake, and Sage Intacct into Google SheetsMonitoring key business metrics (e.g., MRR, AR) with real-time alerts via Slack or emailEnabling finance and ops teams to query live data without writing SQLRunning Python analyses (e.g., cohort analysis, forecasting) inside spreadsheetsSyncing CRM data from Salesforce or HubSpot to Google Sheets for revenue reportingPushing updates from Sheets back to databases (e.g., updating Snowflake tables)

Alternatives to Brooked

FAQ

What counts as an import?
An import is counted each time Brooked fetches data from a connected source, whether via manual run, scheduled sync, or a BRKD sheet function call. Failed fetches don't count. Free includes 100 imports; Pro is unlimited.
What's the difference between GLM and Claude / OpenAI?
GLM is the free AI model included in the Free tier. Pro and Enterprise plans unlock Claude (by Anthropic) and OpenAI models, providing more advanced reasoning and customization options.
Can I change plans anytime?
Yes, you can upgrade or downgrade your plan at any time. Changing plans takes effect immediately.
Is there a free trial for Pro?
Yes, Brooked offers a 14-day free trial of the Pro plan with no credit card required.
Do you offer annual billing?
Yes, annual billing is available with a 20% discount compared to monthly billing.
How do Sheets users work?
Each Google Sheets user counts as a seat. The Free tier supports 1 user, Pro supports up to 10 users, and Enterprise offers unlimited users.
What authentication methods are supported?
Brooked supports OAuth, API keys, and key-pair authentication depending on the source. Credentials are encrypted at rest and never stored in plain text.