hey,
I found the way to save data pushed from your particle into a google sheet.
I followed these instructions for the google sheet configuration:
Then created a particle webhook with:
event name: googleDocs
full url: what you get from google docs (example: https://script.google.com/macros/s/1236278936489127634-2876348/exec)
POST
form: key=name value={{my-name}}
headers: "Content-Type": "application/x-www-form-urlencoded; charset=UTF-8"
include defaults: no
then in your firmware:
Particle.publish("googleDocs", "{"my-name":"aloha"}", 60);
I learned few tricks on the webhook custom features here:
Screenshot of my particles reporting events to my google sheet:
It worked for me. Hope it helps,
Gustavo.
PS: I have a few "undefined" fields but hey, that will be fixed next time