SMART ATTENDANCE SYSTEM USING RFID AND GOOGLE SHEETS

Abstract

Attendance management is a critical function in educational institutions and organizations, impacting administrative efficiency, performance tracking, and access control. Traditional methods such as manual roll calls, signature sheets, and biometric systems are often timeconsuming, error-prone, and difficult to scale for large groups. To address these challenges, this project proposes a smart attendance system leveraging RFID technology and cloud integration via Google Sheets. The system uses RFID tags and a NodeMCU ESP8266 microcontroller to automatically detect and log the presence of individuals in real-time. Attendance data is transmitted wirelessly over the internet and recorded directly into Google Sheets, enabling remote access, real-time updates, and elimination of manual data entry. A 16x2 LCD display and buzzer provide immediate feedback on successful scans, ensuring user-friendly interaction. The design is costeffective, portable, and easily scalable, making it suitable for classrooms, workplaces, and other environments requiring automated attendance tracking. This approach demonstrates the potential of integrating IoT, RFID, and cloud platforms to enhance efficiency, reduce human errors, and streamline attendance management processes.