Arduino IDE + ESP32 + Google Sheets | ESP32 with Google Sheets (Writing Data and Reading Data)

Рет қаралды 26,805

Күн бұрын

***********************************************
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.
***********************************************

Пікірлер: 49

@ilikememes1402 3 ай бұрын

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?

@HKaynarTR 3 ай бұрын

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.

@utehstr 3 ай бұрын

👍🙂

@andrivie579 9 ай бұрын

Mantap bang gass polll

@utehstr 9 ай бұрын

Makasi 🙂.

@johnbrianalmazan6522 4 ай бұрын

Mine says "ReferenceError: stripQuotes is not defined (line 27, file "Code")". What does it mean?

@BharaniDharan-ne4ql 4 ай бұрын

Thank you very much....

@agrikola5986 9 ай бұрын

Thank you sir you do great

@utehstr 9 ай бұрын

You're welcome 🙂.

@okoman90 8 ай бұрын

good explanation very good example thank you 👍👍

@utehstr 8 ай бұрын

You're welcome 🙂

@dhavalpatel1025 2 ай бұрын

Bro you deserve a oscar because you have very beautiful explained everything without speaking any single word. Thank you so much bro❤❤

@utehstr 2 ай бұрын

👍🙂

@larintube 4 ай бұрын

Great project. Is Arduino web server has a limit to send data. Thanks

@Jossicalal 9 ай бұрын

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

@infraseis 7 ай бұрын

Thanks. Can you share sht20 from rs485 tutorial?

@juanjosemelguizoramirez88 5 ай бұрын

Hi Sir, im trying to send another type of data (string type) but the http says HTTP Status Code : 200 Payload : Ok, unsupported parameter

@widisn286 6 ай бұрын

Love it

@utehstr 6 ай бұрын

Thank you 🙂

@martingerhardsoos 2 ай бұрын

wow, thanks for that!

@utehstr 2 ай бұрын

You're welcome🙂

@user-hv1kj1my4d 6 ай бұрын

thanks for the sharing. it help me so much

@utehstr 6 ай бұрын

You're welcome 🙂

@angaro142 Ай бұрын

Muy bien trabajo❤

@utehstr Ай бұрын

👍🙂

@iddddd900 Ай бұрын

i heard that Google cloud has limit right ??

@ibrahimboudjenah598 9 ай бұрын

great project thanks for sharing ❤❤❤❤🎉🎉🎉

@utehstr 9 ай бұрын

You're welcome 🙂.

@ibrahimboudjenah598 9 ай бұрын

I have tested it and it works perfectly @@utehstr

@_D_D_FaizArgaFirmansyah Ай бұрын

bang mau tanya kalo cara mereset write data di spreadheet kalo udh full gimana ya sistemnya, sebelumnya makasi bang konten nya sangat membantu

@larintube 6 ай бұрын

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...

@larintube 6 ай бұрын

Ok...problem fixed, thanks

@Guilherme-sy2mv Ай бұрын

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...

@utehstr Ай бұрын

Yes of course.

@maniacjoe3088 2 ай бұрын

Maaf mau tanya om, if isnan itu apa artinya yah

@akmalmuis5898 3 ай бұрын

bang izin, kalo pake esp8266 kodenya jalan ga?

@RikiYoutube-sd8ub 9 ай бұрын

Mas mau tanya kalo sheetnya dah penuh kebawah yang di googlesheet, itu gimana mas sistemnya

@utehstr 9 ай бұрын

Maksudnya ?

@luannguyenvan916 6 ай бұрын

why i cant include HTTPClient library in my project ? :(( Help me ?

@utehstr 6 ай бұрын

Make sure that you have selected the "ESP32 Dev Module" board in the Arduino IDE.

@yasaskumarasinghe1830 8 ай бұрын

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

@utehstr 8 ай бұрын

I am using "HTTPClient" library version 1.2

@yasaskumarasinghe1830 8 ай бұрын

@@utehstr Thank you for the reply sir, I did not change the access settings, that the issue. Now my project works properly. Thank You.

@utehstr 8 ай бұрын

@@yasaskumarasinghe1830 👍🙂