How are you syncing your Fitbit/Google Health data to Google Sheets? Looking for advice
Hey everyone,
I'm trying to build a personal health-tracking dashboard in Google Sheets that automatically pulls in my Fitbit data (steps, sleep, heart rate, weight) using Google Apps Script.
I've been digging into the Google Health API (since the old Fitbit Web API is getting shut down in September and Google Fit API is already dead), and I got the OAuth flow working with Apps Script's OAuth2 library. It works, but I've run into an annoying limitation: while my Cloud project is in "Testing" mode, the refresh token only lasts 7 days, so I have to manually re-authorize every week. Going to "Production" apparently requires a security review just for a personal single-user script, which feels like overkill.
So I wanted to ask people who've actually done this:
- Has anyone found a way around the 7-day token expiry for personal/testing projects?
- Are you pulling data through the Google Health API, or did you find another route (Google Takeout exports, a different API, a third-party tool)?
- Any gotchas with specific data types (sleep stages, heart rate, weight) I should know about before I build my sheet around them?
- If you built something similar, did you go Apps Script, or did you end up using something else (Python + a scheduled job, Zapier/Make, etc.)?
Would really appreciate hearing how others have set this up, especially anyone who's been through the recent Fitbit → Google Health API migration. Thanks in advance!