RFID Attendance System on Google Sheet with SMS

RFID Attendance System with ESP32 and Google Sheets

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.

• 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 & mobile number retrieved from the card is displayed on the LCD.
  • Attendance data (name, date, and time) is sent to a designated Google Sheet. Device will also send sms on that number which is retrived from rfid card.
    

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.