I decided I needed to outline my design for the esp8266 monitor project.
The problem is I’d like to pass the status (an integer representing Open, Closed, Operating) to a Google script. The Google script can then add a row to the table, calculate the delta time and show the status.
Well, since I’m not an expert, I’ve learned that just about everything requires an HTTPS POST or GET and the security stuff for the ESP8266 is over my head. So, now I’m trying a bunch of different intermediaries to set what can work.
Next, loot at the options for IoT connections.
Have you found a solution in the meantime? I am also troubling around with exactly this problem.
I have 2 solutions.
First, I worked with Alvaro at Thing.io and got my google script to run from an endpoint. However, I could not reproduce it to be able to tell others. Very strange. It worked great for several months.
My current solution is to use IFTTT and call google. I noted this in a more recent post. That works OK, but there is a delay as it goes through.