Google spreadsheet to ESP8266, Google Sheets to ESP8266, data from Google Spreadsheet to ESP8266

this video is brought to you by odium 365 via the world designs electronics and octopod the fastest search engine for electronic parts ever since i made a video on google spreadsheet and esp8266 many boys and girls have been requesting me to make google spreadsheet and esp8266 part 2 video to explain how do we send data or sensors threshold values from google spreadsheet to esp8266 or esp32 wi-fi plus bluetooth module well let me tell you that in part one i explained how you can send data from esp8266 to google spreadsheet so if you want to monitor sensors or send any other data from esp8266 or esp32 to google spreadsheet then i highly recommend that you guys must watch my previous video sending data to google spreadsheet from esp8266 or esp32 is quite easy and you will get many videos on it however sending data from google spreadsheet to esp8266 or esp32 is a bit tricky and there is not a single video available on it so i decided to make a detailed video on it so in today's episode you will learn how to make a soil moisture monitoring system using google spreadsheet or google sheets esp82665m audio a soil moisture sensor if you do not have this particular soil moisture sensor it's ok you can use any other type of the soil moisture sensor you will also need a five-volt buzzer and an o-r-d display module all the components i'm using in this project i have already made beginners level videos on them the links of which you can find in the description given below i have connected everything is per the circuit diagram which i will explain in a minute but first i'm going to explain how this project actually works and then i will start practical demonstration on the monitoring side i have two google spreadsheets on this google sheet i am using five columns for monitoring date time temperature humidity and soil moisture on this google spreadsheet i am receiving data from the esp8266 while the other google spreadsheet i'm using for setting the threshold values of soil moisture and temperature let's say that i want the buzzer to turn on when the soil moisture drops below 60 percent then i will simply write 60 over here and in the same way if i want the led to turn on when the temperature increases above 45 degrees celsius then i will simply write 45 over here to further confirm that the google spreadsheet actually sends these threshold values to the esp8266 i will be displaying these values on the or led display module so i'll use buzzer as an indicator when the soiled moisture drops below the threshold value and i will use the esp8266 onboard led as an indicator with the temperature increases above the set value or threshold value now let's go ahead and kick off our practical demonstration ultim365 lets you hold the fastest design reviews ever share your designs from anywhere and with anyone with a single click it's easy leave a comment taking your teammate and they will instantly receive an email with a link to the design anyone you invite can open the design using a web browser using the browser interface you are able to comment markup cross probe inspect and more comments are attached directly to the project making them viewable within ultim designer as well as through the browser interface design share and manufacture all in the same space with nothing extra to install or configure connect to the platform directly from ultim designer without changing how you already design electronics ultim 365 requires no additional licenses and comes included with your subscription plan git real-time component insights is your design with octopart built into ltm 365. up to part is the fastest search engine for electronic parts and gives you the most up-to-date part data like specs data sheets gate models and how much the part costs at different amounts etc right in the design environment so you can focus on your designs links to the ultim designer ultim 365 and octoport are given in the description i have powered up all the electronics right now esp8266 and laptop or connected with the wi-fi after every few seconds i am receiving the temperature humidity and soil moisture values from the esp8266 this time duration can be changed in the programming right now the buzzer is off as the soil moisture value is above the threshold value let's say i want to maintain the soil mixture value above 60 percent so what i will do i will simply increase the threshold value it takes a few seconds before the value is updated on the o error display module you can see the threshold value on the oled display module is updated and also the buzzer has turned on you can also see the onboard led is off as the temperature is below the threshold value of 45 degrees celsius i can also change this value let me change this to 25 degrees celsius you can see the value on the o led display module is updated and you can also see the led has stand on let me change this again now the threshold values are set so now i can go ahead and add some water you can see the updated value of the soil moisture and the buzzer has also turned off now i am going to apply some heat you can see the temperature value has increased and also the onboard led has turned on i'm sure by now you might have got an idea of how does this system work so without any further delay let's get started [Music] access granted [Music] the components and tools used in this project can be purchased from amazon the components purchase links are given in the description i'm using a five volt trapeze power supply to power up all the electronics the sck or scl and sda pins of the ssd 1306 or irriday display module all connected with the d1 and d2 pins on the node mcu esp82665m audio while the vdd and ground pins of the o led display module are connected with the 3.3 volt and ground pins d4 pin on the esp8266 is used to control the five volt buzzer i use 2n22 npn transistor and a 10 kilo ohm resistor to control this buzzer the transistor and resistor make the driver circuit data pin of the dht 11 temperature and humidity sensor is connected with the d3 pen on the esp8266 wifi module while the voltage and ground pins of the dhd11 sensor are connected with a 3.3 volt and ground pins the analog output pin of the soil moisture is connected with the air zero pin and vcc and ground pins are connected with the 5 volt and ground so that's all about the circuit diagram and now let's work on the google spreadsheet this part of the google spreadsheet i have already explained in my previous video on the google spreadsheet and esp8266 in which i have explained how to send data from esp8266 to google spreadsheet so i won't talk during this part of the video but i will explain things which are related to sending data from google spreadsheet to esp8266 [Music] [Music] [Music] [Music] [Music] we are done with the settings for receiving data from the esp8266 now to send data from google spreadsheet to esp8266 add another google sheet in the same way as we did previously [Music] give a name to the spreadsheet [Music] set the column names is soil moisture and temperature values stored in a2 and b2 cells are going to be sent to esp8266 so in the programming we will only access these two cells click on the extensions and select apes scripts [Music] you can copy this script code from my article all the other steps are exactly the same [Music] [Music] [Music] now copy the deployment id paste it next to the g-scripted id this is used for receiving data from google script address [Music] finally you can click on the done button our google spreadsheets are ready for receiving and sending the data now let's go ahead and take a look at the programming this is the same exact program which i previously used for sending data from esp8266 to google spreadsheet this time i also added code for sending data from google spreadsheet to esp8266 you can download all these libraries from our website electronicclinic.com i will provide a link in the description for this project you will also need these three files debug macros.h http redirect.cppb and http redirect.h these files are need to be placed with the main programming file in the same folder finally i uploaded the program [Music] i have powered up all the electronics right now esp8266 and laptop all connected with the wi-fi after every few seconds i'm receiving the temperature humidity and soil moisture values from the esp8266 this time duration can be changed in the programming right now the buzzer is off as the soil moisture value is above the threshold value let's say i want to maintain the soil mixture value above 60 percent so what i will do i will simply increase the threshold value it takes a few seconds before the value is updated on the oh errata display module you can see the threshold value on the o led display module is updated and also the buzzer has turned on you can also see the onboard led is off as the temperature is below the threshold value of 45 degrees celsius i can also change this value let me change this to 25 degrees celsius [Music] you can see the value on the o led display module is updated and you can also see the led has stand on let me change this again [Music] now the threshold values are set so now i can go ahead and add some water [Music] you can see the updated value of the soil moisture and the buzzer has also turned off now i am going to apply some heat you can see the temperature value has increased and also the onboard led has turned on support me on patreon for more videos i hope you liked today's episode like and share this video with your friends see you in next episode and thanks for watching

Channel: Electronic Clinic

Views: 16,279

Keywords: google spreadsheet, google sheet, google sheets, esp8266 google sheets, esp8266 google spreadsheet, google sheets to esp8266, google sheet to esp8266, google spreadsheet to esp8266, electronic clinic, altium, altium designer, octopart, data from google spreadsheet to esp8266, esp32, esp32 google spreadsheet, esp32 google sheet, how to send data from from google sheet to esp8266, arduino, how to use google spreadsheet with esp8266, google spreadsheet project, google sheet project

Id: 7rCZB7tN4P8

Length: 17min 13sec (1033 seconds)

Published: Thu Aug 04 2022