Is it possible to create a log of device events? I am specifically interested in recording the temperature and humidty readings from my Centralite sensor. I can view them in the app (for the past seven days) but can’t seem to export the information so I can save it or access it more easily.
MarkTr
(MarkTr)
February 25, 2023, 4:33pm
2
Logging to a Google sheet should be possible. See this thread for one approach.
Many of us used a nice SmartApp called Simple Event Logger to post SmartThings info to a Google spreadsheet. Now what? Is there a way to do this that doesn’t require a SmartApp?
The answer is yes, with the catch that you need a SmartThings hub and an intermediate computer to bridge between Edge devices and Googlesheets. On your always-on computer like a Raspberry Pi or other, you run a very small, 30-line nodeJS app that will accept HTTP posts from Edge containing the event info and it will use the Google API to post the contents to your spreadsheet.
How do you send the HTTP requests from Edge? You can use my Webrequestor or HTTP Devices drivers, which can be configured with the event info you want (text, number, boolean). The info is appended as a row in your spreadsheet along wit…
1 Like