ESP32 RFID: Google Sheets as a database for rfid cards

This is a tutorial video on how to create your own free attendance system using Google Sheets and ESP32 The project goal is to create a free attendance system using an ESP32 microcontroller, a card reader, and Google Sheets. The system allows users to swipe their ID cards, which are then checked against a Google Sheet containing a list of authorized users. If the user is authorized, their name, access type, and a customized message are displayed on an LCD screen, and a beep sound is played. The system also logs the attendance data in a Google Sheet, which can be viewed and analyzed later. The project is designed to be easy to implement and can be customized to suit different needs. Source code: https://github.com/unreeeal/ESP32/tre... The links for the required libraries are included in the Arduino code Here's a list of components you need Esp32 board https://ali.pub/6okh38 Display 1602 + i2c https://ali.pub/6okh3t RFID RC522 reader https://ali.pub/6okh4e Piezo Buzzer https://ali.pub/6okh5k Google account Timestamps: 00:00 Intro 00:09 Explaining the project goal 00:23 Connection scheme 00:24 Preparing google sheets part 02:18 Preparing arduino part 02:38 Registering card in system