Universal Data Apple Health into CSV through shortcut

[Deborah_Tsekou]

Goal: get the data from apple health (sleep, mindfulness and maybe some other later) to put it in a CSV through shortcut. It will be hosted on the cloud at google drive. Then that spreadsheet on google drive will be updated throughout the time with the shortcut and I will have graphics that could analyse my sleep. I will precise which datapoints I will need later & how things should work. Can someone help me?

 

[bob_zz123]

This sounds like a bit of a project and you'll probably need to dedicate some time to experimenting. You can get Health data samples from Shortcuts; spend some time experimenting with the inputs to see if it'll give you the data samples you want. You won't be able to update a Google Spreadsheet through Shortcuts without just issuing raw HTTP requests to the Google API endpoints (and dealing with oAuth). I'd forget about that. You can update a Numbers spreadsheet through Shortcuts though. I suppose this file could be stored on Google Drive if you have the Google Drive app installed as it should be visible through the File Provider extension. Or you could e-mail your sample to Gmail if you could set up some Gmail automation / rule to pick it out and process it (I am not Gmail user so I don't know).

Alternatively you could build some kind of web API hosted on a cloud server, serialise your Health data to JSON and upload it and the server could then handle updating Google Sheets.