Google spreadsheet to ESP8266, Google Sheets to ESP8266, data from Google Spreadsheet to ESP8266
HTML-код
- Опубликовано: 14 окт 2024
- Altium Designer:
www.altium.com...
Altium 365:
www.altium.com...
Octopart, components search engine:
octopart.com/
Download circuit diagram and programming:
www.electronic...
Subscribe to my New RUclips Channel, if you want to watch my videos in Hindi/Urdu
/ @letsgetstartedd
ESP32 Cam with ESP8266, google drive, and Google spreadsheet
• ESP32 CAM and ESP8266 ...
Google Sheet and RFID based Time Tracker
• IoT based RFID Attenda...
Watch my previous video on Google Spreadsheet:
• Google Spread Sheet or...
Support me on Patreon and get access to hundreds of projects:
/ 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:
amzn.to/3wb7GUj
Nodemcu ESP8266 WiFi Module:
amzn.to/3sx24l4
ESP32 WiFi + Bluetooth Module
amzn.to/3cDz6wU
DHT11 Temperature and Humidity Module:
amzn.to/2O0YqRF
Soil Moisture Sensor
amzn.to/3zA3aTm
SSD1306 Oled display module
amzn.to/3ba3WNq
5V buzzer
amzn.to/3PApdPj
Other must-have Tools and Components:
Arduino Uno, Nano, Mega, Micro "All types of Arduino Boards":
amzn.to/3fk5OTi
Top Arduino Sensors:
amzn.to/3vZbnfM
Super Starter kit for Beginners
amzn.to/3cq56C5
Top Oscilloscopes
amzn.to/3ctF3d8
Variable Supply:
amzn.to/2PEAqE7
Digital Multimeter:
amzn.to/2QGRPg1
Top Soldering iron kits: "best"
amzn.to/39nqDtb
Top Portable drill machines:
amzn.to/3suQMh7
Jumper Wires:
amzn.to/2NYPEDA
3D printers:
amzn.to/3ruG1dt
CNC Machines:
amzn.to/3cuZWVv
Electronics Accessories:
amzn.to/3sueV7z
Hardware Tools:
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 my Websites
Electronic Clinic:
www.electronic...
Programming Digest:
programmingdig...
Follow me on Instagram:
/ electroniclinic
Follow my Facebook Page Electronic Clinic:
web.facebook.c...
Follow my Facebook Group, Arduino Projects:
/ 190031841821771
Email:
stu_engineering@yahoo.com
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
Great wor ,why you not use the same Sheet page and other nheets in it .
I would like to try it
Which google script id to use in the final arduino sketch, the one from esp8266 to goggle sheet or the othe way around
Your work has helped me a lot, thank you from the Dominican Republic. I use charts and Google sites to display the data, awesome.
I wish there was a way to send you a one time $gift instead of Patreon monthly...
You are using Two Spread Sheets. It possible to use Single Sheet to read Temperature Soil moisture and threshold for Temperature and Threshold for Soil moisture from Single Spread Sheet ?
SuperGreat ! Thank you!!
does sending data to google sheet by esp32 requires root certificate ? i cant send any data to google sheets. i hope you read this
Hai
Wonderful video
Can you give me a favor plz
Aah.. Can i import these type of real time data of csv file in postgresql? If this possible....can i view and get real time updates in postgresql ?
Hi
Was wondering why you use two different workbooks (Google sheets)
Instead of one with sheet1 and sheet2.
Is this possible to combine the two gs scripts..
Will it work or is there a specific reason you use two different sheets/workbooks?
Thanks
I tried one sheet but it didn't work, I was not able to send and receive at the same time.
When I used two sheets it fixed the issue.
@@ElectroniClinic thanks for the explanation.
Great work! can you please make sample of sending hall sensor data ? thanks!
Wonderful kindly teach us, how to record the data with HX711 iot weighing scale that keeps a track of weight daily
You will need to go through the same setup, just use the hx711 , I have many videos on hx711
Please can you tell me why is the Arduino code for device to Google sheet data logging different to that in your 1st video. Thank you
its different because this time i made changes for two way communication.
@@ElectroniClinic thanks for letting me know. Unfortunately whereas the example in the 1st video works with data getting from device to Google Sheet. Only the Google Sheet to device function is working. Data from the device to the Sheet is not working. Regards
Finally resolved . Single and Double Quotes incorrectly converted when using Copy and Paste for Google code from webpage .
@@paulowen9628 would you like to share , what mean copy paste double quote ? I have same issue now
I dont see the link for the arduino code in the description
Actually, we are upgrading the website. That's why all the links are removed.
I connected my app data to the Google sheet,but now i want to send the same google sheet data to node mcu 😢
1st script Error: Syntax error: SyntaxError: Invalid or unexpected token line: 2 file: Code.gs
same with me, are you solving now ?
3rd party not allowing excel sheet any solution for that
thank you very much 🥰
no link to code :(
It's available on electroniclinic.com
I'm sorry but your way to publish code is merely scamming. I downvoted because I'm sick and tired of this way to use youtube
What's the issue? These is a link to the article in the description.