You can use the SmartApp Simple Event Logger to publish data to a Google spreadsheet. You’d have the raw numbers, but you’d have to develop the charts and reports on your own.
This SmartApp will stop working when the Groovy platform is retired
This SmartApp is no longer supported because SmartThings made some changes to the way events are handled which has impacted some users and it will most likely completely stop working in the near future.
There’s another SmartApp called something like Google Sheets Logger that subscribes to the events instead of retrieving them from the device history so it most likely won’t have the same issues as this one.
Simple Event Logger is a fully customizable SmartApp that allows you to accurately log all device activity to a Google Sheets Spreadsheet. Each event is stored on a separate row so that you have their exact time and details.
Google Sheets has an easy to use filter feature which allows you to do things like view all e…