Uploaded October 2023 | Updated September 2026, 2 weeks ago

---

***********************************************
Contact me via Instagram : instagram.com/utehstr
***********************************************

ARDUINO IDE + ESP32 + Google Sheets (Google Spreadsheet).

ESP32 with Google Sheets (Writing Data and Reading Data).

Communication between ESP32 uses Google Sheets.

Software used :
- Arduino IDE (V1.8.9).
- Arduino Core for The ESP32 (V1.0.6).
- Notepad++ (V8.4.6).

Arduino libraries used :
- DHT sensor library (V1.3.5) : Install via "Manage Libraries" or "Library Manager" on the Arduino IDE.
- Adafruit Unified Sensor (V1.0.3) : Install via "Manage Libraries" or "Library Manager" on the Arduino IDE.
- LiquidCrystal_I2C (V1.1.4) : github.com/johnrickman/LiquidCrystal_I2C

Hardware used :
- ESP32 DEVKIT V1.
- DHT11 sensor.
- Rocker Switch 2 PIN.
- LCD 16x2 I2C.
- LED.
- Resistor 330 ohm.
- And other equipment such as cables and others.

Timestamp :
00:00 Opening
00:29 Project Preview
01:44 Step 1 - Created Google Sheets Projects and Google Apps Script Projects
02:27 Step 1 - Google Sheets Projects ID
06:58 Step 1 - Google Apps Script (Code)
08:04 Step 1 - Google Apps Script (Deploy)
08:47 Step 1 - Google Apps Script (Web App URL)
09:11 Step 1 - Google Apps Script (Web App URL Test Write Data to Google Sheets)
11:13 Step 1 - Google Apps Script (Web App URL Test Read Data from Google Sheets)
11:51 Step 2 - The ESP32 writes data to Google Sheets
11:57 Step 2 - Installation ESP32, DHT11 and Switches (Writing Data to Google Sheets)
12:03 Step 2 - Test Installation ESP32, DHT11 and Switches
15:08 Step 2 - The ESP32 writes data to Google Sheets (Code)
17:56 Step 2 - The ESP32 writes data to Google Sheets (Demo)
18:56 Step 3 - The ESP32 reads data from Google Sheets
19:02 Step 3 - Installation ESP32, LCD 16x2 I2C and LEDs (Reading Data from Google Sheets)
19:07 Step 3 - Test Installation ESP32, LCD 16x2 I2C and LEDs
21:09 Step 3 - The ESP32 reads data from Google Sheets (Code)
23:10 Step 3 - The ESP32 reads data from Google Sheets (Demo)
24:08 Communication between ESP32 uses Google Sheets
25:37 Closing

***********************************************
Download Arduino Code and other files : drive.google.com/file/d/1650fl6l9afs2_QvLtxjDkTIP77LD9SM7/view?usp=sharing

The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
***********************************************

SORRY IF MY ENGLISH IS CONFUSING, I USE AN ONLINE TRANSLATOR.

THANKS FOR WATCHING & DON'T FORGET TO LIKE , SHARE, COMMENT AND SUBSCRIBE.

***********************************************
For other video tutorials on this channel, please see this playlist:

- Basic4Android (B4A) Tutorials : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************

***********************************************
- Download Arduino IDE : arduino.cc/en/Main/Software
- Download Notepad++ : notepad-plus-plus.org/downloads
***********************************************

***********************************************
Reference :
- iotdesignpro.com/articles/esp32-data-logging-to-google-sheets-with-google-scripts?page=0
- randomnerdtutorials.com/esp32-http-get-post-arduino
- stackoverflow.com/questions/24894648/get-today-date-in-google-apps-script
- stackoverflow.com/questions/71341454/apps-script-get-a-timestamp-from-a-cell-containing-a-date-and-a-cell-containg
- stackoverflow.com/questions/11334296/how-to-get-the-correct-range-to-set-the-value-to-a-cell

and from several other sources.
***********************************************