So here is what I am trying to do. I want to somehow read a table data element from a website and have that data either populate in my Cayenne dashboard or use it to trigger an event.
Right now I have a Google Sheet that is populated with a lake’s water depth off of a website. I want to somehow trigger an event based on changes to the water depth data item. is there a way to somehow do this using either Google sheets or some other way?
I have a floating boat dock on Norris Lake in TN. Right now I am using a Cayenne dashboard to actuate winches that adjust the cables for fluctuations in lake water level. The lake level is constantly updated and I have that feeding into a Google Sheet - I want to somehow use a trigger or otherwise to automatically trigger an alert and actuate my cable winches for a certain drop or increase in lake level.
Is there a way to do this?