*********************************************** Contact me via Instagram : *********************************************** 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 ( ). - Arduino Core for The ESP32 ( ). - Notepad++ ( ). Arduino libraries used : - DHT sensor library ( ) : Install via "Manage Libraries" or "Library Manager" on the Arduino IDE. - Adafruit Unified Sensor ( ) : Install via "Manage Libraries" or "Library Manager" on the Arduino IDE. - 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 : The code file is saved in the .rar file format. I created a .rar file using Winrar , 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 : - Electronics Tutorials : - Arduino Tutorials : - Great Cow Basic Tutorials : - Bascom Avr Tutorials : - VB .NET Tutorials : - LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : - ESP32 Tutorials : - ESP32 CAM Tutorials : *********************************************** *********************************************** - Download Arduino IDE : - Download Notepad++ : *********************************************** *********************************************** Reference : - - - - - and from several other sources. ***********************************************