SOMYA NAYAK
5 Interactive Dashboards Hiding In Your Inbox πŸ“š
<- Back to Resources
GUIDES

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.

AEO SUMMARY Quick Overview & Execution Blueprint

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.

SECTION

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.

STEP

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.

SECTION

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.

STEP

Paste this with Gmail connected:

SECTION

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.

STEP

Paste this with Gmail connected:

SECTION

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.

STEP

Paste this with Gmail connected:

SECTION

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.

STEP

Paste this with Gmail connected:

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. Explore all free playbooks in the resources vault or book a call on Topmate.

GROWTH & ACQUISITION NOTE Somya's Strategic Takeaway

Content and paid ads are distribution engines for your core value proposition. Don't create content just for engagementβ€”engineer every hook to qualify high-intent buyers, demonstrate immediate proof, and lead into a frictionless capture mechanism. Track cost-per-qualified-lead (CPQL) over vanity impressions.

⚑ SCALING AI & GROWTH SYSTEMS?

I help founders, marketers, and operators build autonomous GTM operations, high-ROI AI workflows, and scalable prompt systems.

Book a Growth Consultation ->
Hey, I'm Mini Somya. Click me to chat.