The Scenario
The board meeting is in two days and the VP of Marketing just forwarded you a request: she needs the data behind every card on the "Marketing Performance" dashboard exported into a Google Sheet, one tab per card. Metabase won't be accessible during the offsite. She needs the numbers available offline, formatted cleanly, before she gets on the plane tomorrow morning.
The bad version:
- Open the Marketing Performance dashboard in Metabase, count the cards — there are eight — and begin clicking through each one to find the download button.
- Download each card's CSV individually, naming them carefully so you know which is which.
- Open each CSV, copy the data, switch to the Google Sheet, create a new tab, name it after the card, and paste.
- Discover that two of the cards have visualization-only results that don't export cleanly to CSV, requiring you to screenshot them instead and paste images into the sheet.
Eight cards. Eight CSV downloads. Eight pastes. One flight deadline. And two cards that break the workflow entirely.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It can fetch a Metabase dashboard, execute the query behind each card, and write the results into separate tabs in a single pass — no individual CSV exports.
Fetch the Metabase dashboard with ID 14, then for each card on it execute the query and write results into a separate tab of this sheet named after the card — include column headers on each tab
What You Get
- One tab per dashboard card, named after the card.
- Each tab has a header row matching the query's column names.
- The data reflects the current database state at the time of the prompt, not a cached visualization from yesterday.
- If a card's query returns no rows, the tab has the header row and a note — you know it ran, you know it returned empty, and you can tell the VP why before she asks.
What If the Data Is Not Quite Ready
You only need the first 10 rows of each card for a summary view
Get all cards from Metabase dashboard ID 14 and for each card write its name and the first 10 rows of its query results into this sheet, stacking them vertically with a blank row between each card's section
A single-tab summary view rather than one tab per card — useful when the dashboard has many cards and the VP wants a quick scan, not a deep dive.
One card's data needs a calculated column added
Fetch Metabase dashboard ID 14, write each card's query results into a separate tab named after the card, and for the tab named Paid Campaigns add a column G labeled CPC calculated as spend divided by clicks
The CPC column lands alongside the raw data, calculated row by row, without requiring any post-paste formula work.
You want a table of contents tab that links to each card tab
Fetch Metabase dashboard ID 14, write each card's results into a separate tab named after the card, and create a Table of Contents tab that lists each card name in column A and its row count in column B
The VP can use the TOC tab to navigate the workbook on a laptop without a Metabase connection.
Full offline dashboard package in one shot
Fetch Metabase dashboard ID 14, write each card's query results into a tab named after the card with headers, create a TOC tab listing card names and row counts, and in the TOC tab's column C note any card that returned zero rows
One prompt. One sheet. Board-ready, even with the wifi off.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're preparing for the offsite, then ask it to pull the full Metabase dashboard into tabs before the VP's flight. Also useful: consolidating multiple saved Metabase questions into one sheet, and the hub overview on connecting Metabase to Google Sheets.