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

Updated on Friday, April 28, 2023

Comments Page 7

Return to post.



Super convenient steps!!!


Robert Ellison

Hi Jordan. I haven't seen that error but searching for it I see some suggestion that it could be due to V8 runtime. In the apps script see if you can disable that.


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!

Robert Ellison

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.



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.

Kjetil Nygård

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.


Add Comment

All comments are moderated. Your email address is used to display a Gravatar and optionally for notification of new comments and to sign up for the newsletter.

I Thought He Came With You is Robert Ellison's blog.



Average Server Response Time in Azure Metrics