Uploaded November 2018 | Updated September 2026, 3 weeks ago

---

This Project is to Post the data to google spread sheet using ESP8266. 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 esp8266.

Component required:
Nodemcu - banggood.in/custlink/mmKheOZjl3
ESP32 - banggood.in/custlink/KDmh0l8aOr
Breadboard - banggood.in/custlink/DGKyeOSast
Jumper Wires - banggood.in/custlink/vGGheoIogd



buymeacoffee.com/stechiezdiy

Here is the updated code.
github.com/stechiez/iot_projects/tree/master/PostDataToGoogleSheet
Library Used: github.com/electronicsguy/ESP8266.git

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

Read Google Spreadsheet using ESP32
youtu.be/0LoeaewIAdY

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