ESP32 Relay Control With Google Sheets | ESP32 Home Automation

#ESP32 #GoogleSheets #HomeAutomation
In this video, I will show you how to control relay module, using ESP32 and Google Sheets. This technique is not as efficient as other IOT platforms, such as blynk IOT, or Arduino IOT, It takes 5 to 6 seconds to perform a command, but It is unique Idea, to control home appliances using google sheet for free. This is a Smart Home Automation project without using any cloud service.
If you have a question like "How do I transfer data from ESP32 to Google Sheets?". Then check this project. I have add the feature to send data from ESP32 to Google Sheets. Using this project you can send as well as received data from Google Sheets.
to turn ON the relay, enter relay number, along with the command, ON. then. ESP32 read the command, and turn on the relay. this whole process takes 5 to 6 seconds. also. you can see, the status of the relay will be updated, in real time. similarly, to turn OFF the relay, enter relay number, along with the command, OFF. and the relay will be turned off.
Let's see How I made this ESP32 Home Automation project. Let's Get started.
for this project, you will need an ESP32 board. 4 channel relay module. 220 volts AC bulbs. so let's do the connection. connect all the components as per circuit diagram.
I have used Arduino IDE for writing the sketch for ESP32. So, Install the ESP32 Board, before uploading the code to Espressif ESP32 Micro controller.
Parts:
1. ESP32 - amzn.to/3YCq2dS
2. Relay Module 4 channel - amzn.to/3YJXa3w
3. Breadboard - amzn.to/3ysOvHX
4. Jumper Wires - amzn.to/3YRafs5
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
Home Automation System using ESP32 and Blynk 2.0
• Home Automation System...
SiM800L Home Automation using Arduino IR Remote Control Relay
• SiM800L Relay Control ...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs
TH-cam:
th-cam.com/users/ahmadlogs?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/esp32/tr...
--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.
Warning: I will use High Voltages which if incorrectly or improperly used could result in serious injuries or death. So be careful of what you are doing because I will take no responsibility for any of your actions.

[@scarabe-ing]

Merci beaucoup, c'est exactement ce que je cherchais !
Très bien expliqué et agréable à regarder, bravo ! je m'abonne !

[@azzattar8422]

Clair et bien expliqué, merci beaucoup et bonne continuation....

[@flaviojmsouza]

Great, guy! Thank you!

[@AAdnaanmtl]

unique idea Sir. Thanks for sharing knowledge.

[@AhmadLogs]

Thanks for liking

[@kamaledirisinghe]

I did this and it really worked. Thanks for your effforts

[@AhmadLogs]

you are welcome

[@rampage_xdit]

Very intresting!

[@AhmadLogs]

Glad you think so!

[@s.husain6125]

Great sir

[@AhmadLogs]

thanks

[@trongsangfee]

woa, this is perfect

[@AhmadLogs]

thanks

[@antoniomanuel8119]

Very nice tutorial. I would like to know how to start up my relay status on Esp32 based on last updated status on google sheet

[@user-ug2in4dm2x]

Would you please do it on the appsheet ?

[@rampage_xdit]

Hi Ahmad .This project is very good ,please work with google sheet an Mit app inventor more and go to the making bussiness app please.regards

[@AhmadLogs]

But I have no any Idea about business apps

[@kamalkamel7559]

NICE!! how to use this code an esp8266 not esp32?, what is the library changed? thank you

[@AhmadLogs]

No change. this code will work on esp8266. just give a try

[@kamalkamel7559]

@@AhmadLogs I tried with esp8266, here is the error
-> candidates: [] sketch_oct06a: 16: 24: fatal error: HTTPClient.h: No such file or directory

[@AhmadLogs]

@@kamalkamel7559 hmmmmm. then you need to test ESP8266HTTPClient. but It required to update the code as well

[@imanrizky8916]

@@AhmadLogs i have some issue , please tell me how to resolve the problem sir..

[@smart.remote2492]

@@AhmadLogs
I uploaded this code for ESP8266, it gives me the following error:
Reading Data From Google Sheet...
HTTP Status Code: -5
Error on HTTP request
What do you think is the solution?

[@nagarava]

Can I use esp8266 in place esp32 ?

[@AhmadLogs]

I never test it. but I think you might use esp8266. just change the relay pins in the code.

[@Sarjanandeso]

I tried, but not run, invalid command..whats wrong?

[@AhmadLogs]

give me some more details about the error.

[@Sarjanandeso]

@@AhmadLogs in serial monitor Invalid Command
Reading Data From Google Sheet.....
HTTP Status Code: 200
command, please help

[@Sarjanandeso]

@@AhmadLogs in Apps Script TypeError: Cannot read property 'parameter' of undefined
doGet @ Kode.gs:21

[@Sarjanandeso]

please help me sir..im curious about it

[@AhmadLogs]

@@Sarjanandeso try some old version of the esp32 core from the board manager in arduino IDE

[@001jmt]

Hi @ahmad , facing an issues with the below error :
exit status 1
'HTTP_STRICT_FOLLOW_REDIRECTS' was not declared in this scope