Arduino IDE + ESP32 + Google Sheets | ESP32 with Google Sheets (Writing Data and Reading Data)
HTML-код
- Опубликовано: 21 июл 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.
*********************************************** Наука
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?
Bro you deserve a oscar because you have very beautiful explained everything without speaking any single word. Thank you so much bro❤❤
👍🙂
Mine says "ReferenceError: stripQuotes is not defined (line 27, file "Code")". What does it mean?
Mantap bang gass polll
Makasi 🙂.
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
Great project. Is Arduino web server has a limit to send data. Thanks
Thanks. Can you share sht20 from rs485 tutorial?
good explanation very good example thank you 👍👍
You're welcome 🙂
Thank you sir you do great
You're welcome 🙂.
Thank you very much....
i heard that Google cloud has limit right ??
Excellent video!! One question, can I write data in google sheets only when a button is pushed? Instead of receiving a signal of a sensor every X minutes...
Yes of course.
thanks for the sharing. it help me so much
You're welcome 🙂
wow, thanks for that!
You're welcome🙂
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 mau tanya kalo cara mereset write data di spreadheet kalo udh full gimana ya sistemnya, sebelumnya makasi bang konten nya sangat membantu
Muy bien trabajo❤
👍🙂
Love it
Thank you 🙂
great project thanks for sharing ❤❤❤❤🎉🎉🎉
You're welcome 🙂.
I have tested it and it works perfectly @@utehstr
Maaf mau tanya om, if isnan itu apa artinya yah
Mas mau tanya kalo sheetnya dah penuh kebawah yang di googlesheet, itu gimana mas sistemnya
Maksudnya ?
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.
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 👍🙂
pls tell meHow to install HTTPClient library
You can call this lib without installing
bang izin, kalo pake esp8266 kodenya jalan ga?
Show
Hi @ Uteh Str
getting error
Please help
TypeError: Cannot read properties of undefined (reading 'parameter')
doGet @ Code.gs:4