Google Analytics
LiveConnect Google Analytics to Google Sheets, import GA4 metrics and reports
141 live connectors. Every source ships with two-way sync, AI queries, and scheduled refresh.
Run Looker Explore queries and pull Look results into Google Sheets, no CSV exports.
OAuth 2.0 (Looker API) · 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.
Enter your Looker instance URL and OAuth client credentials to authorize the connection.
Select the Look or Explore query to import and map it to your destination sheet.
Need help? Visit support →
All 4 ways to get Looker data into Google Sheets: Connected Sheets, scheduled delivery, API, or a no-code add-on.
Read the full guideUse cases
From finance reporting to real-time operations dashboards, see what your team can build.
Executive reporting
Pull Looker Look results into a Google Sheet template for weekly exec distribution without manual CSV exports.
Available functions
Five built-in sheet functions, from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.
=BRKD_QUERY("Looker", "top 10 pages by sessions this week")
Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.
=BRKD_QUERY("Looker", "top 10 pages by sessions this week")
Also supported
Connect Google Analytics to Google Sheets, import GA4 metrics and reports
Connect Google Search Console to Google Sheets, import search performance data
Import cluster indices from Elasticsearch
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free