Runs inside Google Sheets · No external hosting required
Google Sheets 
Apps Script 
Chart.js 
JavaScript 
Google Drive Runs inside Google Sheets · No external hosting required
Google Sheets Apps Script Chart.js JavaScript Google Drive Recovery Score, HRV (RMSSD), Resting Heart Rate, Sleep Efficiency, and Strain — each with a trend badge comparing against the prior period.
One dashboard for all patients. A dropdown switches between them, generating separate report sets per person with their own Drive folder structure.
Weekly (Mon–Sun), Bi-Weekly, and Monthly views generated automatically from raw daily data. Period detection logic handles the splitting.
Completed periods export automatically as PNG to Google Drive. Files are organized by patient and period, with version history on re-export.
Opens as a modeless dialog inside the sheet your automation already populates. No external app, no separate login — it lives where the data lives.
A time-based Apps Script trigger runs daily, detects complete periods, and queues exports. Zero manual steps once the automation is set up.
An automation pipeline pulls Whoop wearable data daily and writes it to a Google Sheet — one row per patient per day, structured for period aggregation.
Apps Script opens a Chart.js modeless dialog inside Google Sheets. Period detection, trend badges, and metric cards render from the live sheet data.
Completed periods auto-save as PNG to a Google Drive folder organized by patient and period. Downstream automations pick up the files and deliver them.
Built for a practicing physician who tracks patient recovery using Whoop wearables.
Weekly, biweekly, and monthly reports delivered automatically — no manual export.
Available for health analytics, Google Sheets automation, and data pipeline projects.
Hire on Upwork