Uploaded November 2023 | Updated September 2026, 2 weeks ago
***********************************************
Follow and contact me on Instagram : instagram.com/utehstr
***********************************************
ARDUINO IDE + ESP32 + RFID RC522 Module + Google Sheets (Google Spreadsheet).
Starting RFID-RC522 with ESP32 and Arduino IDE.
Simple attendance system with ESP32, RFID-RC522 and Google Sheets.
Software used :
- Arduino IDE (V1.8.9).
- Arduino Core for The ESP32 (V1.0.6).
- Notepad++ (V8.4.6).
Arduino libraries used :
- MFRC522 by GithubCommunity (V1.4.3)
- LiquidCrystal_I2C (V1.1.4)
Hardware used :
- ESP32 DEVKIT V1.
- RFID RC522 Module.
- LCD 20x4 I2C.
- Tactile Push Button.
- And other equipment such as cables and others.
Timestamp :
00:00 Opening
00:32 Project Preview
02:01 Modules and components used to create this project
02:37 Installation image
02:49 Step 1 - Created Google Sheets Projects and Google Apps Script Projects
03:40 Step 1 - Google Sheets Projects ID
06:18 Step 1 - Google Apps Script (Code)
07:49 Step 1 - Google Apps Script (Deploy)
08:39 Step 1 - Google Apps Script (Web App URL)
08:57 Step 1 - Google Apps Script (Web App URL Test)
10:53 Step 2 - Test the RFID RC522 installation (Code)
11:32 Step 2 - Installed the MFRC522 library
12:43 Step 2 - Test the RFID RC522 installation (Demo)
13:01 Step 3 - Test the LCD 20x4 I2C and Button installation (Code)
13:45 Step 3 - Downloading the LiquidCrystal_I2C library file
14:16 Step 3 - Installed the LiquidCrystal_I2C library
14:55 Step 3 - Test the LCD 20x4 I2C and Button installation (Demo)
15:24 Step 4 - Simple attendance system (Code)
17:37 Step 4 - Simple attendance system (Demo)
24:27 Closing
***********************************************
Download Arduino Code and other files : drive.google.com/file/d/14gRPs1BeH2ti_p4CnU5-SNiQnfkQcicc/view?usp=sharing
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 : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************
***********************************************
- Download Arduino IDE : arduino.cc/en/Main/Software
- Download Notepad++ : notepad-plus-plus.org/downloads
***********************************************
***********************************************
Reference :
- RFID Attendance System using ESP8266 and Google Sheets Version 4 : youtu.be/S3DmT-LmKug?si=_2FIlDZzDmt0fyUv
- rfid attendance v4 : github.com/ahmadlogs/rfid-attendance-v4
- IoT based RFID Attendance system using ESP8266 and Google sheet : youtu.be/2WcPirVmEz0?si=2t_tUnPnNzARAwcy
- RFID RC522 Interfacing with ESP32 : electronicwings.com/esp32/rfid-rc522-interfacing-with-esp32
- How to Find the Last Row of A Single Column in Google Sheets in Apps Script : jsowl.com/find-the-last-row-of-a-single-column-in-google-sheets-in-apps-script
- ESP32 HTTP GET and HTTP POST with Arduino IDE : randomnerdtutorials.com/esp32-http-get-post-arduino
- RFID RC522 Interfacing with ESP32 : electronicwings.com/esp32/rfid-rc522-interfacing-with-esp32
- esp32io.com/tutorials/esp32-rfid-nfc
- stackoverflow.com/a/29546373
- stackoverflow.com/questions/24894648/get-today-date-in-google-apps-script
- stackoverflow.com/a/71341868
- stackoverflow.com/questions/11334296/how-to-get-the-correct-range-to-set-the-value-to-a-cell
and from several other sources.
***********************************************
***********************************************
Follow and contact me on Instagram : instagram.com/utehstr
***********************************************
ARDUINO IDE + ESP32 + RFID RC522 Module + Google Sheets (Google Spreadsheet).
Starting RFID-RC522 with ESP32 and Arduino IDE.
Simple attendance system with ESP32, RFID-RC522 and Google Sheets.
Software used :
- Arduino IDE (V1.8.9).
- Arduino Core for The ESP32 (V1.0.6).
- Notepad++ (V8.4.6).
Arduino libraries used :
- MFRC522 by GithubCommunity (V1.4.3)
- LiquidCrystal_I2C (V1.1.4)
Hardware used :
- ESP32 DEVKIT V1.
- RFID RC522 Module.
- LCD 20x4 I2C.
- Tactile Push Button.
- And other equipment such as cables and others.
Timestamp :
00:00 Opening
00:32 Project Preview
02:01 Modules and components used to create this project
02:37 Installation image
02:49 Step 1 - Created Google Sheets Projects and Google Apps Script Projects
03:40 Step 1 - Google Sheets Projects ID
06:18 Step 1 - Google Apps Script (Code)
07:49 Step 1 - Google Apps Script (Deploy)
08:39 Step 1 - Google Apps Script (Web App URL)
08:57 Step 1 - Google Apps Script (Web App URL Test)
10:53 Step 2 - Test the RFID RC522 installation (Code)
11:32 Step 2 - Installed the MFRC522 library
12:43 Step 2 - Test the RFID RC522 installation (Demo)
13:01 Step 3 - Test the LCD 20x4 I2C and Button installation (Code)
13:45 Step 3 - Downloading the LiquidCrystal_I2C library file
14:16 Step 3 - Installed the LiquidCrystal_I2C library
14:55 Step 3 - Test the LCD 20x4 I2C and Button installation (Demo)
15:24 Step 4 - Simple attendance system (Code)
17:37 Step 4 - Simple attendance system (Demo)
24:27 Closing
***********************************************
Download Arduino Code and other files : drive.google.com/file/d/14gRPs1BeH2ti_p4CnU5-SNiQnfkQcicc/view?usp=sharing
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 : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************
***********************************************
- Download Arduino IDE : arduino.cc/en/Main/Software
- Download Notepad++ : notepad-plus-plus.org/downloads
***********************************************
***********************************************
Reference :
- RFID Attendance System using ESP8266 and Google Sheets Version 4 : youtu.be/S3DmT-LmKug?si=_2FIlDZzDmt0fyUv
- rfid attendance v4 : github.com/ahmadlogs/rfid-attendance-v4
- IoT based RFID Attendance system using ESP8266 and Google sheet : youtu.be/2WcPirVmEz0?si=2t_tUnPnNzARAwcy
- RFID RC522 Interfacing with ESP32 : electronicwings.com/esp32/rfid-rc522-interfacing-with-esp32
- How to Find the Last Row of A Single Column in Google Sheets in Apps Script : jsowl.com/find-the-last-row-of-a-single-column-in-google-sheets-in-apps-script
- ESP32 HTTP GET and HTTP POST with Arduino IDE : randomnerdtutorials.com/esp32-http-get-post-arduino
- RFID RC522 Interfacing with ESP32 : electronicwings.com/esp32/rfid-rc522-interfacing-with-esp32
- esp32io.com/tutorials/esp32-rfid-nfc
- stackoverflow.com/a/29546373
- stackoverflow.com/questions/24894648/get-today-date-in-google-apps-script
- stackoverflow.com/a/71341868
- stackoverflow.com/questions/11334296/how-to-get-the-correct-range-to-set-the-value-to-a-cell
and from several other sources.
***********************************************
