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

Updated on Friday, April 28, 2023

Comments Page 17

Return to post.



Well done! I could follow this easily and get my spreadsheet up and running in 10 minutes. Kudo's to you!

Robert Ellison

Darren, sorry for the slow response. Yes, click on Credentials and then look under OAuth 2.0 client IDs. If you have client listed click the name to go to a page that has the client ID and secret. If not, click Create credentials and pick the OAuth client ID option. Let me know if you're still having any problems.

Darren Wall

This is exactly what I was looking for but I appear to be stumbling with either a newbie error or a change to the Google API Console ?

Trying to follow the instructions step by step and nothing seems to match after I've added the Fitness API?

The next step says to "go to Keys" has this been renamed to "Credentials"?

From there on I'm not able to find things like the application type, redirect URL and most importantly the Client ID and Client Secret.

Any help would be greatly appreciated.




Thank you for the great job! Worked fine. Fantastic tips from the comments too.


Thank you! I got it working and it was neat. I got a little lost in the "Open the Google API Console" paragraph but worked it out and was able to retrieve my data and learn more about Google APIs in the process. I feel powerful! Thanks.


Thanks for the quick reply Robert, really appreciate it. Problem was magically solved over night - I am assuming this may have something to do with oauth verification that can take a bit of time.

Again, thanks for this amazing article and your help!

Robert Ellison

Hi Matthias, that looks like a problem with the Google Fit API configuration. Check that you have copied the ClientID and ClientSecret over to the script correctly. Also go to the Google API Console and check that the Google Fit API is enabled.


This is amazing - Thanks Robert!

I have done all the steps you have outlined but get a 403 error message, containing "access not configured". The error messages reads:

"Request failed for {URL from Line 56 - which is th Fetch App URL} returned code 403. Truncated server response: { "error": { "errors": [ { "domain": "usageLimits", "reason": "accessNotConfigured", "message": "Access Not Configured. Fitness h... (use muteHttpExceptions option to examine full response).

The authentication came back with a success so not sure why is causing the missing access. Any idea how to solve this?




Hi Robert - thanks for the reply. The app never registered with Fit, so I couldn't deauthorize there. Did try the reset settings. I've moved on to doing it in Python (easier data munging for me), but your post was quite helpful in learning the basics. Thanks!

Robert Ellison

John, sorry for the slow reply. Have you tried disconnecting from Google Fit and then authorizing again? See the instructions near the end of the post. I'd also try running the Reset Settings menu option in the script as well before attempting to connect again.

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