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

Gustavo, I can't help much more as I don't have a lot else in my account. The trick is to look for the data source name and ID, and to check if you need any additional OAuth scopes.

Hello Robert,

Thank you very much for all the help you provided.

I'm really dumb and I can't implement more data to get.

I took a look at the API Explorer link, but I didn't understand anything.

Is there any way to get all the data and put it in the columns, something more generic?

Thank you again

Ahh, that's where:) I saw there were three values, but could not find where to change it in the script. Thanks again!

Hi Ondra, See https://developers.google.com/fit/datatypes/aggregate - it looks like weight has average, max and min. Try changing value[0] to value[2] when fetching the weight. The script is pulling data daily, if there isn't more than one measurement per day I'd imagine that all three would be the same.

Hi Robert,

this is super useful, thank you!

Could you please help me just replace the the average weight with the minimum value for weight?I cannot seem to find that anywhere..

Thanks,

Ondra

Change the 1's in getMetricsForDays(1, 1, 'Metrics'); to 0's - that should pull today rather than yesterday. If this works change the script trigger to run more frequently.

Thank you for your super quick response.

That works perfectly.

However is there any way to have it update more often rather than just once a day? Ideally once every 10 minutes?

Many thanks, Sarah

Hi Sarah, should be pretty easy. Instead of append row make a call like:

SpreadsheetApp.getActiveSheet().getRange('A1').setValue(steps);

Where A1 is the target cell. This will update rather than append. Sounds like a fun project. Good luck!

This is great thank you.

I'm currently building a project (a remote control that only let's you watch YouTube if you've done enough daily steps :-) ) ... that needs the CURRENT DAILY STEP TOTAL.

Is there anyway for it to pull the steps say every 10 minutes (updating a cell rather than adding new lines)? I'm new to this, so have got it working, but don't know how to amend.

I'll make sure I share the finished project with you and link back here!

Many thanks. Sarah

James, the current script will store one set of credentials at a time. It's probably possible to create a multi-user version, or a multi-sheet implementation of what you're trying to do. It's not something I have time to do with this script though.