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



Published
Altium Designer:
https://www.altium.com/yt/electroniclinic

Altium 365:
https://www.altium.com/altium-365

Octopart, components search engine:
https://octopart.com/

Download circuit diagram and programming:
https://www.electroniclinic.com/send-data-from-google-spreadsheet-or-google-sheets-to-esp8266-or-esp32/

Watch my previous video on Google Spreadsheet:
https://youtu.be/OtPWCBL9sdY



Support me on Patreon and get access to hundreds of projects:
https://www.patreon.com/ElectroniClinic




Project Description:
**********
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?

Well, let me tell you that in Part-1, 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 SEP32 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, ESP8266 WiFi module, a Soil Moisture Sensor, if you don’t 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 5V buzzer, and an Oled display module.

All the components I am 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 as per the circuit diagram which I will explain in a minute. But first I am 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 5 columns for monitoring Date, Time, Temperature, Humidity, and Soil Moisture. On this Google Spreadsheet I am receiving data from the ESP8266.

**********





Amazon Purchase links:
*****************
12v Adaptor:
https://amzn.to/3wb7GUj

Nodemcu ESP8266 WiFi Module:
https://amzn.to/3sx24l4

ESP32 WiFi + Bluetooth Module
https://amzn.to/3cDz6wU

DHT11 Temperature and Humidity Module:
https://amzn.to/2O0YqRF

Soil Moisture Sensor
https://amzn.to/3zA3aTm

SSD1306 Oled display module
https://amzn.to/3ba3WNq

5V buzzer
https://amzn.to/3PApdPj


Other must-have Tools and Components:

Arduino Uno, Nano, Mega, Micro "All types of Arduino Boards":
https://amzn.to/3fk5OTi

Top Arduino Sensors:
https://amzn.to/3vZbnfM

Super Starter kit for Beginners
https://amzn.to/3cq56C5

Top Oscilloscopes
https://amzn.to/3ctF3d8

Variable Supply:
https://amzn.to/2PEAqE7

Digital Multimeter:
https://amzn.to/2QGRPg1

Top Soldering iron kits: "best"
https://amzn.to/39nqDtb

Top Portable drill machines:
https://amzn.to/3suQMh7

Jumper Wires:
https://amzn.to/2NYPEDA

3D printers:
https://amzn.to/3ruG1dt

CNC Machines:
https://amzn.to/3cuZWVv

Electronics Accessories:
https://amzn.to/3sueV7z

Hardware Tools:
https://amzn.to/3m9UhaN


DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I will receive a small commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!
****************

For More Projects and Tutorials visit our Website:
https://www.electroniclinic.com/


Follow me on Facebook:
https://web.facebook.com/Electronic-Clinic-769734390044415/
Follow me on Instagram:
https://www.instagram.com/electroniclinic/

Email:
[email protected]

About the Electronic Clinic:
Electronic Clinic helps the students and other professionals to learn electronics, designing, and programming. Electronic Clinic has tutorials on Arduino, Arduino Nano, Raspberry PI, image processing, gsm based projects, Bluetooth based projects, esp8266 projects, Nodemcu projects, robotics, desktop application designing and programming, PLC, SCADA, RC Planes, Electronics, Power Generation, HMI, and much more. Check my Playlists.

#googlespreadsheet #ESP8266 #altiumdesigner
Category
Audio
Be the first to comment