← Back to all free guides

5 Interactive
Dashboards Hiding
In Your Inbox

Connect Claude to Gmail and build 5 visual, interactive dashboards as Claude artifacts. Maps with pins, charts, color-coded leaderboards and copy-paste action buttons, each in one file you can save and open in your browser.

Years of flight confirmations, subscription receipts, delivery orders, return labels and price-change emails are sitting in your Gmail. Almost nobody uses any of it as data.

Once Claude is connected to Gmail, it can search your inbox like a database, do the math and build you an interactive artifact with real charts and real buttons.

Set It Up Once
  1. Connect Gmail. In a chat, click +, hover Connectors and pick Manage connectors. Click +, choose Gmail, click Connect and sign in with the Google account that has your inbox. The Gmail connector works on every plan, including Free. On Team or Enterprise, an owner has to turn it on first.
  2. Keep the approvals on. The Gmail connector can also send and reply, but by default Claude asks before doing either. Every prompt below tells Claude to read only, so if you ever see a send request, decline it.
  3. Save the prompts in a Project so you can rerun them every few months. These are big jobs that search hundreds of emails, so they use a lot of your limit. Run one per session.

One catch: Claude can read email text but not the contents of attachments, so receipts that only arrive as PDFs won’t be counted. (What the Gmail connector can do · Connector setup)

The 5 Dashboards

01

Your Travel Map

A world map with a pin for every trip in the last 5 years. Hover for the city and dates, click for the full trip. Underneath you get total trips, cities, countries and spend, a searchable trip list and a year-by-year chart of your travel rhythm.

Travel Atlas
You have access to my Gmail. Build me an interactive travel map dashboard called "Your Travel Atlas" as a Claude artifact. STEP 1. FIND THE DATA Search my Gmail for flight confirmations, hotel bookings, Airbnb or vacation rental reservations and rental car receipts from the last 5 years. For each booking pull: - Destination city and country (plus approximate latitude and longitude) - Arrival and departure dates - Type (flight, hotel, rental, car) - Vendor (airline, hotel brand, etc.) - Cost, only if it's clearly stated - Confidence: high, medium or low Group bookings into TRIPS. A trip is a set of bookings with overlapping or back-to-back dates in the same city or region. Each trip gets one date range, a main destination and a total of the costs you found. STEP 2. BUILD THE DASHBOARD Dark mode: background #0e0e10, text #f5f5f5, accent red #d02e2e. Clean sans-serif, lots of space. Top to bottom: 1. Header: "Your Travel Atlas" and the date range covered. 2. World map, full width, about 60% of the screen height. One pin per trip, colored by year (most recent year in the red accent). Hover shows city, dates and vendor. Click opens a side panel with the full trip details. 3. Four big stats: total trips, unique cities, unique countries, total spent. 4. A trip table with date, city, country, vendor and cost. Add a live search box and sortable columns. Highlight the 3 most expensive trips. 5. A bar chart of trips per year, using the same colors as the pins. Mark low-confidence trips with a small icon. GROUND RULES (apply to every step): - Read only. Do not send, draft, reply to, forward, label, archive or delete anything in my Gmail. - Use only what's in the email text. You can't open attachments, so if a receipt lives only in a PDF, skip it and count how many you skipped. - Never guess a number. If an amount, date or place isn't clearly in the email, leave it blank and label the row low confidence. - Search in batches (by vendor, by year) so you don't miss older emails, and tell me roughly how many emails you checked. - Build it as ONE self-contained HTML artifact. Only use outside libraries if they load in your artifact preview. If one doesn't, draw the chart or map with inline SVG instead so it still works. - Mobile-friendly: stack sections on phones. - If there's not enough data for a section, show a friendly empty state instead of fake data. - After the artifact, give me 3 bullet points: what you found, what you skipped and anything you weren't sure about.

02

The Subscription Kill List

Your monthly and annual subscription totals, every subscription ranked by cost and a category breakdown. Then the part everyone screenshots, the Kill List, with a ready-to-send cancellation email behind every card.

