Google Spread Sheet or Google Sheets with ESP8266 Nodemcu for Data Logging, Temp & Hum DHT11, IoT

Altium Designer:

Read Article, download circuit diagram and code:

Subscribe to my New YouTube Channel, if you want to watch my videos in Hindi/Urdu

ESP32 Cam with ESP8266, google drive, and Google spreadsheet

Google Sheet and RFID based Time Tracker

Send data from Google sheets to ESP8266:

Power supply for Nodemcu ESP8266:

Support me on Patreon and get access to hundreds of projects:

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:

Nodemcu ESP8266 WiFi Module:

Other must-have Tools and Components:

Arduino Uno, Nano, Mega, Micro "All types of Arduino Boards":

Top Arduino Sensors:

Super Starter kit for Beginners

Top Oscilloscopes

Variable Supply:

Digital Multimeter:

Top Soldering iron kits: "best"

Top Portable drill machines:

Jumper Wires:

3D printers:

CNC Machines:

Electronics Accessories:

Hardware Tools:

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:

Programming Digest:

Follow me on Instagram:

Follow my Facebook Page Electronic Clinic:

Follow my Facebook Group, Arduino Projects:

Email:

#GoogleSpreadSheet
#NodemcuEsp8266Project
#ESP8266GoogleSheets

[ElectroniClinic]

Send data from Google sheets to ESP8266:

[raybright]

Only one way to comment on this YouTube and that is "EXCELLENT !!!" I'm always wanting better means to log data & Google Sheets is something I've never came across. Now what we want is a App/Example to show live data in graphical form, something better that just spreadsheet graphs, any Ideas most welcome. Again thanks for this example

[tnoten]

I couldn't get the data to the Google spreadsheet. I tried several things, nothing helped. Everything was working oke.
The solution came when I changed the option that everyone could join this projest. You have to choose this when implementing the web app.
So I thing there is a securety issue with Google.
Hope that this helps someone

[PhG]

Nice Sunday morning entertainment ! A great way to learn...

[JashanjotKaur]

Did everything same. Code is working fine. Only problem is humidity value is saved in column C with Temperature value instead of column D. How to make humidity value shift to column D ?

[ambienteinteiro]

in fact the only one that explained how to actually connect dht to google sheets.
My question is: what is the daily limit for sending data to the spreadsheets?
I'm afraid of Google blocking...

[e-yantratechnologies]

it is not working now as google has disabled "allow less secure apps option" since this May. Can you suggest any other option to post to google sheets using nodemcu

[raybright]

I have followed your instructions carefully including from your web site BUT then I try accessing the URL I keep getting an error "Script function not found: doGet"

In AppsScript if I try Run the function that starts as follows (as per your example) :

1. function doGet(e) {
2. Logger.log( JSON.stringify(e) );
3. var result = 'Ok';
4. if (e.parameter == 'undefined') {
5. result = 'No Parameters';
6. }
then rest of code follows....

I get the following error in Execution Log

6:56:25 PM Notice Execution started
6:56:26 PM Info null
6:56:25 PM Error
TypeError: Cannot read property 'parameter' of undefined
doGet @ Code.gs:4

So there is a problem with line 4 BUT I can't see what has gone wrong

Any help appreciated...

[neperic]

hello there,
how to add moisture and ultrasonic sensor along with this code google sheet nodemcu code..

[rvinnyopagongna]

can you adjust the interval, set for example. only the data from every 30th day of the month will be shown.

[suryar]

THANK YOU SO MUCH SIR WE ARE GRATEFUL TO

[oreillyjoe]

Nice video. I have a question. If the module is powered but not connected to wifi etc. can it store data and then dump all data to google sheet after?

[respmedsleep]

Hi there, Can you please show us how to use this for a different sensor type?
Thanks in advance

[musaadejoshuaibuopaluwa]

I truly have learnt a great deal from this tutorial.
Could you please help modify this codes to read and store values in Arduino variable?
I long to see that and thank you so much for your efforts

[zigstaryou]

It’s possible to adjust script so if any value is existing, for example a row have the same data, to now write. So no duplicates of data?

[alphancrewpuk]

How to make google sheet continuously work to save data because it is just limited with row, please give me advice

[tsanilsalsamara]

hello, I can't receive data sent on google sheet. On the serial monitor I get the message "esp8266/Arduino CI has failed" what's wrong?

[lifeisbeautiful]

Can u make with esp8266 in place of nodemcu

[.otienthanh]

I want to send other value from esp8266 to googlesheet. How can I change your code? example I replace temperature by a number from keyboard; humidity replace by value from mass sensor. Help me please.

[jamessalvador]

Can this work using the esp-01s with the Arduino uno r3 instead?