Post-Groovy Google Spreadsheet Integration

Looking for suggestions on best approach, after scanning this thread and this offshoot one (Temperature Map in Smartthings?)

I’d like to periodically (~monthly) log energy and power values from a device, but not sure of the easiest approach… (I am using ConstantGraph already, but want to augment what I get from it)

I have an always-on NAS with both a buillt-in proxy server (currently using w/the edge weather driver) and Python… I was thinking I could create a Python script to trigger a call to the ST API to get the device status and then format/log the results… then have the system’s task scheduler invoke the script on the dates of interest. Logging to a google sheet is an option, or I could just log it locally.

I gather the google tool option described here won’t work as-is, but perhaps the alternate javascript @TAustin offered to TapioX ( Temperature Map in Smartthings? might be the basis of a solution - but scanning that script it seems beyond my java skills to modify to my specific use. I’ve also zero experience with direct use of the ST API (beyond CLI uses to modify edge drivers).