RFID Attendance System On Google Sheet V1

This report details an RFID attendance system you’ve built using an ESP32 development board, MFRC522 RFID reader module, I2C LCD display, and HC05 Bluetooth module. The system allows users to register their names on RFID cards and subsequently log attendance on a Google Sheet with timestamps.

System Functionality

1. User Registration:

   • A mode switch sets the device to learn mode.
   • The system prompts for a user name, which is then stored on the scanned RFID card.
   • In this process we are connect bluetooth terminal app to connect hardware. All changes can be made via app, hence no pc required. User can add any time many card with this feature.

2. Attendance Recording:

   • The device connects to a predefined Wi-Fi network.
   • In normal mode, the system prompts users to tap their cards.
   • Upon tapping, the user’s name retrieved from the card is displayed on the LCD.
   • Attendance data (name, date, and time) is sent to a designated Google Sheet.

Key Features

• Unlimited RFID Cards: The system can accommodate any number of registered users with unique RFID cards.
• Automatic Timestamps: Attendance logs on the Google Sheet include date and time for each entry.
• Wi-Fi Connectivity: The ESP32 module connects to a Wi-Fi network for seamless data transmission to Google Sheets.

Additional Considerations

• Security: While convenient, consider implementing access control measures to prevent unauthorized users from modifying registered names on cards. Encryption for data transmission to Google Sheets might be another layer of security to explore.
• User Interface: Enhance the user experience by expanding the LCD display to show additional information like registration success/failure messages or attendance confirmation.
• Mobile App Integration: Develop a mobile app (potentially using Bluetooth communication with the HC05 module) to view attendance records or manage user registrations remotely.

Report Conclusion

This project presents a functional RFID attendance system with user registration and data logging to Google Sheets. With further development, the system can be enhanced with improved security, user interface elements, and potential mobile app integration for increased functionality and convenience.