Uploaded August 2020 | Updated September 2026, 3 weeks ago

---

$2 for PCB Prototype & Free SMT assembly : jlcpcb.com

This Project is to Post the data using ESP32 to google spread sheet. This will involve google script which will be manage to write the google spread sheet column and row. So, No need to use any third party server to update the google spread like IFTTT.
Here, we are updating the temperature value to google spreadsheet. Likewise we can use any sensors like Soil moisture, LDR, HC-SR04 etc. connected to ESP32.

Code and Connection Diagram:
github.com/stechiez/iot_projects/tree/master/GoogleSpreadSheet_ESP32

buymeacoffee.com/stechiezdiy

Links to get the parts,
Nodemcu - banggood.in/custlink/mmKheOZjl3
ESP32 - banggood.in/custlink/KDmh0l8aOr

Read Google Spreadsheet using ESP32
youtu.be/0LoeaewIAdY

Google spreadsheet using esp8266
youtu.be/Fq1kgt_auns

Tutorial on How to post data to Google Firebase using ESP8266
youtu.be/WwRjlMKAjXw

Tutorial on How to post data to Thingspeak using ESP8266
youtu.be/_2vIPBNzGAQ

How to Get Gmail Notification on ESP8266 & OLED
youtu.be/mxU4ZRLazac

Support My Channel:
buymeacoffee : buymeacoffee.com/stechiezdiy
Patreon : patreon.com/stechiez

#esp32
#google
#spreadsheet