The Scenario
Every Monday before the 9 AM leadership sync, you pull five Metabase saved questions — DAU, conversion rate, churn, LTV, ARR — into a single Excel workbook. Five cards. Five CSV downloads. Five paste operations, each into its own worksheet. You've done it nine Mondays in a row. The tenth Monday, one of the cards has been edited overnight and the column order has shifted. You don't notice until the meeting is already underway.
The bad version:
- Open each of the five saved questions in Metabase, run them, and download a CSV for each.
- Open each CSV in Excel, copy the data, switch to the target workbook, add a new worksheet, name it after the card, and paste.
- Discover partway through that two worksheets have conflicting column orders because the cards were edited at different times.
The real cost isn't the 25 minutes. It's that you're doing data entry when you should be doing analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It can execute multiple Metabase saved question cards in a single prompt and write each result into a separate worksheet, named and structured the way you specify.
Run Metabase card queries for card IDs 101, 102, 103, 104, and 105 and write each result into a separate worksheet named after the card — include column headers on each worksheet
What You Get
- Five worksheets created (or overwritten if they already exist), each named after the corresponding card.
- Each worksheet has a header row matching the columns the saved question returns.
- The data reflects the latest query execution — not a cached screenshot.
- If a card returns zero rows, the worksheet gets the header row and a note rather than a blank sheet.
What If the Data Is Not Quite Ready
One of the card IDs has changed since you last ran this
For each Metabase card ID in column A of the Index worksheet, execute the card query and write the first result row's key values into columns B through F on the same row, then write the full result into a separate worksheet named for the card
Driving the card list from the workbook means you update the list once — in the Index sheet — rather than rewriting the prompt.
You need results stacked vertically instead of across worksheets
Run Metabase card queries for card IDs 101, 102, 103, 104, and 105 and write each result into Sheet1, stacking them vertically with the card name as a section header and a blank row between each section
A single flat worksheet, section-labeled, ready for a weekly email paste or a PDF handout.
One card's result needs filtering before it lands in the workbook
Run Metabase card 102 and write only the rows where conversion_rate is greater than 0.05 into the Conversion worksheet with column headers
The filter applies before the data reaches the workbook — you're not loading 800 rows and hiding the rest.
Full refresh with data quality summary in one shot
Run Metabase card queries for card IDs 101, 102, 103, 104, and 105, write each into its own worksheet with headers, then in a Summary worksheet write one row per card showing card name, row count, and whether any numeric column contains a null value
Refresh all five cards and get a data quality check in a single prompt. Walk into the meeting knowing whether anything needs a caveat.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for your weekly leadership metrics, then ask it to pull all your Metabase saved questions into their worksheets in one pass. Also useful: running a custom SQL query from Metabase into an Excel workbook, and the hub overview on connecting Metabase to Excel.