Build With AI

5 Interactive
Dashboards Hiding
In Your Inbox

Connect Claude to Gmail and build 5 fully visual, interactive dashboards as Claude Artifacts. Not boring tables. Maps with pins. Charts. Color-coded leaderboards. Copy-paste action buttons. Each one ships as a single self-contained file you can open in your browser.

Years of flight confirmations, hotel bookings, subscription receipts, food delivery orders, return shipping labels, and price-change emails are sitting unread in your Gmail. None of it is organized. Almost none of it is searchable in a useful way. And almost nobody actually uses any of it as a data source.

Once you connect Claude to Gmail through Connectors, that changes. Claude can read your inbox like a database — pull patterns, do math, cross-reference dates — and then build you an interactive Artifact: a single HTML file with real charts, real maps, real interactive UI, that you can open in your browser, save, and share.

Quick setup: open Claude → Settings → Connectors → Gmail → Connect. Sign in with the Google account that has your inbox. Then save each of the 5 prompts below into a Claude Project so you can rerun them every month for free (Project context doesn't count against your usage limit).

Now pick a dashboard. Each one is its own full prompt with both the data extraction and the design spec, so you don't get a boring spreadsheet — you get a real product.

Dashboard 1 Your Travel Map (Interactive World Map + Pins)

What you'll see when it's done: a full-width interactive world map with a colored pin for every trip you've taken in the last 5 years. Hover a pin and you get a tooltip with the city, dates, and vendor. Click a pin and a side panel opens with the full trip details. Below the map, four giant stats — total trips, unique cities, unique countries, total cost. Below that, a sortable searchable trip list. At the bottom, a year-by-year bar chart showing your travel rhythm.

The point isn't just to look at the past. It's to see the pattern. Most people running this for the first time realize they've been to more places than they thought, or that one year was secretly their travel peak, or that they've been visiting the same three cities for years without noticing.

Paste this in a new Claude chat with the Gmail connector turned on. Claude will read your inbox, then build the dashboard as an Artifact you can open right in the chat.

Copy this prompt

You have read access to my Gmail. I want you to build me a beautiful interactive travel map dashboard as a Claude Artifact.

STEP 1 — EXTRACT THE DATA

Search my Gmail for all flight confirmations, hotel bookings, Airbnb reservations, and rental car receipts from the last 5 years. For each one, extract:
- Destination city and country (with lat/long if you can infer it)
- Arrival date and departure date
- Type (flight / hotel / Airbnb / rental car)
- Vendor (airline name, hotel chain, etc.)
- Cost (only if cleanly readable — leave blank if not, do NOT guess)
- A confidence label: high / medium / low

Consolidate by TRIP. A trip = a sequence of bookings with overlapping or consecutive dates in the same city or region. Each trip gets a single date range, a primary destination, and a total cost (sum of any cleanly-extracted costs).

STEP 2 — BUILD THE INTERACTIVE DASHBOARD AS AN ARTIFACT

Create a single self-contained HTML file artifact. Use Leaflet.js loaded from CDN for the interactive world map.

DESIGN:
- Dark mode by default. Background #0e0e10, text #f5f5f5, accent color #d02e2e (red).
- Typography: Inter or system sans-serif. Modern, lots of white space, no clutter.
- Layout (top to bottom):
  1. HEADER strip — title "Your Travel Atlas" + subtitle with the date range covered.
  2. INTERACTIVE WORLD MAP — full-width, 60% of viewport height. Use a clean dark map tile layer (e.g., CartoDB dark matter). Drop a colored pin for every trip, sized slightly by cost if known. Color-code pins by YEAR using a 5-color sequential palette (most recent year = the accent red, oldest = a muted teal). On hover: show trip name + dates + vendor in a tooltip. On click: open a side panel with full trip details, including a link back to the original confirmation email in Gmail when possible.
  3. STAT STRIP — four giant numbers side by side: total trips, unique cities, unique countries, total spent. Use 64px display font, all caps eyebrow labels under each.
  4. SORTABLE TRIP TABLE — every trip with date, city, country, vendor, cost. Add a search input that filters live, and column sort controls. Highlight the most expensive 3 rows.
  5. YEAR-BY-YEAR BAR CHART — horizontal bars showing number of trips per year, color-matched to the map pins.
- Subtle 200ms transitions when filters update.
- Fully mobile-responsive — stack the map full-width on phones.

IF DATA IS MISSING: show a friendly empty-state instead of fake pins. Be honest about confidence — show a small icon next to low-confidence trips.

Return the artifact in a single HTML file I can save and open in any browser. Don't summarize what you built outside the artifact — just build it.

Pro move

Save the finished artifact as travel-atlas.html on your desktop and reopen it any time. Rerun the prompt every 6 months — Claude will rebuild it with fresh trips appended.

Dashboard 2 The Subscription Kill List

What you'll see when it's done: a clean light-mode dashboard with three giant numbers at the top — monthly total, annual total, subscription count. Below: a horizontal bar chart ranking every subscription by annual cost (most expensive at the top). Below that: a donut chart breaking down spend by category. Then the part everyone screenshots: the Kill List — every subscription that hasn't billed in 60+ days, with the total dollar amount you'd recover if you cancelled them, plus a copy-paste cancellation email next to each one.

This is the dashboard that pays for itself in under an hour. Most users find $200–$500/month of subscriptions they forgot about. The Kill List makes acting on them a single copy-paste away.

Paste this with Gmail connected:

Copy this prompt

You have read access to my Gmail. Build me a subscription audit dashboard as a Claude Artifact.

STEP 1 — EXTRACT THE DATA

Search my Gmail for every recurring charge, subscription renewal, auto-billing notice, or membership fee in the last 24 months. Consolidate into unique subscriptions. For each subscription extract:
- Vendor / service name
- Category (entertainment / productivity / fitness / finance / professional / utility / news_media / cloud_storage / other)
- Billing frequency (monthly / annual / quarterly / other)
- Most recent charge amount
- Most recent charge date
- Annual cost (most recent amount × frequency multiplier)
- Status: "active" if charged in the last 60 days, "dormant" if 60–180 days, "likely cancelled" if >180 days
- A confidence flag — if you're <80% sure something is a real subscription, mark it "uncertain" and exclude it from the totals (still show it in the table with a warning icon)

STEP 2 — BUILD THE DASHBOARD AS AN ARTIFACT

Create a single self-contained HTML file. Use Tailwind via CDN for styling and Chart.js via CDN for charts.

DESIGN:
- Light mode. Off-white background (#fafaf7), black text, one bold accent color: #d02e2e (red).
- Typography: a clean serif for headlines (Playfair Display or similar via Google Fonts), a clean sans for body (Inter).
- Layout (top to bottom):
  1. HERO — three giant numbers side by side in rounded cards: "Monthly Total" (sum of all monthly equivalents), "Annual Total" (×12), and "Subscriptions" (count of active subs). Each number 64px, with a small eyebrow label above and a tiny trend indicator below if you can spot one.
  2. RANKED BAR CHART — horizontal bar chart of every active subscription by annual cost, descending. Use the red accent. Show exact dollar amount at the end of each bar.
  3. CATEGORY DONUT — donut chart of annual spend by category. Center label shows the total. Each slice color-coded with a clean modern palette.
  4. THE KILL LIST — a highlighted section with bold heading "Subscriptions To Kill". Show every "dormant" + "likely cancelled" subscription as a card. Each card has: vendor name, last charge date, annual cost, and a Cancel button. When the Cancel button is clicked, open a modal with a copy-paste cancellation email pre-filled (subject and body) for that specific vendor. At the top of the Kill List section, show the total $ that could be recovered if everything were cancelled.
  5. FULL TABLE — every subscription including uncertain ones. Columns: vendor, category, frequency, last charge, status, annual cost. Searchable + filterable by status.
- Use rounded cards (border-radius 12px), generous padding, soft shadows. Make the Kill List section visually heavier than the table — that's where the action is.
- Fully mobile-responsive.

Do NOT include uncertain subscriptions in the hero totals or the bar chart. Only confident actives.

Return as a single HTML artifact I can save and open in a browser. Just build it — don't narrate it.

Save it

Save the artifact as subscription-kill-list.html and rerun the prompt at the start of every quarter. Subscriptions appear faster than you cancel them.

Dashboard 3 Your Food Spending Year-In-Review

What you'll see when it's done: an editorial-magazine-style dashboard that opens with one giant number — your total food spending for the last 12 months — in a serif display font. Below: a donut chart breaking it down across DoorDash + Uber Eats + groceries + restaurants + coffee. Then a 12-month trend line with the top 3 expensive months annotated. A top-10 vendors leaderboard with order counts. A callout for the single biggest order. And a daily-average that quietly destroys you ("$47/day").

This is the dashboard everyone screenshots for the group chat. Most people underestimate their actual food spend by 30–50% because they count groceries but forget the steady drip of delivery, coffee, and Sunday brunches. Once you see the number, you can't unsee it.

Paste this with Gmail connected:

Copy this prompt

You have read access to my Gmail. Build me a year-in-review-style food spending dashboard as a Claude Artifact.

STEP 1 — EXTRACT THE DATA

Search my Gmail for receipts from the last 12 months across:
- Food delivery: DoorDash, Uber Eats, Grubhub, Postmates, Caviar, Seamless
- Grocery delivery: Instacart, Amazon Fresh, Whole Foods, Walmart Grocery, Gopuff
- Restaurant receipts and reservation charges (OpenTable, Resy, Toast, direct restaurant charges)
- Coffee chains: Starbucks, Dunkin', Blue Bottle, Philz, Peet's

Exclude subscription-style charges (handled by the subscription dashboard). Only count actual orders.

For each order extract: date, vendor, category (delivery / grocery / restaurant / coffee), total, and city if visible.

STEP 2 — BUILD THE DASHBOARD AS AN ARTIFACT

Create a single self-contained HTML artifact. Use Chart.js via CDN.

DESIGN — "Editorial magazine year-in-review":
- Cream background (#fffae7), black text (#2f2d2d), one accent color (#d02e2e).
- Typography: serif display font for hero numbers (Playfair Display or Cormorant via Google Fonts), clean sans for body (Inter).
- Generous whitespace. Editorial pacing — each section feels like turning the page.
- Layout (top to bottom):
  1. HERO — one giant number, the total food spend in the last 12 months, in 96px serif. Centered. Below it: "across N orders, M unique vendors." Below that: a tiny eyebrow that says "Year-In-Review · [DATE RANGE]".
  2. CATEGORY DONUT — donut chart breaking spend into delivery vs grocery vs restaurant vs coffee. The biggest category slice in the accent red. Each slice labeled with its $ and %.
  3. MONTHLY TREND — a line chart showing monthly spend over the last 12 months. Smooth the line. Annotate the top 3 most expensive months with a small text label explaining the likely cause (e.g., "holiday season", "moving week" if delivery spikes, etc.).
  4. VENDORS LEADERBOARD — top 10 vendors by total spend, shown as a vertical list of cards. Each card: vendor name, category icon, total $ spent, total order count, and a tiny bar showing share of total food spend.
  5. BIGGEST SINGLE ORDER — a callout card showing the single largest food charge of the year — vendor, date, amount, and category. Make it feel like a confession.
  6. THE DAILY AVERAGE — a small final block: "That's $X/day. Or $Y/week. Or $Z/month." In the same editorial tone.
- Subtle scroll-triggered fade-ins on each section.
- Mobile-responsive.

Feel: like opening a Stripe or Cash App year-in-review. Indulgent, designed, beautiful. NOT a spreadsheet. NOT an expense report.

Return as a single HTML artifact.
Dashboard 4 Money You're Owed (Missed Refunds)

What you'll see when it's done: a slightly aggressive "wake-up call" dashboard. At the top: one giant red number — the total dollar amount potentially owed back to you across all unmatched returns. Below: a two-column split — refunded returns on the left (green tinted, calm), missing or pending refunds on the right (red tinted, demanding action). Every item on the right has a Take Action button that opens a copy-paste email template pre-filled with that return's specific details, ready to send to the vendor.

The whole point is recovery. Most people are owed somewhere between $50 and $300 they never got back. This dashboard surfaces it AND makes the email outreach a single click.

Paste this with Gmail connected:

Copy this prompt

You have read access to my Gmail. Build me a "Money You're Owed" dashboard as a Claude Artifact.

STEP 1 — EXTRACT AND MATCH THE DATA

Search my Gmail for the last 24 months for:
- Return shipping labels and return confirmations (UPS, USPS, FedEx, store-specific return emails, online retailer return acknowledgments)
- Refund receipts and credits issued back to me from those same vendors

For every return found, attempt to match it to a refund receipt from the same vendor within 30 days for a similar dollar amount (±$5 tolerance, or ±10% if the amount is unclear). Mark each return as:
- REFUNDED (matched refund found)
- PENDING (return logged but no refund yet, <14 days)
- MISSED (return logged, no refund, >14 days — flag for action)

For each MISSED entry, capture: vendor, item description (if findable), return date, expected refund amount, days since return, and a link to the original order email if possible.

STEP 2 — BUILD THE DASHBOARD AS AN ARTIFACT

Create a single self-contained HTML artifact. Use Tailwind via CDN.

DESIGN — "Wake-up call meets battle plan":
- Light background (#fafaf7), strong red accent (#d02e2e), strong green accent for refunded items (#2f7d4a).
- Layout (top to bottom):
  1. HERO — one enormous red dollar amount (96px display): the total $ across all MISSED + PENDING returns. Subtitle: "across N unmatched returns. Oldest: [DAYS] days ago."
  2. SPLIT VIEW — two columns:
     LEFT (green tinted background): "Refunded" list. Each row: a small green checkmark, vendor name, return date, refund amount, refund date. Calm, archival feel.
     RIGHT (red tinted background): "Missing or Pending" list. Each row is a full action card with: vendor name, return date, days-since-return badge (red if >30 days), expected refund amount, and a prominent "Send Refund Inquiry" button.
  3. CLICKING A BUTTON: opens a modal with a pre-filled email template. Subject: "Refund status for [VENDOR] return on [DATE]". Body: a polite-but-firm script with the return details, the expected amount, and a 7-day response request. Include a "Copy to Clipboard" button.
  4. STAT STRIP under the split: average days-since-return for missed refunds, oldest missed refund (vendor + date), biggest dollar amount in the missed list.
  5. EXPORT button at the bottom: download all missed returns as a CSV in case the user wants to track outreach in a spreadsheet.
- Mobile responsive — stack the columns on phones.

This dashboard is meant to be acted on, not just read. Make the Take Action buttons visually heavy. Make the refunded items visually quiet.

Return as a single HTML artifact.

Pro tip

Set a calendar reminder to run this every 60 days. Returns get forgotten fast — even by the vendor.

Dashboard 5 The Price-Increase Tracker

What you'll see when it's done: an investor-presentation-style dashboard. The hero line is brutal: "Your subscriptions have gotten X% more expensive since [YEAR]. That's an extra $Y/month vs the first prices you paid." Below: a "Biggest Climbers" leaderboard showing the top 5 subscriptions by % price increase. Then a multi-line chart with every subscription's price history normalized to 100 so you can compare the slope of the increases at a glance. Then a "Quiet Increases" section flagging subs that raised prices without announcing it. Then an "Anniversary Watch" of subs renewing in the next 30 days.

Most people have never seen this data laid out. Netflix has nearly tripled since the early 2010s. So has almost every SaaS tool you pay for, in smaller increments. The dashboard ends with copy-paste negotiation scripts you can fire off in 60 seconds.

Paste this with Gmail connected:

Copy this prompt

You have read access to my Gmail. Build me a subscription price-history dashboard as a Claude Artifact.

STEP 1 — EXTRACT THE DATA

Using the same logic as the subscription dashboard, identify every active subscription. Then for each one, search my Gmail for every billing receipt going back as far as possible (Gmail typically holds 5–15 years).

For each subscription build a full price history:
- Subscription name
- First observed price + date
- Every distinct price observed + the date range each price was charged
- Current (most recent) price + date
- Total % increase from first to current
- Number of price changes detected
- Whether each price increase was preceded by an announcement email (a "Your subscription is changing" or similar email within 14 days before the change). If no announcement found, flag as a "quiet increase".
- Estimated next renewal date (based on billing frequency + last charge)

STEP 2 — BUILD THE DASHBOARD AS AN ARTIFACT

Create a single self-contained HTML artifact. Use Chart.js via CDN.

DESIGN — "Investor presentation meets wake-up call":
- Light off-white background (#fafaf7), black text, one bold red accent (#d02e2e).
- Typography: a clean modern sans (Inter), with numbers in a slightly heavier weight. Some Anton or condensed display font for the hero line.
- Layout (top to bottom):
  1. HERO — one line, dense, 56px: "Your subscriptions are X% more expensive than when you started paying." Below in smaller text: "That's an extra $Y/month vs your first prices. You've paid an extra $Z over the lifetime of these subs because of increases."
  2. BIGGEST CLIMBERS — leaderboard of the top 5 subscriptions ranked by % price increase. Each row: subscription name, first price + date, current price + date, % increase (in red), $ increase. Bar chart visualization for each row.
  3. THE NORMALIZED CHART — a single multi-line chart with EVERY subscription's price history. All lines normalized to start at 100. Y-axis label: "% of original price". This lets you compare the slope of price increases across subscriptions at a glance.
  4. QUIET INCREASES — a flagged section listing subscriptions whose prices increased without any matching announcement email in my inbox. These are the ones to push back on. Each row has a "Push Back" button.
  5. ANNIVERSARY WATCH — a list of every subscription renewing in the next 30 days, sorted by the date of next renewal. For each, show: vendor, next renewal date, last 3 prices charged, and whether they historically raise prices around this date.
  6. NEGOTIATE BUTTON — every subscription card has a "Negotiate" button that opens a modal with a pre-filled email/chat script: "Hi [Vendor], I've been a customer since [DATE]. My subscription price has gone from $X to $Y over Z years. I'd like to discuss either a return to the previous tier pricing, a discount to retain me, or I'll need to consider cancelling." Include a Copy to Clipboard button.
- Mobile responsive.

Make the chart the visual centerpiece — most users have never seen their subscription prices plotted over time. It should be the part they screenshot.

Return as a single HTML artifact.

The negotiate trick

About 40% of subscription retention teams will offer a discount when a long-time customer pushes back on a price increase — but only if you ask. The Negotiate buttons in the dashboard are the lowest-friction way to actually do it.

Pick one

Don't try to build all 5 in one afternoon. Pick the one that maps to a question you've actually been asking yourself (where is my money going, when did Netflix triple, did I really get that refund) and build that one first. The others can wait a week. Comment DASHBOARD on the original post and I'll send all 5 prompts in one DM.

The Only AI Masterclass You Need

Build AI Systems That Run Your Work, Business, And Life

If this guide helped, but you’re looking to go deeper, I got you!! My 30-Day Challenge takes you from saving AI tips you never use to actually building with AI, step-by-step.

I show you exactly how I automated two e-commerce brands, my social media, and most of my personal life, then hand you the agents, workflows & systems to do the same. I’m teaching you every single thing I know with one lesson and one build a day.

Join the AI Masterclass →

© 2026 Mariah Brunner. All rights reserved.