IFTTT automation-Google sheets?

charles.americanos · April 22, 2019, 7:15pm

I wondered if this would be a possible use of IFTTT automation?
But I do not see many Hubitat useful features.
I want to log into a Google drive sheet all sensor instance timestamps of a Door magnetic contact being in "open" state.

I presume this is more possible using the Rule machine - But I have seen IFTTT used for such log file creations.

Any ideas?

vjv · April 23, 2019, 12:59am

Like this?

Ring is a virtual switch in HE, I did not have anything else to add in IFTTT, but works.

Or like this:

charles.americanos · April 24, 2019, 7:34am

Thanks for this clue! So in case of a magnetic contact sensor - Open or Closed - assume Open equates to Ring?

Also when I search for this virtual switch in IFTTT it does not list
Am I doing something wrong?

regards

Charles

vjv · April 24, 2019, 12:42pm

Yes, but a virtual switch fits better. On is ring or on is motion. You activate the auto off.

You create the virtual switch in HE, then in the IFTTT integration app in HE you add it, then it should appear when you create the applet in IFTTT

alejoc · August 23, 2019, 3:29am

Hi, is there any way variables not included in the Hubitat applet for IFTTT can be logged in a Google spreadsheet, such as temperature, voltage, power or humidity?

dewhite04 · September 3, 2019, 3:39am

I would also like to know this. I'm specifically looking to log Power as measured by a Peanut Plug to Google Sheets so I can study the power consumption of a chest freezer over time.

alejoc · September 4, 2019, 4:11pm

Does your Peanut report power? Mine do not. Is there an updated driver?

aaiyar · September 4, 2019, 4:34pm

There is a community driver that permits power reporting - but your Peanut's will have to have their firmware updated to support power reporting. The only way to upgrade their firmware is by pairing them an Almond+/Almond 2015/Almond 3 router.

Edit - here's the community driver:

github.com

jimcghee/Hubitat-PeanutPlug/blob/master/PeanutPlug.groovy

/**
 *  Peanut Plug
 *
 *  Copyright 2017 pakmanw@sbcglobal.net
 *
 *  Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 *  in compliance with the License. You may obtain a copy of the License at:
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software distributed under the License is distributed
 *  on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License
 *  for the specific language governing permissions and limitations under the License.
 *
 *  Peanut Plug
 *
 *  Author: pakmanw@sbcglobal.net
 *
 *  Change Log
 *  2017-09-17 - v01.01 Created

This file has been truncated. show original

dewhite04 · September 4, 2019, 6:58pm

Ashok,

Thanks for your reply! Indeed I have an Almond+ that was laying around gathering dust. I updated my peanut plug and installed the driver you have linked a couple of days ago. Power reporting is working.

What I'm seeking now is a useful way to record the data for review. I was hoping to find a way to send it to a Google Sheet. I have seen some discussion of this around these forums, but have yet to find a discussion with Hubitat specific implementation that I can follow. Any thoughts on this?

alejoc · November 4, 2019, 7:46pm

I nned something similar. The IFTTT app does not have a trigger for humidity and I want to monitor it, since that is the variable I use to control my A/C. I think the easiest way would be to add the remaining triggers to IFTTT or develop something similar to Simple Google Logger that already exists for Smartthings