Google Spread Sheet or Google Sheets with ESP8266 Nodemcu for Data Logging, Temp & Hum DHT11, IoT
33.7 هزار بار بازدید -
2 سال پیش
-
Altium Designer:
Altium Designer:
https://www.altium.com/yt/electronicl...
Read Article, download circuit diagram and code:
https://www.electroniclinic.com/googl...
Subscribe to my New YouTube 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 with Google she...
Google Sheet and RFID based Time Tracker
IoT based RFID Attendance system usin...
Send data from Google sheets to ESP8266:
Google spreadsheet to ESP8266, Google...
Power supply for Nodemcu ESP8266:
Nodemcu ESP8266: Nodemcu Power Supply...
Support me on Patreon and get access to hundreds of projects:
Patreon: ElectroniClinic
Project Description:
********************
So far I have covered majority of the IoT platforms for monitoring different types of sensors and for controlling different types of electrical devices. Usually for the real-time sensors monitoring I display the sensors values on the Gauges and for this I mostly use Blynk IoT platform, Ubidots, and Thingspeak etc.
In majority of the cases only displaying the sensor values is not enough. There are guys who are interested in the data logging for the post analysis. The sensors data logging service offered by majority of the IoT platforms isn’t as impressive as offered by the Google which is absolutely free, highly secured, fast, and reliable. In this Episode, I will be using Nodemcu ESP8266 WiFi module with Google Sheets for the sensor data logging. Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.
Since this is my first time using the Google sheets for the Sensors data logging; so, I will try my level best to explain each and every detail. I will be using DHT11 Temperature and Humidity sensor as this is the most basic and easily available sensor. Once you learn how to send the temperature and humidity values to the Google Spreadsheet then you can replace this sensor with any other sensor of your choice. So, before, I am going to explain the circuit diagram, programming, and how to get started with the Google sheets, first let’s watch this project in action.
First I am going to open my Google sheets App. Next, I am going to open the Dht11 monitoring Spreadsheet which I am using for logging the temperature and humidity values along with the date and time information. These are all the previous values, as I have been testing it for hours and it’s working just perfectly. Let’s power up the Nodemcu ESP8266 WiFi Module for real-time sensor monitoring and data logging.
I am using my homemade 4S lithium-Ion battery pack for powering up my Nodemcu ESP8266 Development board. I will provide a link in the description if you want to make the same battery pack… You can see I just received the new data. The temperature and humidity values are stored along with the date and time information. For the demonstration purposes I am using a short delay in the programming, if you want you can increase the delay time. It’s totally up to you whether you want to send data after every 1 minute or 10 minutes, or 1 hour...
***************
Amazon Purchase links:
*****************
DHT11 Temperature and Humidity Module:
https://amzn.to/2O0YqRF
Nodemcu ESP8266 WiFi Module:
https://amzn.to/3sx24l4
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 my Websites
Electronic Clinic:
https://www.electroniclinic.com/
Programming Digest:
https://programmingdigest.com/
Follow me on Instagram:
Instagram: electroniclinic
Follow my Facebook Page Electronic Clinic:
https://web.facebook.com/profile.php?...
Follow my Facebook Group, Arduino Projects:
Facebook: 190031841821771
Email:
[email protected]
#GoogleSpreadSheet
#NodemcuEsp8266Project
#ESP8266GoogleSheets
https://www.altium.com/yt/electronicl...
Read Article, download circuit diagram and code:
https://www.electroniclinic.com/googl...
Subscribe to my New YouTube 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 with Google she...
Google Sheet and RFID based Time Tracker
IoT based RFID Attendance system usin...
Send data from Google sheets to ESP8266:
Google spreadsheet to ESP8266, Google...
Power supply for Nodemcu ESP8266:
Nodemcu ESP8266: Nodemcu Power Supply...
Support me on Patreon and get access to hundreds of projects:
Patreon: ElectroniClinic
Project Description:
********************
So far I have covered majority of the IoT platforms for monitoring different types of sensors and for controlling different types of electrical devices. Usually for the real-time sensors monitoring I display the sensors values on the Gauges and for this I mostly use Blynk IoT platform, Ubidots, and Thingspeak etc.
In majority of the cases only displaying the sensor values is not enough. There are guys who are interested in the data logging for the post analysis. The sensors data logging service offered by majority of the IoT platforms isn’t as impressive as offered by the Google which is absolutely free, highly secured, fast, and reliable. In this Episode, I will be using Nodemcu ESP8266 WiFi module with Google Sheets for the sensor data logging. Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.
Since this is my first time using the Google sheets for the Sensors data logging; so, I will try my level best to explain each and every detail. I will be using DHT11 Temperature and Humidity sensor as this is the most basic and easily available sensor. Once you learn how to send the temperature and humidity values to the Google Spreadsheet then you can replace this sensor with any other sensor of your choice. So, before, I am going to explain the circuit diagram, programming, and how to get started with the Google sheets, first let’s watch this project in action.
First I am going to open my Google sheets App. Next, I am going to open the Dht11 monitoring Spreadsheet which I am using for logging the temperature and humidity values along with the date and time information. These are all the previous values, as I have been testing it for hours and it’s working just perfectly. Let’s power up the Nodemcu ESP8266 WiFi Module for real-time sensor monitoring and data logging.
I am using my homemade 4S lithium-Ion battery pack for powering up my Nodemcu ESP8266 Development board. I will provide a link in the description if you want to make the same battery pack… You can see I just received the new data. The temperature and humidity values are stored along with the date and time information. For the demonstration purposes I am using a short delay in the programming, if you want you can increase the delay time. It’s totally up to you whether you want to send data after every 1 minute or 10 minutes, or 1 hour...
***************
Amazon Purchase links:
*****************
DHT11 Temperature and Humidity Module:
https://amzn.to/2O0YqRF
Nodemcu ESP8266 WiFi Module:
https://amzn.to/3sx24l4
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 my Websites
Electronic Clinic:
https://www.electroniclinic.com/
Programming Digest:
https://programmingdigest.com/
Follow me on Instagram:
Instagram: electroniclinic
Follow my Facebook Page Electronic Clinic:
https://web.facebook.com/profile.php?...
Follow my Facebook Group, Arduino Projects:
Facebook: 190031841821771
Email:
[email protected]
#GoogleSpreadSheet
#NodemcuEsp8266Project
#ESP8266GoogleSheets
2 سال پیش
در تاریخ 1400/11/24 منتشر شده
است.
33,753
بـار بازدید شده