• A Notion database for blood sugar readings
• A Val Town script that pulls the last 7 days of entries
• Weekly stats (avg/min/max, completion rate, streak, badges)
• A friendly email report sent on a schedule

• We only query Notion for a small time window (fast even as Notion grows)
• We compute the rollup once per week and send it as a summary
• We can reuse the same pattern for other life areas (exercise, meals, goals)

We’ll store weekly rollups (badges, streaks, XP) in Val Town’s SQLite so we can:

• build monthly and yearly summaries without re-reading Notion
• compare across categories (e.g., blood sugar vs exercise)
• keep a long-term history even if we rename Notion pages

• weekly_rollups: one row per category per week
• badge_events: a history of badges earned

Each rollup stores:

• category (e.g., blood_sugar)
• period start/end (YYYY-MM-DD)
• streak, completion rate, XP
• badges as JSON
• summary stats as JSON

For each new Notion database:

1. Add a small “collector” val that maps entries into a shared event format.
2. Reuse the rollup logic and write weekly results to SQLite.
3. Generate emails or dashboards from the stored rollups.

This keeps the system simple while still scaling to many life areas.