How to Send ESP32 Sensor Data to Google Sheets (2026) 

Updated: December 30, 2025

This setup is:

• Free
• Reliable
• No Firebase
• No OAuth
• No paid APIs

If you just want a clean Google Sheet logging your ESP32 sensor data, this is one of the simplest and most stable methods available today.

How This Works

Here’s the flow I’m using:

1. ESP32 reads sensor data
2. ESP32 connects to Wi-Fi
3. Every 1 hour, ESP32 sends an HTTP POST request
4. Google Apps Script receives the data
5. The data is appended to Google Sheets

That’s it.

What I’m Using

Hardware

• ESP32 (any variant works)
• Any sensor (DHT22, DS18B20, analog sensor, etc.)

Software & Accounts

• Arduino IDE
• Google account
• Internet connection

Step 1: Create the Google Sheet

1. Go to Google Sheets
2. Click Blank
3. Rename the file (I use something like ESP32 Sensor Log)
4. Add these headers in Row 1:  Timestamp | Temperature | Humidity | Device_ID

You can add more columns later if you want more sensors.

Step 2: Create the Google Apps Script

1. Inside your Google Sheet, click
   Extensions → Apps Script
2. Delete everything inside the editor
3. Paste this code:

   function doPost(e) {
     try {
       const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
       const data = JSON.parse(e.postData.contents);
   
       sheet.appendRow([
         new Date(),
         data.temperature,
         data.humidity,
         data.device_id
       ]);
   
       return ContentService
         .createTextOutput("OK")
         .setMimeType(ContentService.MimeType.TEXT);
   
     } catch (err) {
       return ContentService
         .createTextOutput("ERROR: " + err)
         .setMimeType(ContentService.MimeType.TEXT);
     }
   }
   

4. Click Save
5. Name the project (I usually call it ESP32 Sensor Log )

Step 3: Deploy the Script as a Web App

1. Click Deploy → New deployment
2. Select Web app
3. Set the options:
   • Execute as: Me
   • Who has access: Anyone
4. Click Deploy
5. Authorize permissions
6. Copy the Web App URL

I’ll use this URL in the ESP32 code.

Step 4: ESP32 Arduino Code (Hourly Upload)

Libraries I’m Using

These are already included with ESP32 Arduino core:

• WiFi.h
• HTTPClient.h

Example ESP32 Code

#include <WiFi.h>
#include <HTTPClient.h>

const char* ssid = "YOUR_WIFI_NAME";
const char* password = "YOUR_WIFI_PASSWORD";

const char* serverUrl =
  "https://script.google.com/macros/s/YOUR_SCRIPT_ID/exec";

unsigned long lastSend = 0;
const unsigned long interval = 3600000; // 1 hour

void setup() {
  Serial.begin(115200);

  WiFi.begin(ssid, password);
  Serial.print("Connecting to WiFi");

  while (WiFi.status() != WL_CONNECTED) {
    delay(500);
    Serial.print(".");
  }

  Serial.println("\nWiFi connected");
}

void loop() {
  if (millis() - lastSend >= interval) {
    lastSend = millis();
    sendData();
  }
}

void sendData() {
  if (WiFi.status() == WL_CONNECTED) {
    HTTPClient http;
    http.begin(serverUrl);
    http.addHeader("Content-Type", "application/json");

    float temperature = 25.4; // replace with sensor read
    float humidity    = 60.2; // replace with sensor read

    String json =
      "{"
      "\"temperature\":" + String(temperature) + ","
      "\"humidity\":" + String(humidity) + ","
      "\"device_id\":\"ESP32_01\""
      "}";

    int responseCode = http.POST(json);
    Serial.println("HTTP Response: " + String(responseCode));

    http.end();
  }
}

esp_sleep_enable_timer_wakeup(3600ULL * 1000000ULL);
esp_deep_sleep_start();