📅 17 Mei 2026 | ⏱ 5 menit baca | 👤 SUGENK WAVE
📊 Kirim Data Sensor ESP32 ke Google Sheets
ESP32Google SheetsIoTLogging
Ingin mencatat data sensor ESP32 ke spreadsheet? Dengan Google Apps Script, lo bisa kirim data suhu, kelembaban, atau soil moisture langsung ke Google Sheets. Cocok untuk greenhouse monitor atau weather station.
Membuat Web App di Google Apps Script
Buka script.google.com, buat project baru, paste kode ini:
function doPost(e) {
var sheet = SpreadsheetApp.openById("SHEET_ID").getSheetByName("Data");
var data = JSON.parse(e.postData.contents);
sheet.appendRow([new Date(), data.suhu, data.humidity, data.soil]);
return ContentService.createTextOutput("OK");
}
Deploy sebagai Web App → Execute as "Me", Who has access → "Anyone". Copy URL endpoint-nya.
Kode ESP32 untuk HTTP POST
#include <WiFi.h>
#include <HTTPClient.h>
const char* ssid = "NAMA_WIFI_ANDA";
const char* password = "PASSWORD_WIFI_ANDA";
void setup() {
Serial.begin(115200);
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
Serial.println("WiFi connected");
}
void loop() {
if (WiFi.status() == WL_CONNECTED) {
HTTPClient http;
http.begin("https://script.google.com/macros/s/ID_ANDA/exec");
http.addHeader("Content-Type", "application/json");
String payload = "{\"suhu\":25.5,\"humidity\":68,\"soil\":1850}";
int httpCode = http.POST(payload);
if (httpCode > 0) {
Serial.println("Data terkirim!");
}
http.end();
}
delay(60000); // kirim setiap 1 menit
}
💡 Lo bisa ganti payload dengan data sensor real (DHT22, soil moisture, dll). Google Sheets bakal auto-record tiap kiriman data.