Get Sensor to log data to google sheets?

[bradles]

Hi,

I have an Aeotec Smartthings Hub along with the MultiSensor 6 and the Hue Motion Sensor. For my use case, I’m looking to get the sensors to log motion detections to a google sheet - similar to this tutorial here: GitHub - loverso-smartthings/googleDocsLogging: SmartThings Google Sheets Logging.

I can create the spreadsheet and webapp easily enough. However, when I get to the “Create the SmartApp” it all falls down. I am unable to create a SmartApp as it appears there are no options to do this. Does anyone have a walkthrough on how you can do this?

Thanks,
Brad

[TapioX]

Look this topic

Post-Groovy Google Spreadsheet Integration

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…

[bradles]

Is there any way to do this without an always-on computer?

Brad

[TapioX]

I think it is needed. @TAustin

[h0ckeysk8er (Bruce Pinsky)]

@bradles

Is there any way to do this without an always-on computer?

Brad

Hubs can only connect to local LAN IP addresses. To connect outside the local LAN, you need a proxy.

[JDRoberts]

Many people are using the following third-party option for logging. I don’t know if it would meet your needs, but you can check out the thread. (The topic title is a clickable link.)

ConstantGraph Data Logging and Charting

I’ve been working on an integration between SmartThings and https://www.constantgraph.com (which is a cloud based logging and graphing site for home automation). ConstantGraph has been working with the Ezlo/Vera platform for a while now but this is the first attempt to hook it up to SmartThings. Is anyone interested in testing it out and giving feedback on how well the integration works? The service is completely free. Of particularly interest is anyone who has a whole home energy meter capable of logging at at least every 30 seconds or better (e.g. Aeotec HEM) as there is a feature to “disaggregate” the energy signature into the individual devices (even if there are not smart). Once you have created an account there is an option on the account page to connect to your SmartThings acco…

As far as “creating a smartapp” smartthings introduced a new architecture recently, and they no longer provide a free Groovy cloud to run smartapps. So anything older than 2023 referring to SmartApps is likely out of date.

You can still write your own smartapps, but you have to host them yourself, and then come in through the REST API, which is a whole different process and somewhat more complex than the previous method. But more scalable.