The Scenario
A senior analyst is being onboarded into a company that uses Metabase heavily. She's been asked to contribute to a data documentation wiki and the first deliverable is a complete list of all Metabase segments — the reusable filter conditions that define things like "active customers," "churned accounts," and "enterprise tier." The non-technical stakeholders who read the wiki need to understand what each segment covers without opening Metabase.
The bad version:
- Navigate to the Metabase admin panel, find the Segments section, and start reading through each segment's name, associated table, and filter definition.
- Copy each segment's details manually into a spreadsheet, row by row.
- Discover that filter definitions in Metabase are stored as JSON-like objects and that writing a plain-English summary of each requires you to interpret the filter logic by hand.
- Finish 12 of the 30 segments before the end of the day and promise to finish the rest tomorrow.
The documentation gap exists because writing it manually is a full day of work that gets bumped every time something more urgent comes up.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It can list all Metabase segments — with ID, name, table, description, and creator — and write the full inventory into the sheet in a single pass.
List all Metabase segments and write each segment's ID, name, table name, description, and creator into this sheet
What You Get
- One row per segment: ID, name, associated table name, description (as entered in Metabase), and creator name.
- All 30 segments land in the sheet in one pass — no manual copying.
- Segments with no description land with a blank in the description column, making them easy to identify and fill in.
What If the Data Is Not Quite Ready
You want to flag recently modified segments
Fetch all Metabase segments and write name, definition summary, and associated table into this sheet — highlight any segment that has been modified in the last 30 days
Useful when the wiki needs to reflect current definitions: recently modified segments may need their plain-English summaries updated.
You want the segments grouped by table
List all Metabase segments and write them into this sheet grouped by associated table name, with a blank row between each table group and the table name as a section header
The documentation reads like a reference guide, organized by the data object rather than alphabetically.
You need to check which segments lack descriptions
List all Metabase segments and write ID, name, table, and description into this sheet. In column E, write NEEDS DESCRIPTION for any segment where the description field is empty, otherwise leave it blank.
The analyst gets an actionable list of what to document rather than a wall of blank cells.
Full segment documentation pass in one shot
List all Metabase segments and write ID, name, associated table, description, creator, and last modified date into this sheet. In column G write NEEDS DESCRIPTION if description is empty. Sort by associated table name ascending. In a second tab write a summary: total segments, count by table, count missing descriptions.
One prompt: the working documentation sheet and the gap analysis summary. The wiki team can start filling in descriptions the same day.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet for your data documentation project, then ask it to pull all Metabase segments into the sheet. Also useful: exporting a full Metabase data dictionary, and the hub overview on connecting Metabase to Google Sheets.