Daily health metrics to a Google Sheet log
Log yesterday's steps, distance, calories, resting heart rate, sleep, and weight to a Google Sheet every morning so your history builds up over time.
Google Health
Google SheetsPersonal ProductivityData SyncDaily DigestsEvery morning at 7am, pull yesterday's health metrics from Google Health and append one row per day to a Google Sheets spreadsheet so it becomes a long-term personal health log I can chart or analyze however I like.
Fetch six metrics for the previous calendar day: steps, distance, total calories, resting heart rate, sleep duration, and weight.
Use the Daily Roll-Up Data Points operation for the aggregatable activity metrics (steps, distance, total-calories) over a single civil-day window covering yesterday. Use the List Data Points operation for daily-resting-heart-rate, sleep, and weight, filtered to yesterday's window, taking the latest reading when a metric has multiple entries and summing sleep session durations for the total.
Skip any metric that has no data for the day rather than failing the workflow. If I did not wear my tracker or did not weigh in, that column should be left blank in the appended row instead of aborting the run.
Once the metrics are gathered, call the Append Values operation on Google Sheets to append a single row to the target spreadsheet. Column order is date, steps, distance, total calories, resting heart rate, sleep duration, weight, matching the header row that already exists on the sheet.
Take the spreadsheet ID and sheet tab name as configurable inputs so I can point the workflow at whichever health log I set up. Use USER_ENTERED so numbers and the date get parsed the way I would type them into the UI.
Additional information
What does this prompt do?
- Every morning at 7am, pulls yesterday's steps, distance, calories, resting heart rate, sleep duration, and weight from your Google Health data.
- Appends one new row per day to a Google Sheet you choose, with one column per metric.
- Skips any metric that has no reading for the day, leaving that column blank instead of failing the whole run.
- Builds a long-term personal health log you can chart, filter, or analyze however you like.
What do I need to use this?
- A Google account with Fitbit, Pixel Watch, or other trackers syncing into Google Health
- A Google Sheets spreadsheet with a header row (date, plus one column for each metric you want to track)
How can I customize it?
- Change the run time or time zone so the daily row lines up with when your tracker finishes syncing.
- Add or remove metrics: active minutes, floors, VO2 max, and blood oxygen all live in the same Google Health data.
- Point the workflow at a different spreadsheet or sheet tab, or split metrics across multiple tabs (activity, sleep, body).
Frequently asked questions
Which devices does this work with?
What happens if I didn't wear my tracker one day?
Do I need to build the spreadsheet before turning this on?
Can I add other metrics like active minutes or blood oxygen?
How far back does the history go?
Related templates
Turn your wearable data into a spreadsheet you actually own.
Build a permanent, portable record of your health metrics instead of relying on the app's built-in charts.