Post-Groovy Google Spreadsheet Integration

@TBI

Responded here.

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).

I think you’re on the right path with using the API to periodically fetch the data you want and then doing with it whatever you want - including posting to a Google sheet. It certainly would be easier than trying to come up with an automation within SmartThings.

The ST API part was surprising easy to get working. Now I’ve just got to get the Python code working on my NAS and I should be good to go. Thanks for the encouragement.

1 Like

Did anyone succeed with an install on an older Synology NAS (eg DS209), how to do that?

In my case I avoided the install with my own (much simpler) Python code that captures the specific device info I wanted via the ST-API, writing results into my own (local) spreadsheet. That runs as a scheduled task on my Synology DS218… if you’re running the latest DSM versions Python is natively available.