Weekly AI health coach email

Every Sunday at 6pm in my local timezone, gather the past seven days of my Google Health data and compare it against the seven days before that, then send me a personal weekly coaching email.

For the current week (the last 7 days ending now) and the prior week (the 7 days before that), pull the following metrics from Google Health. Use the Roll-Up Data Points operation to get weekly aggregates where it makes sense, and List Data Points where you need the raw sessions or daily values:

1. Sleep — total sleep duration per night, then average per night for each week. Use the sleep data type.

2. Steps — total steps for each week and the daily average. Use the steps data type.

3. Exercise sessions — count of workouts, total active minutes, and a short list of session types (run, ride, strength, etc.) for each week. Use the exercise and active-minutes data types.

4. Resting heart rate — weekly average using the daily-resting-heart-rate data type.

5. Heart rate variability — weekly average using the daily-heart-rate-variability data type.

Compute week-over-week deltas for each metric (absolute change and percent change). If a metric has no data for one of the weeks, note it as missing rather than reporting a false delta.

Then write a weekly health coach report in the voice of an encouraging personal coach, not a data analyst. Structure it roughly like this:

- A short warm opener (one or two sentences) framing how the week went overall.

- What improved: 2-3 specific wins with concrete numbers and week-over-week deltas (e.g. "Average sleep climbed from 6h 42m to 7h 18m, +36 minutes").

- What slipped: 1-2 areas that regressed, again with concrete numbers, framed constructively, not scolding.

- Focus for next week: exactly one or two specific, actionable habits (e.g. "Aim for lights-out by 10:30pm on weeknights" or "Add a third strength session, keep it short"). Avoid vague advice like "sleep more" or "move more".

- A brief encouraging sign-off.

Tone: warm, direct, coach-like. Celebrate real wins without being saccharine. Do not use em dashes. Do not moralize. Do not invent numbers — if data is thin or missing, say so and lean on what is available.

Format the report as clean HTML for email: a bold subject line like "Your week in review — [date range]", a short intro paragraph, then bolded section headers (Wins, Slips, Focus for next week) with tight paragraphs or short bullet lists underneath. Keep it scannable in under 60 seconds.

Send the report using the Gmail Send a Message operation to my own email address, with the subject line described above and the HTML body as the message content.