Looker
LiveConnect Looker to Google Sheets, import Looks, Explores, and dashboard data
Live~2 minutes
Elasticsearch → Google Sheets
Import cluster indices from Elasticsearch
Username & password · Read-only by default · No data stored
~2 minutesSetup time
Username & passwordAuthentication
15 minMin sync interval
Read-onlyDirection
Capabilities
Everything in the Elasticsearch connector
3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.
Import Indices & Documents (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
- Username & password
- 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 Elasticsearch data using a username and password.
2
Choose what to import
Pick from 2 available data types, like Indices, Documents.
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 Elasticsearch + Brooked
From finance reporting to real-time operations dashboards, see what your team can build.
Keep Elasticsearch data current in Sheets
Automatically sync your analytics & bi data from Elasticsearch into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in Elasticsearch, no manual exports.
Live in Google Sheets
Elasticsearch → Sheets · auto-refresh
Available functions
Query Elasticsearch 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("Elasticsearch", "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("Elasticsearch", "top 10 pages by sessions this week")
Also supported
More Analytics & BI integrations
Google Analytics
LiveConnect Google Analytics to Google Sheets, import GA4 metrics and reports
Connect Google Search Console to Google Sheets, import search performance data
Get your spreadsheet hours back
Brooked sets up in seconds. Your team is querying live data before lunch.
Get started free
