***********************************************
Contact me via Instagram :   / 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) : https://github.com/johnrickman/Liquid...

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 : https://drive.google.com/file/d/1650f...

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 :    • Basic4Android (B4A) | Hello World  
Electronics Tutorials :    • 3 LED Flip Flop  
Arduino Tutorials :    • Arduino | Scrolling Text Using MAX721...  
Great Cow Basic Tutorials :    • Great Cow BASIC with Arduino Uno For ...  
Bascom Avr Tutorials :    • Bascom Avr | How to Set Up & Program ...  
VB .NET Tutorials :    • Visual Basic .NET  |  Real Time Chart...  
LoLin NodeMCU V3 ESP12E ESP8266 Tutorials :    • Arduino | LoLin NodeMCU V3 ESP8266 wi...  
ESP32 Tutorials :    • Arduino IDE + ESP32 | Getting Started...  
ESP32 CAM Tutorials :    • Arduino IDE + ESP32 Cam + PIR Motion ...  
***********************************************

***********************************************
Download Arduino IDE : https://www.arduino.cc/en/Main/Software
Download Notepad++ : https://notepadplusplus.org/downloads/
***********************************************

***********************************************
Reference :
https://iotdesignpro.com/articles/esp...
https://randomnerdtutorials.com/esp32...
https://stackoverflow.com/questions/2...
https://stackoverflow.com/questions/7...
https://stackoverflow.com/questions/1...

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