I seek a solution to log the ST history to a Google sheet. Older threads on topic are outdated as the ST architecture has changed. Is any approach feasible that pipes or exports what is visible under History on the ST app into a Google sheet or similar?

Thanks! Would anything on the cloud / less involved be available? (ie not running a local machine 24/7 at home)

Well, cloud service is possible, but I don’t think there is an out of the box solution. So you should expect to do some work to get it working. Try looking into Google Apps Script . It is a web platform based on Javascript for Google Workspace apps automations, such as Sheets and Docs. It is a great…

Thank you. I’m aware and should be somewhat able to use Apps Script in sheets. I seek to find the best logic or command in the ST API, however. I don’t require a real time update or push notification upon some ST activity. Pulling the history out of ST, eg all logs since the last pull, let’s say at…

This is a really helpful thread: [image] [API] Check All Devices Health in Batch Support Hi, Currently, I can’t find any API that can return List of Devices with its Online/Offline Status. We need to specify Device ID which means if I has 50 Devices, I will need to make 5…

I kept getting stuck until I found an example script that helped me sort out the formatting part for Google Sheets. If you’re just trying to clean up your sheet or make the data easier to scan later, the automation tips on MyExcelOnline’s blog gave me a couple of good ideas. Might be worth checking …

Log to Google Sheets

Devices & Integrations

ramgoy February 5, 2024, 4:18pm 2

Maybe check out this thread.

Post-groovy Google Sheets Integration

Topic		Replies	Views
Log State to Google Sheet Automation Ideas developers	1	1430	November 23, 2015
Get Sensor to log data to google sheets? Projects & Stories logging	5	1082	August 4, 2023
Post-Groovy Google Spreadsheet Integration Projects & Stories logging , requires_server , aftergroovy , edge_services	25	3224	February 6, 2024
Saving Events Automation Ideas	1	506	February 25, 2023
Google Sheets event logger Automation Ideas	3	811	June 16, 2023

Log to Google Sheets

Related topics