Arduino IDE + ESP32 + Google Sheets | ESP32 with Google Sheets (Writing Data and Reading Data)
ฝัง
- เผยแพร่เมื่อ 17 พ.ค. 2024
- ***********************************************
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) : 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 : 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) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : • Arduino | LoLin NodeMC...
- ESP32 Tutorials : • Arduino IDE + ESP32 | ...
- ESP32 CAM Tutorials : • Arduino IDE + ESP32 Ca...
***********************************************
***********************************************
- Download Arduino IDE : www.arduino.cc/en/Main/Software
- Download Notepad++ : notepad-plus-plus.org/downloads/
***********************************************
***********************************************
Reference :
- iotdesignpro.com/articles/esp...
- randomnerdtutorials.com/esp32...
- stackoverflow.com/questions/2...
- stackoverflow.com/questions/7...
- stackoverflow.com/questions/1...
and from several other sources.
*********************************************** - วิทยาศาสตร์และเทคโนโลยี
Bro you deserve a oscar because you have very beautiful explained everything without speaking any single word. Thank you so much bro❤❤
it works very well even google sheets is closed. you do not have to keep it open. hint: to change "Asia" time type "GMT" or "GMT+3" etc.
👍🙂
Good explanation! I'm making a rfid equipment documentor
Can I ask if I can make it not instantaneous, that you need a button to press for it to confirm the scans you've made before going to the excel?
wow, thanks for that!
Great project. Is Arduino web server has a limit to send data. Thanks
Mine says "ReferenceError: stripQuotes is not defined (line 27, file "Code")". What does it mean?
Mantap bang gass polll
Makasi 🙂.
Thanks. Can you share sht20 from rs485 tutorial?
Hi Sir, im trying to send another type of data (string type) but the http says HTTP Status Code : 200
Payload : Ok, unsupported parameter
Hello sir please explain how to make app work like data entry b4a after coding and interface user and sql done please with nox player or with any player
Thank you very much....
Thank you sir you do great
You're welcome 🙂.
good explanation very good example thank you 👍👍
You're welcome 🙂
Love it
Thank you 🙂
thanks for the sharing. it help me so much
You're welcome 🙂
great project thanks for sharing ❤❤❤❤🎉🎉🎉
You're welcome 🙂.
I have tested it and it works perfectly @@utehstr
Hello, it seems not possible to open the code file with notepad ++ v8.5.7. I did another project with HX711 and code files open with no problem...
Ok...problem fixed, thanks
bang izin, kalo pake esp8266 kodenya jalan ga?
Sir, can I have the details of HTTPClient library version, I tried the code but not successful. I got html result for the payload not the "ok, Temperature ....." result, btw httpcode is 200
I am using "HTTPClient" library version 1.2
@@utehstr Thank you for the reply sir, I did not change the access settings, that the issue. Now my project works properly. Thank You.
@@yasaskumarasinghe1830 👍🙂
why i cant include HTTPClient library in my project ? :(( Help me ?
Make sure that you have selected the "ESP32 Dev Module" board in the Arduino IDE.
Mas mau tanya kalo sheetnya dah penuh kebawah yang di googlesheet, itu gimana mas sistemnya
Maksudnya ?
pls tell meHow to install HTTPClient library
You can call this lib without installing
Show
Hi @ Uteh Str
getting error
Please help
TypeError: Cannot read properties of undefined (reading 'parameter')
doGet @ Code.gs:4