Integrations / Business Intelligence
Manage Metabase cards and tables from WhatsApp
Flann connects Metabase to the WhatsApp chat you already run your business from. You ask, and Flann picks the right Metabase action. Reading data never changes it, so Flann answers questions from Metabase straight away. Writing is another matter.
188 actions in Metabase. 122 only look things up, and 66 create, update, send or delete. You connect with your API key.
What you can ask Flann to do in Metabase
Type it or say it in a voice note. Flann works out which Metabase action you mean.
“Show me my collection items in Metabase.”
“Find items in Metabase.”
“Show me my popular items in Metabase.”
“Delete the timeline event in Metabase.”
“Send a password reset email from Metabase.”
“Create a card in Metabase.”
What Flann can work with in Metabase
Metabase gives Flann 188 actions across 57 kinds of record. These are the ones you are most likely to use.
| Record | What Flann can do | Actions |
|---|---|---|
| Cards | deletelook upcreatecopyupdate | 6 |
| Tables | look up | 4 |
| Timeline events | deletelook upupdate | 3 |
| Users | look upupdate | 3 |
| Pulse preview cards | look up | 2 |
| Remote sync tasks | look upcancel | 2 |
| Dashboards | copydeletelook upcreateupdate | 6 |
| Timelines | deletelook upcreateupdate | 5 |
Side by side, the two ways of working in Metabase:
| Compare | Opening MetabaseLog in, find it, do it | Metabase through FlannAsk and get it done |
|---|---|---|
| Getting started on a job | Log in and click through the screens | Text or voice note, in your own words |
| Looking things up about cards | By hand, screen by screen | 122 look-ups, answered straight away |
| Creating and updating | Typed in by hand | 66 changes, made from a message |
| Metabase records | All of them, one screen at a time | 57 kinds, from one chat |
| Set-up | Nothing new to set up | Your Metabase API key, once |
YesPartlyNo
Step by step: Metabase jobs you can hand to Flann
What happens between your message and the result in Metabase.
Create a card from a voice note
- You message Flann on WhatsApp: “Create a card in Metabase with these details.”
- Flann runs
Get Card by IDin Metabase and shows you what it found. - Flann runs
Create Cardin Metabase. - Flann creates it in Metabase and confirms in the chat.
Get answers about your tables
- You message Flann on WhatsApp: “What is the latest on our tables in Metabase?”
- Flann runs
List TablesandGet Table By IDin Metabase and shows you what it found. - Nothing in Metabase is changed: these are look-ups, so they run straight away.
Fix a timeline event without opening Metabase
- You message Flann on WhatsApp: “Change the timeline event in Metabase: here is what is different.”
- Flann runs
Get Timeline Eventin Metabase and shows you what it found. - Flann runs
Update Timeline Event by IDin Metabase. - Flann makes the change in Metabase and confirms in the chat.
The Metabase jobs you can stop doing yourself
You stay in charge of what goes out. Flann does the reading, the drafting and the chasing.
Spotting a sudden change early
Today
Drops in bookings or jumps in returns can go unnoticed for days in Metabase. You find out when the month closes, too late to do much.
With Flann
“Has anything in Metabase moved unusually this week?”
Scanning Metabase for figures that broke from their usual pattern, Flann lists the ones that moved most and suggests a likely cause where the data points to one. You can ask it to check every morning. Reading is instant, and no changes are made.
What you stop doing: Finding problems weeks late in the monthly figures no longer happens.
Finding what earns and what does not
Today
Instinct tells you which products or services carry the business, but checking means exporting from Metabase and sorting a spreadsheet.
With Flann
“Rank our services by revenue for the quarter from Metabase. What’s slipping?”
Every product or service in Metabase is ranked by revenue and by volume, and Flann points out the ones slipping compared with last quarter. You get the top and the bottom of the list, not the whole thing.
What you stop doing: Exporting and sorting spreadsheets to test a hunch is over.
More on this: how to hand repetitive tasks to an AI agent on WhatsApp.
How Flann connects to Metabase
- In Flann, go to Connectors and find Metabase.
- Paste your Metabase API key into the secure form Flann opens. You will find the key in your Metabase account settings.
- From then on, message Flann on WhatsApp. It works in Metabase whenever a request needs it.
Reading from Metabase is instant. Metabase stays connected until you remove it in Connectors.
Ways to use Metabase with Flann
Check before you decide
Before a big call, ask Flann for the figure that matters. It looks it up in Metabase first.
Ask, do not dig
Ask how this week compares to last. Flann pulls the numbers from Metabase and answers in plain words.
Spot what changed
Ask what went up or down. Flann checks Metabase and tells you what moved.
Everything Flann can do in Metabase
All 188 Metabase actions, as Flann sees them.
Looks up 122
- Execute Dataset Query
- Get all collections
- Get API Card
- Get Card by ID
- Get Collection by ID
- Get Collection Items
- Get Current User
- Get Dashboard by ID
- Get Database By ID
- Get Table By ID
- Get Table Schema
- List Databases
- List Tables
- Search Metabase objects
- Check Password Complexity
- Check Snippet Dependencies
- Convert Query to Native SQL
- Execute Dashboard Card Query
- Execute Pivot Table Query
- Filter Records
- Generate Random Security Token
- Get Action
- Get All Alerts
- Get all Metabase actions
- Get all native query snippets
- Get All Pulses
- Get All Segments
- Get All Timelines
- Get API Glossary
- Get Automagic Comparison Dashboard
and 92 more
Changes 66
- Copy Card
- Create Card
- Create Collection
- Create Dashboard
- Delete Card
- Delete Dashboard
- Update Card by ID
- Update Dashboard
- Update Database Configuration
- Bulk Move Cards
- Bulk Move Cards to Collection
- Cancel Current Remote Sync Task
- Copy Dashboard
- Create Bookmark
- Create Dashboard Subscription
- Create Field Dimension
- Create Glossary Entry
- Create Model Index
- Create native query snippet
- Create Notification
- Create Pulse
- Create Timeline
- Delete Action
- Delete API Cache
- Delete Bookmark
- Delete Field Dimension
- Delete Glossary Entry
- Delete Model Index
- Delete Timeline
- Delete Timeline Event
and 36 more
More Business Intelligence apps Flann works with
Common questions
What can Flann do with cards in Metabase?
Flann can delete, look up, create, copy and update cards in Metabase, using 6 actions (Delete Card, Get Card by ID, Get Public Card by UUID, Create Card and more). Looking up runs straight away and changes nothing. The other actions create or change cards in Metabase.
What can Flann do with tables in Metabase?
Flann can look up tables in Metabase, using 4 actions (Get Table By ID, Get Table Data, List Tables, Get Table Details). All of them only look things up, so they run straight away.
How does Flann connect to Metabase?
Open Connectors in Flann, choose Metabase and paste your Metabase API key into a secure form. You will find the key in your Metabase account settings. Once it is connected, Flann can use 188 actions in Metabase.
How do I ask Flann to do something in Metabase?
Message Flann on WhatsApp the way you would message a colleague, or send a voice note. Flann picks the Metabase action that fits and asks if anything is missing.
Which Flann plan do I need for Metabase?
Any of them. Every Flann plan includes Metabase and every other app.