ESP32 + Google Sheets | Writing Data to Google sheets using ESP32 | Arduino & Micropython

In this video, I’ll show you how to send temperature and humidity data from an ESP32 to Google Sheets using both the Arduino IDE and MicroPython. We’ll use the DHT22 sensor to capture the data, and I’ll guide you through the process of connecting your ESP32 to a Google Apps Script Web App, enabling you to log sensor data in real-time directly to your Google Sheet.

We'll cover:

✅ Setting up your Google Sheets and Google Apps Script to receive data.
✅ Writing data to Google Sheets from ESP32.
✅ Using NTP (Network Time Protocol) to add timestamps.
✅ Working with push buttons to control when data is sent.
✅ Handling the data in JSON format for efficient communication.

What You'll Learn:
✅Sending Sensor Data: Learn how to append and replace rows in Google Sheets using HTTP POST requests from the ESP32.
✅ Real-Time Timestamps: Use the NTP client to fetch and send accurate time information along with sensor readings.
✅ Push Buttons: We’ll demonstrate how to send data on button press and track the button state.
✅ Working with JSON: Understand how to structure and send data using JSON to communicate with web services like Google Apps Script.

Hardware Used:
✅ ESP32 Development Board
✅ DHT22 Sensor (Temperature & Humidity)
✅ Push Buttons

00:00 Introduction
00:30 ESP32 with google sheets (3 scenarios)
00:50 Setting up google sheet to receive data
01:17 Explanation of function used in google sheets
02:48 deploying a function in google sheets
03:44 Formatting google sheet to receive data
04:23 Wokwi creating a new project
04:57 Making Circuit (Interfacing DHT22 with ESP32)
06:05 Installing libraries
06:25 ESP32 with Google sheets using Arduino IDE (Code)
10:11 Sending data to Google sheets using ESP32 and Arduino IDE (Appending)
10:36 Changing the NTP client Time format (UTC to GMT+2)
11:30 Sending data to Google sheets using ESP32 and Arduino IDE (Replacing)
12:06 Sending data to Google sheets using ESP32 and Arduino IDE by pressing button
13:10 ESP32 with Google sheets using Micropython setup
13:35 ESP32 with Google sheets using Micropython (code)
15:42 Sending data to Google sheets using ESP32 and Micropython by pressing button
16:15 Sending data to Google sheets using ESP32 and Micropython (Appending)
16:48 Sending data to Google sheets using ESP32 and Micropython (replacing)
17:05 Final comments

Code & Resources:

Don’t forget to LIKE the video if it helps, and SUBSCRIBE to High Voltages for more content on ESP32, Arduino, IoT, and other cool projects!

#esp32 #googlesheets #arduino

[danielarevalo]

I can't find the HTTPClient library, do you have any repository?

[SamialWilliamHarris]

on my physical esp 32 its showing 404 ereor for some reason plz help

[Brighto_]

Why can't I do it according to the code you provided?
The code has this result

rst:0x1 (POWERON_RESET), boot:0x13 (SPI_FAST_FLASH_BOOT)
configsip: 0, SPIWP:0xee
clk_drv:0x00, q_drv:0x00, d_drv:0x00, cs0_drv:0x00, hd_drv:0x00, wp_drv:0x00
mode:DIO, clock div:2
load:0x3fff0030, len:1156
load:0x40078000, len:11456
ho 0 tail 12 room 4
load:0x40080400, len:2972
entry 0x400805dc
Connecting to WiFi...
Connecting to WiFi...
Connected to WiFi