Stop opening six tabs every morning. Connect Stripe, QuickBooks, Calendly, Mailchimp, Meta, and Google Sheets to Claude — one prompt delivers your full business dashboard daily.
This guide is reviewed for clarity, service accuracy, and AI-search readability. The next quarterly content review is tracked internally before unsupported metrics or client proof are added.
Every morning you open the same six apps. Stripe to check revenue. QuickBooks for the bank balance. Calendly for today's calls. Mailchimp for email stats. Meta for ad spend. Sheets for everything else.
By the time you've done that circuit, twenty minutes are gone and you still don't have a clear picture of whether the business is moving in the right direction.
This guide shows you how to fix that. Claude sits in the center of your tool stack as a read-only intelligence layer. You feed it data from all six sources, ask one question, and get a single structured report — every morning — in under two minutes.
No new SaaS subscription. No ETL pipeline. No developer required.
How This Works: The Architecture
Claude is not a database. It does not store your business data or sync it in the background. What it does is read data you give it — then reason across all of it at once.
That is the key insight. You are not building a live integration platform. You are building a repeatable morning ritual: gather the numbers, hand them to Claude, get a unified report.
There are three ways to get data into Claude, and you will use all three depending on the tool:
Native Claude Connectors — Claude has built-in connectors for certain apps you authenticate once inside claude.ai. The connection is secure and live. QuickBooks and Google Workspace both have official connectors. This is the most seamless path when it exists.
MCP Servers — Model Context Protocol servers are small local programs that let Claude talk to external APIs. Tools like Composio and CData provide pre-built MCP servers for dozens of business apps. You install them once, authenticate, and Claude can query those tools directly through its tools panel. Calendly and Stripe have well-supported MCP options.
Export-to-Sheets Bridges — For tools without a native connector or MCP server you trust, export a report to Google Sheets on a schedule. Claude then reads the Sheet. Mailchimp and Meta Ads both export directly to Google Sheets with a few clicks. This is low-tech but highly reliable.
The recommended stack for a solo founder:
| Tool | Connection Method |
|---|---|
| QuickBooks | Native Claude Connector |
| Google Sheets | Native Claude Connector |
| Calendly | Composio MCP Server |
| Stripe | Composio MCP or export to Sheets |
| Mailchimp | Export to Google Sheets |
| Meta Ads | Export to Google Sheets |
Authentication Setup
Here is what you need for each tool before you write a single prompt.
| Tool | Auth Type | What You Need |
|---|---|---|
| QuickBooks | OAuth via Intuit | Active QuickBooks subscription (US only) |
| Google Sheets | Google OAuth | Google account with Sheets access |
| Calendly | OAuth2 via Composio | Calendly account, Composio account (free tier works) |
| Stripe | API key via Composio or CSV export | Stripe restricted API key (read-only) or manual export |
| Mailchimp | CSV/Sheets export | Mailchimp login, set up auto-export to a Sheet |
| Meta Ads | CSV/Sheets export | Meta Business Suite login, connect Sheets export |
Connecting Each Tool: Step by Step
1. QuickBooks
QuickBooks has an official connector built into Claude.
- Go to claude.ai and open a new conversation.
- Click Connectors in the left sidebar.
- Find QuickBooks and click Connect.
- Sign in with your Intuit account when prompted.
- Once connected, Claude can pull Balance Sheet data, P&L reports, and accounts receivable in any conversation.
Note: This connector is currently US-only.
2. Google Sheets
Google Workspace also has a native Claude connector.
- In Claude, go to Connectors → find Google Drive / Sheets → Connect.
- Authenticate with your Google account.
- Create a single spreadsheet called
Business KPIswith one tab per tool where you paste or auto-import data. - Claude can now reference any Sheet by name in your prompts.
3. Calendly
Use Composio to connect Calendly via MCP.
- Create a free account at composio.dev.
- In your Composio dashboard, find Calendly and click Connect — it walks you through OAuth2.
- Follow Composio's instructions to install its MCP server locally (
npx @composio/mcp@latest setup). - Add the MCP server to Claude Desktop's config file (
~/Library/Application Support/Claude/claude_desktop_config.json):
json{ "mcpServers": { "composio": { "command": "npx", "args": ["@composio/mcp@latest", "start", "--api-key", "YOUR_COMPOSIO_API_KEY"] } } }
- Restart Claude Desktop. Composio's Calendly tools appear in Claude's tool panel.
4. Stripe
Option A — Composio MCP (recommended for real-time data):
Follow the same Composio MCP setup as Calendly. In your Composio dashboard, connect Stripe using a restricted API key (read-only scope: charges:read, subscriptions:read, customers:read). Generate a restricted key in Stripe under Developers → API Keys.
Option B — Export to Sheets (simpler, slightly delayed):
- In Stripe Dashboard, go to Reports → Revenue.
- Export as CSV and paste into a
Stripetab in your Business KPIs Sheet. - Or use a Stripe → Google Sheets Zap (if you already have Zapier) to auto-refresh daily.
5. Mailchimp
Mailchimp does not have a native Claude connector. Export to Sheets.
- In Mailchimp, go to Reports and open your most recent campaign.
- Click Export as CSV.
- Paste into a
Mailchimptab in your Business KPIs Sheet. - For subscriber count: go to Audience → Overview and note the number manually in the Sheet, or use a Mailchimp → Sheets integration.
For a zero-manual-effort setup, connect Mailchimp to Google Sheets using a third-party sync tool or the Mailchimp API with a simple Apps Script trigger that runs each morning.
6. Meta Ads
Meta Business Suite can export directly to Google Sheets.
- In Meta Ads Manager, go to Reports.
- Click Export → Schedule Export → choose Google Sheets as the destination.
- Set it to run daily at 6:00 AM.
- Paste the Sheet link into your Business KPIs master Sheet as a separate tab called
Meta Ads.
Exact Metrics to Pull Per Tool
| Tool | Metrics | Field Names / Notes |
|---|---|---|
| Stripe | Monthly recurring revenue, new subscriptions this week, failed charges last 7 days | subscription.status = active, charge.status = failed, MRR calculated from active subscription totals |
| Google Sheets | All KPI rows for the current week, any cells flagged red | Row headers: Metric, This Week, Last Week, Target |
| QuickBooks | Cash balance (checking + savings), total accounts receivable, net revenue MTD vs prior month | Balance Sheet → Bank total; A/R total; P&L → Total Income |
| Calendly | Total confirmed bookings this week, bookings added last 24 hours, next 3 upcoming events | scheduled_events count, start_time for upcoming |
| Mailchimp | Most recent campaign open rate, click rate, list size, subscriber growth this week | open_rate, click_rate, list.member_count |
| Meta Ads | Total spend last 7 days, ROAS, top campaign by ROAS, CPM, CTR | spend, purchase_roas, cpm, ctr, campaign_name |
The Master Morning Prompt
Use this prompt at the start of every morning session. If you are using Claude Projects (recommended), paste this into your Project's system prompt so it runs automatically in every conversation.
Replace the bracketed placeholders with your actual Sheet names or connector references.
promptYou are my morning business intelligence layer. Today is [DATE]. I have connected or uploaded data from six sources. Pull the relevant numbers and return a clean dashboard report with the following sections: --- ## 💰 Revenue & Cash (Stripe + QuickBooks) - Stripe MRR (monthly recurring revenue from active subscriptions) - New Stripe subscriptions added this week - Failed charges in the last 7 days (count + total $ at risk) - QuickBooks cash balance (checking + savings combined) - QuickBooks accounts receivable outstanding - Net revenue this month vs last month (% change) ## 📋 Pipeline & KPIs (Google Sheets – Business KPIs tab) - List every KPI row for this week - Flag any metric that is below target ## 📅 Bookings (Calendly) - Total confirmed bookings this week - New bookings added in the last 24 hours - Next 3 upcoming meetings (time + event type) ## 📧 Email (Mailchimp) - Most recent campaign: subject line, open rate, click rate - Current list size - Subscriber growth this week (net new) ## 📣 Ads (Meta) - Total ad spend last 7 days - Overall ROAS - Top-performing campaign by ROAS - Any campaign with ROAS below 1.5x (flag these) --- ## ⚡ Today's Top 3 Priorities Based on the numbers above, give me exactly 3 action bullets — the highest-leverage things I should act on today. Be direct. No fluff. --- Format the output exactly as shown above. Numbers only where requested. Do not summarize what you did — just show the report.
Per-Tool Sub-Prompts
When you want to query just one source — for a quick check or when troubleshooting — use these standalone prompts.
Stripe:
promptLook at my Stripe data. Tell me: 1. Current MRR from active subscriptions 2. How many new subscriptions were created in the last 7 days 3. Any charges with status "failed" in the last 7 days — count, total amount, and which customers Keep it to bullet points. Numbers only.
Google Sheets:
promptRead my Business KPIs Sheet. Return every row from the "This Week" column. Flag in bold any metric that is more than 10% below the Target column. Show me the raw numbers — no interpretation yet.
QuickBooks:
promptPull my current Balance Sheet and P&L from QuickBooks. Report: - Total cash (all bank accounts combined) - Total accounts receivable outstanding - Net revenue this month - Net revenue last month - Month-over-month change as a percentage Three lines max per section. No chart descriptions.
Calendly:
promptCheck my Calendly account. Tell me: 1. How many events are scheduled for this week (Monday through Sunday) 2. How many were booked in the last 24 hours 3. List the next 3 upcoming events: date, time, event type Bullet list format only.
Mailchimp:
promptReview the Mailchimp data in my Business KPIs Sheet (Mailchimp tab). Report: - Most recent campaign name and send date - Open rate and click rate - Current total list size - Net subscriber change this week (gained minus unsubscribed) If open rate is below 20%, flag it.
Meta Ads:
promptReview my Meta Ads data from the Business KPIs Sheet (Meta Ads tab). Report: - Total spend last 7 days - Blended ROAS across all campaigns - Top campaign by ROAS — name, spend, and ROAS - Any campaign with ROAS below 1.5 — list them with their spend Keep it factual. No recommendations yet.
Automating the Morning Run
You have two paths depending on how hands-on you want to be.
Option A: Claude Projects (Recommended — No Code)
Claude Projects lets you save a system prompt that loads every time you open that Project. This is the fastest setup with no command line required.
- In claude.ai, click Projects → New Project.
- Name it
Morning Dashboard. - Paste the Master Morning Prompt into the Project Instructions field.
- Add your Google Sheets connector and QuickBooks connector to the Project.
- Every morning, open the Morning Dashboard project and type:
promptRun the morning dashboard. Today is [DATE].
Claude loads your system prompt automatically and pulls from your connected sources.
To make it fully hands-free: Set a phone reminder at 6:30 AM. When it fires, open Claude, click the project, type one line. The full report is ready in under 60 seconds.
Option B: Shell Script + Cron (Full Automation)
If you have Claude Code or the Claude CLI installed, you can automate the entire run.
Save the master prompt to a file:
bashcat > ~/dashboard-prompt.txt << 'EOF' You are my morning business intelligence layer. Today is $(date +"%B %d, %Y"). [Paste your full master prompt here] EOF
Create the runner script:
bash#!/bin/bash # ~/scripts/morning-dashboard.sh DATE=$(date +"%Y-%m-%d") OUTPUT_DIR="$HOME/dashboard-reports" mkdir -p "$OUTPUT_DIR" PROMPT=$(sed "s/[DATE]/$(date +"%B %d, %Y")/" ~/dashboard-prompt.txt) claude -p "$PROMPT" > "$OUTPUT_DIR/dashboard-$DATE.txt" # Open the report automatically open "$OUTPUT_DIR/dashboard-$DATE.txt"
Make it executable:
bashchmod +x ~/scripts/morning-dashboard.sh
Schedule it with cron to run at 7:00 AM every weekday:
bashcrontab -e
Add this line:
prompt0 7 * * 1-5 /bin/bash $HOME/scripts/morning-dashboard.sh
Sample Dashboard Output
Here is what a finished morning report looks like:
promptMORNING DASHBOARD — July 7, 2026 ## 💰 Revenue & Cash - MRR: $14,820 (from 94 active subscriptions) - New subscriptions this week: 7 - Failed charges last 7 days: 3 charges · $297 at risk - Cash balance: $38,440 (checking: $31,200 · savings: $7,240) - Accounts receivable outstanding: $6,100 - Net revenue MTD: $9,340 vs $8,720 last month (+7.1%) ## 📋 Pipeline & KPIs - Leads generated: 42 (target: 50) ⚠️ BELOW TARGET - Proposals sent: 8 (target: 6) ✅ - Demo calls booked: 5 (target: 4) ✅ - Revenue per lead: $352 (target: $300) ✅ ## 📅 Bookings - Total bookings this week: 11 - New in last 24 hours: 3 - Next 3 meetings: · July 7, 9:00 AM — Discovery Call (Sarah M.) · July 7, 2:00 PM — Strategy Session (Founders Co.) · July 8, 10:00 AM — Onboarding Call (New client) ## 📧 Email - Campaign: "5 AI Tools Founders Use Daily" · sent July 5 - Open rate: 34.2% · Click rate: 6.8% - List size: 2,847 - Subscriber growth this week: +63 net new ## 📣 Ads - Total spend last 7 days: $1,240 - Blended ROAS: 3.1x - Top campaign: "AI Founder Series" · $680 spend · 4.2x ROAS - No campaigns below 1.5x ROAS ✅ ## ⚡ Today's Top 3 Priorities 1. Call the 3 failed-charge customers ($297 at risk) — recovery window is 48 hours 2. Leads are 16% below target — push today's content post before noon 3. Accounts receivable at $6,100 — follow up on outstanding invoices
Common Failure Modes and Fixes
Token limit hit on large exports
Claude has a context window limit. If you paste an entire Stripe CSV with thousands of rows, it will truncate. Fix: Export only the last 30 days, or aggregate the data in Sheets first (use a SUMIF or QUERY formula to pre-calculate totals before Claude reads the Sheet).
QuickBooks connector not pulling recent data The connector refreshes on each conversation. If the numbers look stale, close the conversation and start a new one. If it still shows old data, disconnect and reconnect the QuickBooks integration in claude.ai Connectors.
Meta or Mailchimp Sheets export is empty Scheduled exports from Meta and Mailchimp take up to 24 hours to appear on the first run. Verify the export is configured with the right date range (last 7 days rolling, not a fixed range) and that the Sheets destination has write access.
Calendly MCP not responding
MCP servers run locally and stop if your machine restarts. Re-run npx @composio/mcp@latest start after a reboot, or add it to your login items so it starts automatically.
Claude gives vague answers instead of numbers This usually means it received ambiguous context. Tighten the prompt: specify the exact Sheet tab name, the exact date range, and tell Claude "numbers only, no narrative." The per-tool sub-prompts above are written to prevent this.
Stripe MRR calculation is inconsistent Stripe does not expose MRR as a single field — it is calculated from active subscription amounts. If Claude's number varies, tell it explicitly: "MRR = sum of all active subscription monthly amounts. For annual plans, divide the plan amount by 12." This forces consistent calculation logic.
FAQ
Do I need to give Claude write access to my financial accounts? No. Every connection described here is read-only. The QuickBooks Claude Connector reads reports but cannot post transactions. Composio API keys for Stripe should use restricted read-only scope. Claude never initiates charges, modifies records, or posts to any system. The entire setup is read access only.
What if one of my tools is not in this list? The export-to-Sheets bridge works for almost any tool that has a CSV export or a Zapier/Make connector. Create a new tab in your Business KPIs Sheet named after the tool, paste the export there, and add a section to the master morning prompt referencing that tab. Hypd's team uses this pattern to add new tools to the dashboard in under ten minutes.
How much does this cost to run daily? The Claude Pro plan ($20/month as of mid-2026) covers typical dashboard usage — one morning run per day is well within normal usage limits. Composio's free tier supports the Calendly and Stripe MCP connections. Google Sheets, Mailchimp exports, and Meta Ads exports are free. The total incremental cost above what you already pay for these tools is effectively zero.