Export Google Fit Daily Steps, Weight and Distance to a Google Sheet

I could have messed up somewhere, but I am getting an error saying "Property store is required".

This is brilliant - another thank you from me your hard work!

I'm also wanting to get resting heart rate so I'll keep checking back to see if one of you clever people work it out!

Francesco - I haven't tried to grab calories so I don't have any experience with how this data source behaves. Does other data look right? Also see this article.

Hi!

i have 2 problems. I followed the procedure as described, copied the code and activated the hourly routine but I get an unexpected result:

I get the result of two days ago and not "yesterday".

If I proceed manually instead I get the desired result.

In both cases I get "calories" only a part of them after 24 hours. and all those actually consumed after 48 hours....

could you help me?

"Then choose Web Application as the application type. You need to set the name and the authorized redirect URL."

Where do I do that?

Massive thanks for this tutorial, I've been trying to get it to work for 3 days and finally managed it by using Google Chrome and going through each step very slowly.

I've outputted the information through Grafana as well as Strava info, my email was sent along with this comment if you are ever interested to see an output.

Thanks again for the work you put in.

Did you manage to get the sleep data?

Hello Robert,

Sorry for all my messages.

I think the problem was with Google Fit.

Indeed, I retrieved the data from my FitBit bracelet via the FitToFit application to Google Fit.

Having some synchronization problems with this application, I switched this morning to another application allowing me to synchronize my FitBit with Google Fit.

So I deleted all the data from my Google account and restarted a synchronization with this new application.

Since the steps (the weight and the distance are not in my Google Fit) are well recovered.

I will now see to retrieve the sleep data.

Thank you very much for your script and your assistance.

Have a good day.

Benoît

Thanks for your response Robert.

Unfortunately I tested (manually adding weight data in my Google Fit App so there is something to retrieve) but that doesn't change my problem, I still end up with the date without any other data.

I will continue to seek a solution.

Thanks for this work.

Benoît

Benoît - my best suggestion would be to go back to the original code including weight and see if you still have a problem. Could be that something broke when you removed that section.