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:

--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
Home Automation System using ESP32 and Blynk 2.0

SiM800L Home Automation using Arduino IR Remote Control Relay

--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
Youtube:

--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------
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 !

[azzattar]

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

[kamaledirisinghe]

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

[AAdnaanmtl]

unique idea Sir. Thanks for sharing knowledge.

[antoniomanuel]

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

[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

[ugindmx]

Would you please do it on the appsheet ?

[kamalkamel]

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

[Sarjanandeso]

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

[jmt]

Hi @ahmad, facing an issues with the below error :


exit status 1
was not declared in this scope