Importing data from Google Fit / Fitbit INTO Apple Health

I found some previous posts looking for a way to migrate Google Fit data into Apple Health. While this is not an ongoing sync, I just developed a way to get historical data from Fitbit into Apple Health, specifically in my case in order to get menstrual cycle data into Apple Health as a step towards getting it into another cycle tracking app, Natural Cycles.

It involves exporting the fitbit data using google takeout, processing it using a google spreadsheet (I've made that part as simple as possible) and then importing it into Apple Health using a shortcut I developed to process the data.

This is the google sheet for processing the data, and all instructions for how to use it including how to export the data from google, and import it are included on the first tab.

Here is the direct link to the iOS shortcut for importing the data into Apple Health. You need to process it first though using the spreadsheet above: Import Menstrual Data to Health App

In my case, this is just menstrual cycle (period) data, not temperature or anything else, but this approach could be used to import other data types as well, by creating a custom spreadsheet and editing the shortcut as needed.

Any questions, let me know. I hope this helps someone. It took a few hours work to develop this for my partner, so I'm hoping others can benefit as well.