Looker
LiveConnect Looker to Google Sheets — import Looks, Explores, and dashboard data
Live~3 minutes
Google Search Console → Google Sheets
Pull search clicks, impressions, CTR, and ranking data into Google Sheets — scheduled, live, always fresh.
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 Google Search Console connector
8 built-in capabilities — from live queries to scheduled syncs and AI-powered data analysis.
Import search queries, pages, countries, and device data into Sheets
Track clicks, impressions, CTR, and average position over time
Preset reports for common SEO analyses
Filter by search type (web, image, video, news, discover)
Scheduled auto-refresh for live SEO dashboards
Secure Google OAuth authentication
Supports URL-prefix and domain-level properties
AI agent can query search performance, find keyword trends, and alert on ranking changes
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 (Google)
- Supported data
- Search Analytics (queries, pages, countries, devices)
- Connected metrics
- Clicks · Impressions · CTR · Average Position
- Date ranges
- Custom ranges (last 7d, 28d, 90d, 365d)
- Properties
- URL-prefix and domain properties
- Min sync interval
- 15 minutes
- 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 Search Console
Authorize with your Google account and select your Search Console property.
3
Configure your report
Choose a preset report type, date range, and search type, then import into your sheet.
Need help? Visit support →
Use cases
How teams use Google Search Console + Brooked
From finance reporting to real-time operations dashboards — see what your team can build.
Keyword tracking
Pull daily query performance into a Sheet to monitor keyword rankings, CTR trends, and click volume over time.
Live in Google Sheets
Google Search Console → Sheets · auto-refresh
Available functions
Query Google Search Console 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("Google Search Console", "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("Google Search Console", "top 10 pages by sessions this week")
Also supported
More Analytics & BI integrations
Get your spreadsheet hours back
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free
