Import Looker Looks, Explores, and dashboards directly into Google Sheets with scheduled auto-refresh — no manual CSV downloads required.
Looker is your source of truth for business metrics. Google Sheets is where your team builds financial models, investor decks, and board reports. Connecting the two — without manually downloading CSVs from Looker and pasting them into Sheets — is something teams need every week. Brooked connects to Looker via its API and lets you import Looks and Explore results directly into any sheet range on a schedule.
What you can import from Looker
- Saved Looks — any Look in your Looker instance
- Explore queries — run custom Explore queries and import results
- Dashboard tile data — import individual tile data from Looker dashboards
- LookML model results — query any model your API credentials have access to
Step 1 — Install Brooked
Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month — no credit card required.
Step 2 — Generate Looker API credentials
Brooked uses Looker's REST API with API3 credentials. To generate them:
- In Looker, go to Admin → Users → your user (or create a dedicated API user)
- Click Edit → API3 Keys → New API3 Key
- Copy the Client ID and Client Secret — you'll enter these in Brooked
- Note your Looker instance URL (e.g. https://yourcompany.looker.com)
Step 3 — Connect Looker in Brooked
Open the Brooked sidebar and click Add data source → Looker. Enter your Looker instance URL, Client ID, and Client Secret. Brooked will verify the connection and list your available models and Looks.
Step 4 — Import a Look or Explore
Click New import, select Looker, and choose a saved Look or build an Explore query. Choose a destination range in your sheet and click Import. Enable Auto-refresh to keep the data current — daily refresh keeps your Sheets aligned with Looker without any manual work.
Using the AI agent with Looker
Open the Chat tab and ask questions about your Looker data in plain English. The agent queries your Looker Explores and writes results into Sheets.
Brooked AI — LookerCommon use cases
- Board reporting — pull Looker metrics into a board deck template that updates automatically
- Finance models — import revenue and cost data from Looker into a financial model in Sheets
- Sales dashboards — sync pipeline and bookings Looks into a Sheets dashboard for the leadership team
- Investor reporting — combine Looker KPIs with written commentary in a Sheets investor update
- Weekly ops review — schedule a Friday import of key operational Looks for the Monday review meeting
Troubleshooting common issues
Frequently asked questions
Can I export Looker data to Google Sheets automatically?
Yes. Brooked connects to Looker's API and can import saved Looks or Explore queries into Google Sheets on a schedule. Set up daily auto-refresh and your sheets stay current with Looker without any manual CSV downloads.
Does Brooked work with Looker Studio (formerly Google Data Studio)?
No — Brooked connects to Looker (the BI platform, formerly Looker.com, now part of Google Cloud). Looker Studio is a separate free visualization tool. They are different products despite the similar name.
Do I need a Looker admin to set up the API connection?
You need the ability to create API3 keys for a Looker user. Most Looker admins can generate these for you, or you can do it yourself if you have Admin access. The API user needs view access to the Looks or models you want to import.
Can I schedule Looker Look refreshes in Google Sheets?
Yes. On Brooked Pro, any Looker import can be set to auto-refresh daily or weekly. The sheet range updates automatically with the latest data from Looker — no manual action required.
Is there a free Looker connector for Google Sheets?
Yes. Brooked's free tier includes 100 Looker imports per month with no credit card required. Pro is $29/user/month and adds unlimited imports, scheduled auto-refresh, and AI chat.
Stop downloading CSVs from Looker.
Install Brooked free — 100 imports per month, no credit card required. Or see the full Looker integration details.
Install Brooked free →