Build a Personal Health Report That Runs Itself
Here's a side project that solves a real problem: the average health-conscious person has data streaming from Apple Health, Fitbit, a blood pressure monitor, maybe a CGM—and none of it talks to each other. They feel guilty about the data they're collecting but never synthesising.
The opportunity isn't building another dashboard. It's building a weekly AI-generated health report that arrives in your inbox every Sunday morning with zero ongoing effort. Here's exactly how to build it.
The Stack (Total Cost: £0-15/month)
Component | Tool | Cost |
|---|---|---|
Data extraction | Apple Health Export + Shortcuts | Free |
Data aggregation | Google Sheets or Airtable | Free |
AI analysis | Claude API or GPT-4o-mini | ~£3/month |
Delivery | n8n (self-hosted) or Make.com | Free-£12/month |
Visual output | Napkin.ai (see Tool Tip) | Free |
Step 1: Automate the Data Pull
For Apple Health: Create an iOS Shortcut that runs weekly. Use the "Get Health Samples" action to pull: steps (daily average), resting heart rate, HRV, sleep duration, blood oxygen. Export to a Google Sheet via the "Add Row to Google Sheet" action.
For Fitbit/Garmin/Oura: Use their official APIs or Sync.Health (free tier) to push data to Google Sheets automatically.
For BP monitors and glucose: Most smart monitors (Withings, Omron, Dexcom) have IFTTT or Zapier integrations. Set a weekly trigger to append readings to your master sheet.
Step 2: Structure Your Data Sheet
Create one Google Sheet with tabs for each data source. Use a "Master" tab that pulls weekly averages using simple formulas:
=AVERAGEIFS(Steps!B:B, Steps!A:A, ">="&(TODAY()-7))
Your Master tab becomes a single-row weekly summary: avg steps, avg sleep, avg HRV, BP readings, glucose range.
Step 3: Generate the AI Report
Use n8n or Make.com to trigger weekly. The workflow:
Pull data from Google Sheets (HTTP Request node)
Send to Claude/GPT with this prompt:
You are a health analyst. Here is my weekly health data:
{{master_row_data}}
Generate a 200-word health report including:
1. One key insight (what improved or declined this week)
2. One correlation you notice (e.g., "sleep improved on days with 8k+ steps")
3. One specific recommendation for next week
4. A "Vitality Score" from 1-100 based on all metrics
Format for email. Use a friendly, encouraging tone.
Send via email (Gmail or SendGrid node)
Step 4: Make It Shareable
Once monthly, paste your AI report into Napkin.ai. It auto-generates a visual health summary—perfect for sharing on LinkedIn or with your doctor. Takes 30 seconds.
The Viral Angle
If you want to turn this into a product:
Offer a "Connect your data" flow using Sync.Health or Terra API (handles 200+ wearables)
Charge £8/month for AI-generated insights and trend analysis
The weekly report is the hook; historical trends and recommendations are the upsell
Why This Works
The wearable market is growing 25% annually. 46% of users say they'd share data with healthcare providers—but the infrastructure doesn't exist. You're not competing with Apple Health; you're competing with the spreadsheet nobody has time to build.
From the Daily Briefing: Will the 10x cost collapse change the game?