Tracing a missing report
Maya Okafor, finance analyst at Acme Ltd, asked why the Board pack had stopped arriving. Memtro read the workbook's scheduled exports and found the schedule suspended, with its owner and when it last changed.
Sigma Computing + Memtro
Which workbooks did finance update this month, and who receives them?
Sigma Computing answers questions about your BI estate. You see workbooks with their owners, versions and tags, each workbook's elements, the file tree of folders, data models and reports, teams, warehouse connections, scheduled exports and materialization jobs, and a member found by email. When asked and granted, Memtro can email a workbook as PDF, Excel or CSV to named people or teams, run a materialization, copy or version-tag a workbook, delete a scheduled export, add or deactivate a member and change a team's members. Worth knowing: the credentials act as their owner, so Memtro sees only what that person may.
In Memtro
What you can do with Sigma Computing in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Sigma Computing tool, reads what it needs, and answers with the source cited.
What it does
- 01See workbooks with folder path, link, latest version, owner, tags and when they were updated.
- 02List a workbook's tables, charts, pivots and controls with their column names.
- 03Browse folders, data models and reports, plus teams and warehouse connections with when they were last active.
- 04Check a workbook's scheduled exports with schedule and timezone, and follow a materialization job's status.
- 05When asked and granted, email a workbook as PDF, Excel or CSV to people or teams, who may be outside the company.
- 06When asked and granted, run a materialization on warehouse compute, copy or tag a workbook, add or deactivate members and change a team's members.
Acts when asked
When you ask it to
These tools change something in Sigma Computing. 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.
- 01Email a workbook as PDF, Excel or CSV to named people or teams
- 02Run a materialization for a workbook element (uses warehouse compute)
- 03Copy a workbook into a folder
- 04Add a version tag to a workbook
- 05Delete a scheduled export (permanent)
- 06Add a member, inviting them by email if you ask
- 07Deactivate a member
- 08Add or remove members of a team
In practice
Ask it like you would a colleague
Once Sigma Computing 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.
Sigma Computing + Memtro
Which workbooks did finance update this month?
Which charts and tables are in the Revenue overview workbook?
What scheduled exports does the Board pack workbook have?
Which warehouse connections have not been active lately?
Email the Weekly sales workbook as a PDF to the leadership team.
Sending the weekly pack
Dan Fletcher, head of finance at Northwind, asked Memtro to send the Weekly sales workbook as a PDF to the leadership team. Memtro exported it and Sigma emailed it to every member of that team.
Teams
Where it fits
The teams that lean on Sigma Computing 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 Sigma Computing 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 automationSigma Computing with ActiveCampaignContacts, campaigns and automations from ActiveCampaign.
- Marketing automationSigma Computing with BrevoEmail and SMS campaign results from Brevo.
- Marketing automationSigma Computing with Customer.ioCampaign metrics and customer journeys from Customer.io.
- Databases and warehousesSigma Computing with PostgresRead-only SQL over your warehouse or application database, written by the model from the schema.
- Databases and warehousesSigma Computing with MySQL and MariaDBRead-only SQL over your MySQL or MariaDB database, directly or through an SSH tunnel.
- Databases and warehousesSigma Computing with SQL ServerAsk questions of SQL Server and Azure SQL, safely.
- CRM and salesSigma Computing with HubSpotContacts, companies, deals and tickets, with the rest of the company's memory attached.
- CRM and salesSigma Computing with SalesforceAsk your CRM questions in plain English, down to the SOQL.
- CRM and salesSigma Computing 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
- Looker
Lightdash- Redash
Microsoft Clarity- Chameleon
Eppo
Holistics
Mouseflow- Optimizely
- VWO
Setup
How to connect
Connect withAPI base URL, Client ID and Secret
- 1
In Sigma, go to Administration, then Developer access, choose Create new, tick REST API, name it Memtro and pick an owner with only the access Memtro needs.
- 2
In Memtro, open Connections → Sigma Computing and paste the API base URL shown at the top of Developer access, the Client ID and the Secret, which Sigma shows once.
- 3
An administrator grants the actions by name, such as Send workbook or Deactivate member, to the teams that may use them.
- 4
Ask which workbooks finance updated this month.
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Sigma Computing tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Sigma Computing?+
Only when you ask, and only what it has been granted: email a workbook as PDF, Excel or CSV to named people or teams; run a materialization for a workbook element (uses warehouse compute); copy a workbook into a folder; add a version tag to a workbook; delete a scheduled export (permanent); add a member, inviting them by email if you ask; deactivate a member; add or remove members of a team. 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 Sigma Computing 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 Sigma Computing 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 Sigma Computing?+
API base URL, Client ID and Secret. In Sigma, go to Administration, then Developer access, choose Create new, tick REST API, name it Memtro and pick an owner with only the access Memtro needs.
Connect Sigma Computing in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.