I think I understand what you did (looks really nice), but I am not sure if this works for me. I want to receive a “push notification” whenever a certain event takes place (sensor on spar) and basically log the event and the time in a spreadsheet. This is the first tiny step for a larger project, but given that I am new to all this I try to take it slow.
I see how this will work with a tiny webserver, but is it possible to trigger the https url call based on an external event? As far as I currently understand it, this might be difficult… or do I get it wrong?
The Spark core does not have the resources to do HTTPS on its own; it does HTTP transfers well. The certificate management for TLS/SSL would not fit in memory. So instead it has one secure connection to the Spark cloud but you can use that connection for all sorts of things: variables that you can read from the core, functions you can call on the core, events you can publish from a core and recently even subscribe to. Check the docs and the tutorial section here in the forum for more info.
There is a way for a Google spreadsheet to pull data from the core periodically described in this thread:
I am also looking for a way to publish data from the core to Google spreadsheet. Pulling data from the core just doesn’t work for me. My core is working in somewhere that doesn’t have a power outlet and it is being powered by two AA batteries. Therefore most of the time it is going to be in deep-sleep mode and wake up about once per hour to send out data. I used to do that with Arduino Yun and Google form with code like this.
p.runShellCommandAsynchronously(“curl “https://docs.google.com/forms/d/NDWnjgQ9EVVGOQmSz1NW4sbHmoDXcaJ4cvoz0s/formResponse?entry.21328096=” + data + “&submit=Submit” -k”);
Hi @bko , just wondering if you could give a little more detail on the “completely easy” IFTTT Google spreadsheet. I have an event published under Spark.publish called “static” that I’m broadcasting via a webhook to Ubidots. I’d prefer to send the data to a google sheet - but when creating a recipe, and adding what I think is correct - nothing happens. I know the data is being published (because I see it on the Particle Dashboard - and in Ubidots).
Here is a screenshot of the IFTTT trigger and action sections. In my case the published event name is “Temperature”. The action is on your Google Drive (not the spreadsheet program in Google) which might have been hard to figure out.
@bko I know it’s an older topic but the content I’m posting is relevant so please don’t flag it. The esp8266 now has ssl support. Even on the original ESP-01 with small amount of memory. See here: esp8266-ssl
I am using it to log data from my ESP-01 directly to google spreadsheets.