Subscription Kill List
You have access to my Gmail. Build me a subscription audit dashboard called "The Subscription Kill List" as a Claude artifact. STEP 1. FIND THE DATA Search my Gmail for every recurring charge, renewal notice, auto-billing receipt and membership fee from the last 24 months. Combine them into one row per subscription with: - Service name - Category (entertainment, productivity, fitness, finance, work tools, news, cloud storage, other) - Billing frequency (monthly, quarterly, annual) - Most recent charge amount and date - Annual cost (latest amount times charges per year) - Status: ACTIVE if charged in the last 60 days, DORMANT if 60 to 180 days, LIKELY CANCELLED if over 180 days - UNCERTAIN if you're less than 80% sure it's a real subscription. Show these in the table with a warning icon but leave them out of every total and chart. STEP 2. BUILD THE DASHBOARD Light mode: background #fafaf7, black text, one accent red #d02e2e. Serif headlines, clean sans body, rounded cards. Top to bottom: 1. Three big numbers: monthly total, annual total and number of active subscriptions. 2. A horizontal bar chart of every active subscription by annual cost, highest first, with the dollar amount on each bar. 3. A donut chart of annual spend by category, with the total in the center. 4. THE KILL LIST, the most eye-catching section. A card for every subscription I should review: dormant ones, plus anything active I might not be using (flag why). Each card shows the service, last charge date, annual cost and a Cancel button. The button opens a pop-up with a ready-to-copy cancellation email for that service and a Copy button. Show the total I'd save at the top of the section. 5. A full searchable table of everything, filterable by status. GROUND RULES (apply to every step): - Read only. Do not send, draft, reply to, forward, label, archive or delete anything in my Gmail. - Use only what's in the email text. You can't open attachments, so if a receipt lives only in a PDF, skip it and count how many you skipped. - Never guess a number. If an amount, date or place isn't clearly in the email, leave it blank and label the row low confidence. - Search in batches (by vendor, by year) so you don't miss older emails, and tell me roughly how many emails you checked. - Build it as ONE self-contained HTML artifact. Only use outside libraries if they load in your artifact preview. If one doesn't, draw the chart or map with inline SVG instead so it still works. - Mobile-friendly: stack sections on phones. - If there's not enough data for a section, show a friendly empty state instead of fake data. - After the artifact, give me 3 bullet points: what you found, what you skipped and anything you weren't sure about.

03

Your Food Year-In-Review

One giant number for your last 12 months of food spend, then delivery vs groceries vs restaurants vs coffee, your top 10 places, your biggest single order and a daily average that hits hard.

Food Year-In-Review
You have access to my Gmail. Build me a food spending year-in-review as a Claude artifact. STEP 1. FIND THE DATA Search my Gmail for receipts from the last 12 months: - Food delivery (DoorDash, Uber Eats, Grubhub and similar) - Grocery orders and delivery (Instacart, Amazon Fresh, Whole Foods, Walmart and similar) - Restaurant receipts and reservation charges (OpenTable, Resy, Toast and direct restaurant emails) - Coffee shop receipts and app orders Count actual orders only, not memberships like DashPass. For each order pull the date, vendor, category (delivery, grocery, restaurant, coffee), total and city if shown. STEP 2. BUILD THE DASHBOARD Editorial magazine feel, like a year-in-review recap from your favorite app. Cream background #fffae7, text #2f2d2d, accent red #d02e2e. Big serif numbers, clean sans body, lots of white space. Top to bottom: 1. One giant number: total food spend in the last 12 months. Under it: "across N orders from M places" and the date range. 2. A donut chart of delivery vs grocery vs restaurant vs coffee, biggest slice in red, each slice labeled with dollars and percent. 3. A monthly trend line. Label the 3 most expensive months. Only suggest a reason (like "holidays") if the data clearly shows it. 4. Top 10 places by total spend: name, category, total spent, number of orders and a small bar showing their share. 5. A callout card for the single biggest order of the year. 6. A closing line: "That's $X a day. $Y a week. $Z a month." Make it feel designed and a little indulgent, not like an expense report. GROUND RULES (apply to every step): - Read only. Do not send, draft, reply to, forward, label, archive or delete anything in my Gmail. - Use only what's in the email text. You can't open attachments, so if a receipt lives only in a PDF, skip it and count how many you skipped. - Never guess a number. If an amount, date or place isn't clearly in the email, leave it blank and label the row low confidence. - Search in batches (by vendor, by year) so you don't miss older emails, and tell me roughly how many emails you checked. - Build it as ONE self-contained HTML artifact. Only use outside libraries if they load in your artifact preview. If one doesn't, draw the chart or map with inline SVG instead so it still works. - Mobile-friendly: stack sections on phones. - If there's not enough data for a section, show a friendly empty state instead of fake data. - After the artifact, give me 3 bullet points: what you found, what you skipped and anything you weren't sure about.

04

Money You’re Owed

Matches every return you sent back to a refund. Refunded items sit quietly on the left. Missing refunds sit on the right with a button that writes the follow-up email for you.

