News:

Let's find out together what makes a PIC Tick!

Main Menu

Uploading data to Googlesheet

Started by shantanu@india, Jan 26, 2022, 04:34 PM

Previous topic - Next topic

shantanu@india

Thought of sharing this which might come in handy to someone who wants to upload realtime sensory data to cloud without taking the hassle of writing much code.
You just need a Google account & a free ITTT account. ITTT(If this then that) provides Java Applet based Api service where you need to define a trigger-action combination. No coding...only select 'webhooks' as trigger & googlesheet(add row) as action.
The json statements are created automatically.
On the device side you just need to generate a webrequest with the appropriate event name that you have defined in the ITTT triggering event.
I used ESP8266 with micropython as in the following video:
https://www.youtube.com/watch?v=ulXUhU13LVg
Regards
Shantanu