The Scenario
You're the data governance lead and there's an audit coming. The compliance team wants a list of every Metabase card and dashboard: what it's called, who created it, where it lives, and when it was last touched. Your Metabase instance has been accumulating content for three years. Nobody has ever done a full inventory. You have until end of week.
The bad version:
- Open Metabase and start scrolling through collections, manually noting card names, collection paths, and creator names into a spreadsheet.
- Realize that nested collections don't show their full path without clicking into each one, so you can't tell at a glance whether "Marketing" is under "Teams" or "Legacy."
- Get to card 80 out of an estimated 400 and accept that this approach will not finish by Friday.
An audit that requires manual enumeration of 400 items is an audit that doesn't get done properly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It can query the Metabase API to list every card and dashboard your user can access — with collection paths, creator names, and timestamps — and write the inventory into the sheet in one pass.
List all Metabase cards the current user can access and write each card's ID, name, collection path, creator name, and last updated date into Sheet1, then list all dashboards with the same fields into Sheet2
What You Get
- Sheet1 contains every accessible card: ID, name, collection path, creator name, last updated date.
- Sheet2 contains every accessible dashboard with the same five columns.
- Both sheets have header rows.
- Cards in nested collections show the full path — not just the immediate parent — so you can tell exactly where each piece of content lives.
What If the Data Is Not Quite Ready
You need collection structure first, then content counts
Fetch all Metabase collections, list them in Sheet1 with ID, name, and parent collection path, then for each collection write a count of how many cards and dashboards it contains into columns D and E
The compliance team gets the org chart of the Metabase workspace alongside the content volume per collection — useful for identifying which teams are heavy users and which collections are orphaned.
You want to flag stale content automatically
List all Metabase cards and write ID, name, collection path, creator, and last updated date into Sheet1 — in column F, write STALE for any card where the last updated date is more than 365 days ago, otherwise leave it blank
The STALE flag gives the governance team an immediate triage view without a manual date comparison.
You need to see which creator owns the most content
List all Metabase cards and dashboards and write them into Sheet1, then in Sheet2 write a summary with one row per creator name showing how many cards and how many dashboards they own, sorted by total count descending
Useful for understanding who to talk to when planning a cleanup or migration.
Full audit package in one shot
List all Metabase cards in Sheet1 and all dashboards in Sheet2, each with ID, name, collection path, creator, and last updated date. In column F flag any item not updated in 365+ days as STALE. In Sheet3 write a summary: total cards, total dashboards, stale cards count, stale dashboards count, and the top 5 creators by total item count.
One prompt, three sheets, full audit package. The compliance team gets a working deliverable, not a promise.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using to prepare your governance audit, then ask it to pull the full Metabase content inventory into tabs. Also useful: pulling Metabase dashboard revision history for a change log, and the hub overview on connecting Metabase to Google Sheets.