Money You’re Owed
You have access to my Gmail. Build me a "Money You're Owed" dashboard as a Claude artifact that finds returns I never got refunded for. STEP 1. FIND AND MATCH THE DATA Search the last 24 months of my Gmail for: - Return labels, return confirmations and "we received your return" emails from retailers and carriers - Refund confirmations and store credits from those same companies Match each return to a refund from the same company within 30 days for a similar amount (within $5, or 10% if the amount is unclear). Label each return: - REFUNDED: matching refund found - PENDING: no refund yet, return under 14 days old - MISSING: no refund found and it's been more than 14 days For every MISSING return capture the company, item (if shown), return date, expected refund, days since return and the order number if it's in the email. STEP 2. BUILD THE DASHBOARD Light background #fafaf7, red accent #d02e2e, green #2f7d4a for refunded items. Top to bottom: 1. One huge red number: total dollars across MISSING and PENDING returns, with "across N returns, oldest from X days ago." 2. Two columns. Left, calm and green: refunded returns with company, dates and amount. Right, red and urgent: missing or pending returns as action cards with a days-waiting badge (red if over 30 days) and a "Send Refund Inquiry" button. 3. The button opens a pop-up with a ready-to-copy email. Subject: "Refund status for my return on [date], order [number]". Body: polite but firm, with the return details, the amount and a request for a reply within 7 days. Include a Copy button. 4. A stat strip: average days waiting, oldest missing refund, biggest missing amount. 5. A button that downloads the missing returns as a CSV. Some refunds go back to a card without an email, so add a one-line note at the top telling me to check my bank statement before I send anything. GROUND RULES (apply to every step): - Read only. Do not send, draft, reply to, forward, label, archive or delete anything in my Gmail. - Use only what's in the email text. You can't open attachments, so if a receipt lives only in a PDF, skip it and count how many you skipped. - Never guess a number. If an amount, date or place isn't clearly in the email, leave it blank and label the row low confidence. - Search in batches (by vendor, by year) so you don't miss older emails, and tell me roughly how many emails you checked. - Build it as ONE self-contained HTML artifact. Only use outside libraries if they load in your artifact preview. If one doesn't, draw the chart or map with inline SVG instead so it still works. - Mobile-friendly: stack sections on phones. - If there's not enough data for a section, show a friendly empty state instead of fake data. - After the artifact, give me 3 bullet points: what you found, what you skipped and anything you weren't sure about.

05

The Price-Increase Tracker

Shows how much more your subscriptions cost than when you started, the biggest climbers, the price hikes that came with no warning email and a negotiation script for every one.

Price-Increase Tracker
You have access to my Gmail. Build me a subscription price-increase tracker as a Claude artifact. STEP 1. FIND THE DATA Find every subscription I'm still paying for, then search my Gmail for every billing receipt from each one, going back as far as my inbox goes. For each subscription build a price history: - First price I paid and when - Every price change and the dates each price applied - Current price and date - Total percent increase from first to current - Whether each increase had a heads-up email (like "your price is changing") in the 30 days before it. If not, flag it as a QUIET INCREASE. - Estimated next renewal date STEP 2. BUILD THE DASHBOARD Background #fafaf7, black text, red accent #d02e2e. Clean sans-serif with a bold condensed font for the headline. Top to bottom: 1. One bold line: "Your subscriptions cost X% more than when you started." Under it: how much extra per month that is today, and roughly how much extra I've paid in total because of increases. 2. Biggest climbers: the top 5 by percent increase, each with first price, current price, percent (in red) and dollar increase. 3. The main chart: every subscription's price history on one line chart, each starting at 100, so I can compare how steeply each one climbed. Y-axis: "% of original price." 4. Quiet increases: subscriptions that raised prices with no heads-up email I could find. 5. Renewing soon: everything that renews in the next 30 days, with the last 3 prices charged. 6. A "Negotiate" button on every subscription that opens a pop-up script: "Hi, I've been a customer since [date]. My price has gone from $X to $Y. Before I decide whether to keep my plan, is there a lower-priced option or a loyalty discount you can offer?" with a Copy button. GROUND RULES (apply to every step): - Read only. Do not send, draft, reply to, forward, label, archive or delete anything in my Gmail. - Use only what's in the email text. You can't open attachments, so if a receipt lives only in a PDF, skip it and count how many you skipped. - Never guess a number. If an amount, date or place isn't clearly in the email, leave it blank and label the row low confidence. - Search in batches (by vendor, by year) so you don't miss older emails, and tell me roughly how many emails you checked. - Build it as ONE self-contained HTML artifact. Only use outside libraries if they load in your artifact preview. If one doesn't, draw the chart or map with inline SVG instead so it still works. - Mobile-friendly: stack sections on phones. - If there's not enough data for a section, show a friendly empty state instead of fake data. - After the artifact, give me 3 bullet points: what you found, what you skipped and anything you weren't sure about.
Make Them Better
  1. Check the numbers. Spot-check three rows against the real emails before you act on anything, especially refunds and cancellations.
  2. Ask for fixes in plain English. "Move the Kill List to the top," "exclude work travel" or "add 2019" all work as follow-ups in the same chat.
  3. Save the file. Download the artifact as an HTML file and open it in any browser.

Pick One

Don’t build all 5 in one afternoon. Start with the question you’ve actually been asking yourself, like where your money goes or whether that refund ever came, and build that one first. Comment DASHBOARD on the original post and I’ll send you all 5 prompts in one DM.

Big Gmail searches eat into your Claude limit fast. Here’s how I stay under my weekly limit.