ESP32 RFID: Google Sheets as a database for rfid cards
Автор: anyboards
Загружено: 2023-04-25
Просмотров: 18377
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
