Daily health metrics to a Google Sheet log

Every 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.