So I am wondering if there is a way to trigger an action (lights blink, sound, etc) when a google sheet is updated. If not directly through Hubitat, maybe there is a workaround with IFTTT or Microsoft Flow? Any ideas? Thanks!
Dan
I did this in the past using an IFTTT applet. Google Sheets service can trigger when a row/cell is added, then the Hubitat service can turn on a virtual switch that is tied to an action, using Rule Machine.
Sounds pretty straightforward. I created a virtual button. Then I went into IFTTT and made an applet that when a particular cell is updated, then.... and that's where I am stumped. In the Hubitat actions, I don't see any way to turn on the switch.
Which of these options should I do? I tried each of them, but my virtual button doesn't show up as an option. Any suggestions would be great! Thanks!
Actually I think I figured it out. I needed to refresh what devices IFTTT could use/see. Thanks for your suggestion!
1 Like
I got it working, but IFTTT can be quite slow. Does anybody have any solutions that might trigger immediately when the Google Sheet changes? Thanks!
