Revenue before the meeting
Sarah Chen, finance director at BigCo, asked what the weekly revenue Look showed. Memtro found the Look, checked its fields and filters, and ran it for its rows, using Looker's cached result first.
Looker + Memtro
What does the weekly revenue Look show, and which dashboards are in the Finance folder?
Memtro reads your Looker instance over API 4.0. It searches Looks and dashboards, reads a dashboard's tiles and the query behind each, browses folders and models, and runs a Look or saved query for up to 500 rows, asking for a cached result first. When asked and once an administrator has granted the action by name, it can save queries as Looks, create, copy, move or rename Looks, dashboards and folders, and delete them to Trash or permanently. It can send a scheduled delivery now, which may email people outside the company and cannot be recalled.
In Memtro
What you can do with Looker in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Looker tool, reads what it needs, and answers with the source cited.
What it does
- 01Searches saved Looks and dashboards by title or folder, with owner, last updated and view count
- 02Reads a dashboard's tiles and filters, and the query behind a Look, its model, explore, fields, filters and sorts, without running anything
- 03Runs a Look or saved query and returns its rows, 100 by default and at most 500, using a cached result first
- 04Lists folders, and LookML models with the explores a query can be built from
- 05When asked and granted, saves queries as Looks, creates, copies, renames or moves Looks, dashboards and folders, which changes who can see them, and deletes them to Trash or permanently
- 06When asked and granted, sends a scheduled delivery now to every recipient, which may include people outside the company and cannot be recalled, checks an alert now, or permanently deletes a schedule
Acts when asked
When you ask it to
These tools change something in Looker. The model is told to use them only when you ask for exactly that, and an administrator grants each one by name to the teams that may use it; a personal connection acts only after its owner allows it.
- 01Define a query (model, explore, fields, filters, sorts) so it can be saved as a Look
- 02Save a query as a new Look in a named folder
- 03Rename a Look, change its description or the query behind it
- 04Move a Look to another folder, which changes who can see it
- 05Delete a Look, to Trash by default or permanently when asked
- 06Create an empty dashboard in a named folder
- 07Rename a dashboard or change its description, refresh interval or display options
- 08Copy a dashboard into a named folder
- 09Move a dashboard to another folder, which changes who can see it
- 10Delete a dashboard, to Trash by default or permanently when asked
- 11Create a folder under a parent folder
- 12Send a scheduled delivery now to all of its recipients, as saved
- 13Check an alert now, which notifies its recipients if the condition is met
- 14Delete a scheduled delivery, permanently
In practice
Ask it like you would a colleague
Once Looker is connected, these are the kinds of things people ask. Plain questions, no syntax. If the answer lives partly in another system you have connected, Memtro looks there too.
Looker + Memtro
Which dashboards are in the Finance folder?
What does the weekly revenue Look show?
What fields and filters sit behind the pipeline Look?
What tiles are on the board KPIs dashboard?
Send the weekly revenue schedule now.
Saving a new view
Dan Fletcher, a data analyst at Acme Ltd, asked Memtro to save pipeline by region for this quarter as a Look in the Sales folder. Memtro defined the query on the sales explore and saved it there as a new Look, which everyone with access to the Sales folder could see and run.
Teams
Where it fits
The teams that lean on Looker most, a question each of them asks, and what they connect beside it.
- Data and analyticsQuestions answered from the warehouse, with the SQL shownAnalyst, Data engineer, Anybody with a question, Head of data“Revenue by segment for Q3 from the warehouse, with the SQL you used”Used alongside Postgres, Stripe, Slack, Google Drive, Snowflake and 3 more.
- MarketingSpend, leads and reputation in one conversationMarketing lead, Performance marketer, Content and SEO, Brand and community“How did last week's LinkedIn and Google campaigns do, and which leads reached the pipeline?”Used alongside Google Ads, Meta Ads, HubSpot, Google Analytics 4, Brevo and 7 more.
- LeadershipOne question across the whole companyFounder, Chief executive, Department head, Board member“What happened with our top ten accounts this week, and is anything at risk?”Used alongside HubSpot, Help Scout, Xero, Stripe, Linear and 6 more.
Better together
Works with
A record in Looker is rarely the whole story. Connect the systems that hold the rest and Memtro checks them together, then remembers what it learned so the next question starts further along.
- Marketing automationLooker with ActiveCampaignContacts, campaigns and automations from ActiveCampaign.
- Marketing automationLooker with BrevoEmail and SMS campaign results from Brevo.
- Marketing automationLooker with Customer.ioCampaign metrics and customer journeys from Customer.io.
- Databases and warehousesLooker with PostgresRead-only SQL over your warehouse or application database, written by the model from the schema.
- Databases and warehousesLooker with MySQL and MariaDBRead-only SQL over your MySQL or MariaDB database, directly or through an SSH tunnel.
- Databases and warehousesLooker with SQL ServerAsk questions of SQL Server and Azure SQL, safely.
- CRM and salesLooker with HubSpotContacts, companies, deals and tickets, with the rest of the company's memory attached.
- CRM and salesLooker with SalesforceAsk your CRM questions in plain English, down to the SOQL.
- CRM and salesLooker with Twenty CRMObjects, fields and records from the open-source CRM, and records it can create and change when you ask.
Also in Analytics
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
- Google Analytics 4
- Plausible Analytics
- Umami
- Google Search Console
- Segment
- App Store Connect
- Google Play Console
- Power BI
- Metabase
- Mixpanel
- Amplitude
- PostHog
- Baremetrics
- ChartMogul
- Fathom Analytics
- Matomo
CallRail
Fullstory- Pendo
WhatConverts- Tableau
- Qualtrics
Lightdash- Redash
Microsoft Clarity- Chameleon
Eppo
Holistics
Mouseflow- Optimizely
- Sigma Computing
- VWO
Setup
How to connect
Connect withAPI host, Client ID and Client secret
- 1
In Looker, open Admin → Users, pick a dedicated API user whose role covers only the models and folders Memtro should see, read-only unless it should also save Looks, edit dashboards or send schedules. On Looker (Google Cloud core) an admin must first enable API management for that user.
- 2
Under that user's API keys choose New API key, and copy the Client ID and the Client secret, which is shown once.
- 3
In Memtro, open Connections → Looker and paste API host (host name only, such as <instance>.cloud.looker.com), Client ID and Client secret. Set API port to 19999 only for an older AWS-hosted instance.
- 4
Ask: "Which dashboards are in the Finance folder?"
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Looker tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Looker?+
Only when you ask, and only what it has been granted: define a query (model, explore, fields, filters, sorts) so it can be saved as a Look; save a query as a new Look in a named folder; rename a Look, change its description or the query behind it; move a Look to another folder, which changes who can see it; delete a Look, to Trash by default or permanently when asked; create an empty dashboard in a named folder; rename a dashboard or change its description, refresh interval or display options; copy a dashboard into a named folder; move a dashboard to another folder, which changes who can see it; delete a dashboard, to Trash by default or permanently when asked; create a folder under a parent folder; send a scheduled delivery now to all of its recipients, as saved; check an alert now, which notifies its recipients if the condition is met; delete a scheduled delivery, permanently. Every other tool reads, searches or lists. The Connections page labels the tools that act, an administrator grants each one by name to the teams that may use it, and a personal connection acts only after its owner allows it.
Who can use a Looker connection?+
A personal connection serves only your own requests. A shared connection serves the organisation: everyone, or only the teams an admin chooses. Admins can always add shared connections; other members need the permission.
Does Memtro store my Looker data?+
Credentials are encrypted at rest. Tool results are cached briefly so agent loops do not repeat identical calls, and the facts the model extracts are saved to your organisation's memory with provenance (system, record and link) so they can be checked and superseded.
How do I connect Looker?+
API host, Client ID and Client secret. In Looker, open Admin → Users, pick a dedicated API user whose role covers only the models and folders Memtro should see, read-only unless it should also save Looks, edit dashboards or send schedules. On Looker (Google Cloud core) an admin must first enable API management for that user.
Connect Looker in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.