Sending DHT11 Temperature and Humidity Data from NodeMCU to Google Sheet
CODE LINK:
https://docs.google.com/document/d/1g...
Library file link:
https://drive.google.com/file/d/1KJgy...
This project demonstrates how to send temperature and humidity data from a DHT11 sensor connected to a NodeMCU (ESP8266) module directly to a Google Sheet for real-time monitoring and logging. The system utilizes the NodeMCU’s Wi-Fi capability to connect to the internet and Google Apps Script API endpoints, enabling seamless data transfer without the need for an intermediate server.
The DHT11 sensor measures the ambient temperature (°C) and humidity (%), and the NodeMCU processes this data. Using an HTTPS request, the microcontroller sends the values to a preconfigured Google Apps Script web app URL linked to a Google Sheet. Each new reading is appended as a row in the sheet with a timestamp, allowing users to create a live IoT dashboard for environmental monitoring.
This setup is useful for:
Home automation (monitoring room climate).
Agriculture & greenhouses (tracking humidity and temperature for crops).
Educational IoT projects (real-time cloud data logging).
DIY weather stations (collecting and analyzing environmental data).
By combining low-cost hardware (NodeMCU + DHT11) with free cloud tools (Google Sheets + Google Apps Script), this project provides a simple, scalable, and cost-effective IoT solution for logging and visualizing sensor data online.