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 events for specific device(s), in a specified date/range and/or specific types of events like temperature.
Since all of your data will be stored in one spreadsheet, advanced users can easily generate pivot tables and graphs for any information they need. It also eliminates the need to update the code in multiple spreadsheets every time a new version is released.
See the Installation Instructions for a complete list of features that make this SmartApp unique.
This SmartApp was created entirely from scratch and has no relation to or code from any other logging related SmartApp.
This SmartApp involves the usual code for the SmartApp and code that needs to be added to a Google Sheet so please follow the installation instructions instead of just grabbing the code below and installing it like any other SmartApp.
Google Sheets Script Code