Send Data to Google Spread Sheet using ESP32 IFTTT, DHT11 | IoT Projects | IoT Training

This Project is to Post the data using ESP32 and IFTTT to google spread sheet. In this project we will be using IFTTT service, so we don't have to worry about google script which we saw in last video.
Here, we are updating the temperature value, Humidity (DHT11) and LDR values to google spreadsheet. Likewise we can use any sensors like Soil moisture, HC-SR04 etc. connected to ESP32.
Code and Connection Diagram:
github.com/stechiez/iot_proje...
You can get the material from :
Nodemcu - www.banggood.in/custlink/mmKh...
ESP32 - www.banggood.in/custlink/KDmh...
Breadboard - www.banggood.in/custlink/DGKy...
​Jumper Wires - www.banggood.in/custlink/vGGh...
​​
Read Google Spreadsheet using ESP32
• Read Google Spread She...
Google spreadsheet using esp8266
• [IOT Projects #1] How ...
Google spreadsheet using ESP32
• Send Data to Google Sp...
Tutorial on How to post data to Google Firebase using ESP8266
• [IOT Projects #3] How ...
Tutorial on How to post data to Thingspeak using ESP8266
• [IOT Projects #4] How ...
How to Get Gmail Notification on ESP8266 & OLED
• [IOT Projects #2] How ...
#esp32
#google
#spreadsheet

[@officialwondersharefilmora2174]

Great works keep it up
You actually made my project awesome

[@GrigorisXatzikiriakos]

thank you, the best tutorial of it's kind.

[@StechiezDIY]

You're welcome!

[@arohaadavadkar9932]

Can you please tell me which library is to be installed for HTTPClient?

[@oleksandralba5295]

great work man!

[@StechiezDIY]

Thank you! Cheers!

[@MuhammadIlham-iq3zf]

Can you help to make free notification from the spreadsheet that we have connect with ifttt?

[@ihsanbu]

hi
i am struck in bmp180 and bmp280 sensor sensor interface , uPython IDE all gives message to that bmp180 and bmp280 sensor lib problem , even i copy all standard codes and library , can you help me in this regards by upload of vide in this regard

[@alifsalleh9489]

hello you have made a good tutorial. i have an question. Iftt will make thier own file in google drive? or i need to create it by myself. i really appericiate if you answer my question. Thankss a lot!

[@allanamancio1351]

hello, can you do ESP32 cam? to Google sheet?

[@blancoffee9444]

how can I i do it with ir sensor pls

[@why.k5max]

can you make it again but with RFID ?

[@muhammadshan1151]

helpful

[@sandilovse3378]

Thanks, it helped me to configure things right. Other solution don t work.

[@StechiezDIY]

Glad it helped

[@Mohamm-ed]

Thanks sir for this video.. I have a question regarding this. Can I record the temperature every hour for a whole day then send the recording as a bulk not separately. I don't want to connect every hour to the internet just once a day. I neet this and I searched for that a lot but couldn't find anything. Could you please help me and thanks in advance..

[@StechiezDIY]

There are limitation with IFTTT for sending request to google spreadsheet. But you can try following method for sending value to google sheet.
czcams.com/video/KPOFncRDiHQ/video.html
I am sure you will get it solution with above method.

[@Mohamm-ed]

@@StechiezDIY thanks a lot

[@amirahsyafirahbintirizala1935]

Terbaik
5 ha

[@dr-mnizam]

Cuba tgk video ini: czcams.com/video/CACsMxHalaI/video.html

[@puvenkumaaralgovindarajans4615]

Hi sir, how to add on value4 in spreadsheet using ifttt

[@StechiezDIY]

IFTTT doesn't provide support for more than 3 values as far as i know.

[@akosiAyRah]

hi sir! what did you install for HTTPCLient?

[@akosiAyRah]

and also for DHT.h?

[@StechiezDIY]

these are the libraries used for HTTP functionality and HDT functionality.

[@krishnasolanki5042]

Sir httpclient error will not solve if I already downloaded the Library, and try the other ways to solve this error bt it will not work..

[@krishnasolanki5042]

And the source code in wifi initial code we will change it or not

[@StechiezDIY]

Yes source code requires changes for wifi credentials.

[@makbutahplengngen1541]

Can we use esp8266 instead of ESP32?

[@YB_DevZone]

I need to know this too , did you find?

[@makbutahplengngen1541]

@@YB_DevZone unfortunatelly it does not work

[@nerellq]

Good video
Is any idea to add more ingredients in ifttt

[@StechiezDIY]

Yes, definitely you can add.

[@yuvarajvisvanathan3757]

why i couldnt generate spreadsheet after test it

[@StechiezDIY]

may be there is issue in configuration.

[@MuhammadIlham-iq3zf]

I think your sync is off.turn on it so you can generated it.

[@Embedded_baba]

Can we use same code for esp8266

[@StechiezDIY]

Most of the code can be used but libraries might be different.

[@pfmoreir]

O Pay Wall do IFTTT da nojo!