Project Hub /IoT & Connected Devices/Telemetry & Remote Logging/Log Temperature Sensor Data to Google Sheet using NodeMCU ESP8266

Intermediate

ESP8266

₹500 – ₹1,500

3 – 6 Hours

Complete Kit

Log Temperature Sensor Data to Google Sheet using NodeMCU ESP8266

Learn how to read temperature and humidity data using a DHT11 sensor and automatically log it to a Google Sheet over Wi-Fi using a NodeMCU ESP8266.

Originally published on CircuitDigest

View original tutorial

Parts You'll Need

This project is sourced from another site, not written by us — this list is our best match of their components against what we stock, not a verified bill of materials. Always check the original blog (linked above) for the actual parts list before buying.

NodeMCU ESP8266 WIFI development board based on CP2102 Rs. 660.00
DHT11 Temperature and Humidity Sensor Module for Arduino Raspberry Pi Rs. 89.00
Jumper Wire 10 Pin Male To Male 20cm Rs. 45.00
400 Points Mini Solderless Prototype PCB Breadboard High Quality Rs. 89.00
MB102 Adjustable Breadboard Power Supply Module (3.3V & 5V) for Arduino & Raspberry Pi Rs. 139.00
Jumper Wire 10 Pin Male To Female 20cm Rs. 45.00

Selected: Rs. 0.00

Browse all components

How It Works

This system operates by interfacing a DHT11 temperature and humidity sensor with a NodeMCU ESP8266 microcontroller module via jumper wires. The DHT11 utilizes a capacitive humidity sensor and a thermistor to measure the surrounding ambient air, outputting a digital signal containing the environmental data. The NodeMCU ESP8266, which features an integrated Wi-Fi transceiver, reads this digital data through one of its general-purpose input/output (GPIO) pins using custom firmware written in the Arduino IDE. Once the NodeMCU acquires the temperature and humidity readings, it connects to a local wireless network. It then transmits the sensor data over the internet using an HTTP request or API call targeted at a custom Google Apps Script endpoint. This Google Apps Script acts as a bridge, receiving the incoming payload and automatically appending a new row containing the timestamp, temperature, and humidity directly into a designated Google Sheet for persistent cloud storage and logging.

Why Build This

Implement an automated remote environmental logging station suitable for smart homes, greenhouses, server rooms, and scientific laboratories.

Gain practical undergraduate-level experience bridging IoT hardware directly to cloud-based data repositories without relying on paid third-party dashboard services.

Learn how to program microcontrollers to handle Wi-Fi communication, network stack operations, and cloud API integration.

Real-World Application

Useful for remote environmental monitoring in smart homes, greenhouses, server rooms, and scientific laboratories.

Skills You'll Learn

Wi-Fi networking and HTTP client requests

digital sensor interfacing

cloud data logging with Google Apps Script

microcontroller firmware development

Safety Precautions

No specific precautions noted for this build — always follow general electronics safety practices.

Technology Tags

ESP8266

DHT11

WI-FI

GOOGLE SHEETS

GOOGLE APPS SCRIPT

IOT

DATA LOGGING

Frequently Asked Questions

Can I use a different microcontroller, like an Arduino Uno, instead of the NodeMCU ESP8266?

An Arduino Uno lacks built-in Wi-Fi capabilities, so it cannot directly send data to a Google Sheet over the internet without adding an extra network shield or module. The NodeMCU ESP8266 is specifically chosen because of its integrated Wi-Fi.

How does the NodeMCU communicate with Google Sheets without a paid server?

The project uses a free Google Apps Script web app URL. The NodeMCU sends an HTTP GET or POST request to this URL, and the script handles inserting the data into your Google Sheet.

Do I need to leave my computer running for the data logging to work?

No, once the code is successfully uploaded to the NodeMCU via the Arduino IDE, the microcontroller runs independently. As long as it is powered via USB or an external power supply and remains connected to your Wi-Fi network, it will continue to log data.

Gallery

This page is part of Kitkraft's Project Hub — a curated collection of electronics & robotics projects gathered from the maker community to help students and hobbyists discover and learn to build. Kitkraft does not claim authorship of the original project, and makes no representation as to the accuracy, completeness or safety of third-party source material. The summary and "How It Works" explanation above are AI-generated, rewritten with reference to the original tutorial — not a reproduction of it. Full credit and a direct link to the original source are provided above. If you're the original creator and have a concern about how your work is represented here, please contact us and we'll address it promptly.

Kitkraft Project Hub — curated from the maker community, credited at the source.

PRJ-00101