Building your own DIY IoT temperature sensor with an ESP8266 is a great way to get started with IoT projects. With just a few simple components, you can create a sensor that measures temperature and humidity, and automatically sends the data to Google Sheets for logging and analysis.

Overview of the Project

The main components we will use are:

The basic steps are:

  1. Set up the circuit with the ESP8266 and DHT22 sensor.

  2. Write code for the ESP8266 to take readings from the sensor.

  3. Send HTTP requests from the ESP8266 to Google Sheets to log the data.

  4. Create a Google Sheet and connect it to the ESP8266 using the Sheets API.

Circuit Setup and Wiring

The circuit will consist of the ESP8266, the DHT22 sensor, and some basic components like a resistor and capacitor.

Here is how to connect the components:

This forms the basic circuit. The resistor and capacitor help smooth the DHT22 data signal for reliable readings.

Installing Libraries

We need to install the following libraries in the Arduino IDE to communicate with the components:

To install a library, simply go to Sketch > Include Library > Manage Libraries in the Arduino IDE and search for the library name above. Click install to add them.

Programming the ESP8266

With the circuit complete and libraries installed, we can now program the ESP8266 using the Arduino IDE.

Here are the key steps in the code:

  1. Include the required libraries:


include ;

include ;

include ;


  1. Set your WiFi credentials:

const char* ssid = "YOUR_SSID";
const char* password = "YOUR_PASSWORD";

  1. Create a DHT sensor object:

DHT dht(D5, DHT22);

  1. In the setup(), connect to WiFi:

WiFi.begin(ssid, password);

while (WiFi.status() != WL_CONNECTED) {

  1. In the loop(), read the sensor and make an HTTP request:

float humidity = dht.readHumidity();
float temperature = dht.readTemperature();

if (WiFi.status()== WL_CONNECTED) { //Check WiFi connection status

HTTPClient http;

// Build the HTTP request data
String url = "";
String data = "&humidity=" + humidity + "&temperature=" + temperature;


This will continuously read the DHT22 and send readings to the specified URL which we will setup next.

Logging Sensor Data to Google Sheets

To log the sensor data to Google Sheets, we need to:

  1. Create a Google Sheet - Add columns for "temperature" and "humidity".

  2. Publish the sheet for API access.

  3. Get the sheet ID from the URL of the published sheet.

  4. Set up a Google Apps Script that receives the HTTP request and logs it to the sheet.

Here is sample Apps Script code to log the request to the sheet:

function doPost(e) {

var data = JSON.parse(e.postData.contents);

var sheet = SpreadsheetApp.openById('SHEET_ID');

var lastRow = sheet.getLastRow();
sheet.getRange(lastRow+1, 1).setValue(new Date());
sheet.getRange(lastRow+1, 2).setValue(data.humidity);
sheet.getRange(lastRow+1, 3).setValue(data.temperature);

return ContentService.createTextOutput();

This will automatically add the data received to new rows in the sheet!

Now whenever the ESP8266 makes a request, the data will be logged. We can view live charts and graphs in the Google Sheet.


Building an IoT temperature logger with ESP8266 and Google Sheets is easy and inexpensive. With just a few components and some simple code, we can get sensor data logging to the cloud automatically.

This project can be expanded by adding multiple sensors, data visualization, and connecting to cloud platforms like ThingSpeak. The ESP8266 is a versatile chip that enables limitless IoT applications.

Let me know in the comments if you end up building your own ESP8266 temperature logger! I'm always happy to help with any issues.