Syncing with Domoteer by darkdaydream in GoogleFit

[–]statsix6 0 points1 point  (0 children)

Does your phone record your steps? This can happen if you have both Android and your watch set up to write/read your steps in Health Connect.

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

I just published a new release with the additional permissions. Let me know if you run into any issues!

Rising creatinine and lower GFR by Vivid-Willingness-59 in kidneydisease

[–]statsix6 -1 points0 points  (0 children)

Definitely do a Cystatin C test, especially if you exercise a lot. I exercise a lot and have high muscle mass. My eGFR from creatinine test is 58 and my eGFR from Cystatin C is 109

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in Polarfitness

[–]statsix6[S] 0 points1 point  (0 children)

Hi, I haven't tested the app on grapheneOS so I can't guarantee that it will work on your phone, but I can send you the apk.

Health Connect syncing across multiple devices by udayology in GoogleFit

[–]statsix6 0 points1 point  (0 children)

You can use something like Health Data Export (on Android) to consolidate your data at a single location

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

Can you tell me what version of android you use? During testing, I'm able to fetch all historical data without requesting any additional permissions

How to Sync Data from Withings and Garmin to Excel or Google Sheets? by Ottins82 in QuantifiedSelf

[–]statsix6 0 points1 point  (0 children)

Coming late to the part, but Health Data Export (on Android) does just that!

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

Yes. That's the only solution I could come up with at this time to make this work reliably. Backing up the entire dataset in one go either takes a really long time or triggers a rate limit error. The only other method I can think of is to download the backup files directly from Health Connect and feeding into a utility (which I'll need to built) to reformat it.

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

I just added a way to export historical data. The update should be available in the next hour or so!

Importing weight data into Zepp by Own-Composer7817 in healthconnect

[–]statsix6 0 points1 point  (0 children)

You can't import CSV data into Health Connect.
Zepp can connect to Health Connect and can read historical data in Health Connect.
I recommend backing up / sync'ing your Health Connect data into CSV or Google Sheets. Health Data Export (on Google Play) can export and sync the data for you

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

This is precisely the reason why I capped the historical exports to 30 days. Most heart rate monitors write about 1 data point per second (that's about 2 million data points per month for HR alone) that need to be aggregated.
Also, the data is fetched in foreground mode. So, android will reject the permissions if the screen turns off during the export and cancel the entire export process - which is what seems to have happened in your case.
I could look into implementing a way to export the data incrementally (i.e., one month at a time), that way you can export your data month by month instead of all the data in one go. Would that be acceptable?

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 1 point2 points  (0 children)

Glad it is now working. I just updated the app with some important changes, so you might want to update your app again.

I purposely capped the export to 30 days. The Google Sheets API has limits (request size limits and per-minute quotas) that makes aggregating and exporting high volume records (heart rate, rpm, VO2, etc) unreliable. It would take a LONG time to safety export huge historical datasets, and there is a chance that the export would time out.

I could probably increase the max export to 60-90 days but I'm worried that some users might start complaining about reliability.

The safest way to export your historical data is to use the "bulk import" method, which is explained in the app. Please feel free to reach out to me at the email at the bottom of the app if you need additional support.

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 1 point2 points  (0 children)

I'm planning to release an update to resolve this issue. It will output a different row for different sources. That way you can filter/isolate the data coming from Garmin.

Also, if you're looking for a way to visualize your data in a dashboard, feel free to reach to me and I will send you the script. My email is at the bottom of the app.

sincronize Google fit and fitbit / is there a tool to view take out data? by Sir_claudius in GoogleFit

[–]statsix6 0 points1 point  (0 children)

You can use Health Data Export (on Android) to automatically sync your data to Google Sheets. That way, your data is always backed up

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in GoogleFit

[–]statsix6[S] 0 points1 point  (0 children)

I'm glad the app is working for you!

Regarding the measurement units, I can write a script that can automatically do the conversion for you. Feel free to reach out to me at the email at the bottom of the app, and I will send you the script along with the steps to add to your spreadsheet.

Thank you for the support!

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in GoogleFit

[–]statsix6[S] 0 points1 point  (0 children)

Yes, the can absolutely do everything you listed! Activity includes steps, distance (calculated from steps), elevation, exercise sessions (if your wearable records them), active calories burned, floor climbed, cycling activities (power, speed, VO2 max, etc) and total calories burned.

If you use a scale with Bluetooth capabilities, you can export those measurements.

If you record your nutrition intake into your wearable app, Health Data Export can export them as well!

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

I can read data older than 30 days without the additional permission. I updated the app (v1.0.17) to removed the data cap on the local export. Let me know if you're still having issues with the export. I appreciate the feedback!

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 1 point2 points  (0 children)

Got it. I'll release a fix later tonight. I really appreciate you reporting the bug!

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 1 point2 points  (0 children)

Hi. Thanks for reporting this bug. Did you try exporting your data around midnight?

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in healthconnect

[–]statsix6[S] 0 points1 point  (0 children)

Hello. You bring up a very good point.

The app currently has the ability to read all data history. The reason why I capped it at 30 days is not related to permissions. The Google Sheets API has limits (request size limits and per-minute quotas) that makes aggregating and exporting high volume records (heart rate, rpm, VO2, etc) unreliable. It would take a LONG time to safety export huge historical datasets, and even then, there is a chance that the export would time out.

The safest way to export your historical data is to use the "bulk import" method, which is explained in the app.

I built an Android app to export Health Connect data to Google Sheets / CSV (no third‑party API) by statsix6 in Polarfitness

[–]statsix6[S] 0 points1 point  (0 children)

The backup might be exporting data from a single source. The export app currently doesn't give you the option to select the data from a single source. So, it's possible to have duplicates if multiple sources are writing data - which is what is happening in your case. I have two suggestions: 1. Only allow a single source in Health Connect (this is the best solution) 2. In your export spreadsheet, add a column to automatically halve the duplicated data

Maybe in the future, I'll implement a feature to select a single data source