⚡️ Real-time Cloud Logging | 🧠 Smart Automation | 🔐 Secure & Scalable
This project is a complete IoT Attendance System using:
- 📶 ESP32 microcontroller
- 📇 RFID RC522 reader
- 📄 Google Sheets for cloud-based logging
- 🖥️ LCD Display (16x4 I2C)
- 🔌 Wi-Fi integration for real-time updates
Built with no external libraries — only raw SPI, WiFi, and HTTPClient
| RFID Scan | Google Sheet Log | Serial Monitor |
|---|---|---|
 |
 |
 |
- 🔍 RFID-based attendance scanning
- 🌐 ESP32 Wi-Fi connection
- 📄 Google Sheets as cloud storage
- 📟 LCD UID display
- 🛡️ Duplicate prevention and validations
- 🔔 Live updates via Serial Monitor
- 📲 Mobile App (Planned)
- 🔐 Biometric integration (Planned)
- 📊 Admin dashboard with charts (Future)
Welcome to our powerful, real-time attendance management system that uses RFID, ESP32, and Google Sheets for smart logging. Built to eliminate manual processes and reduce human error, this project automates attendance tracking using affordable components and a Wi-Fi connection.
| Component | Description |
|---|---|
| ESP32 Dev Module | Microcontroller with Wi-Fi capability |
| RC522 RFID Reader | For reading RFID cards/tags |
| RFID Cards/Tags | Unique UIDs used for attendance |
| LCD 16x4 (I2C) | Displays UID and Name |
| Breadboard + Wires | For connections |
| USB Type-C Cable | Data-capable, to connect ESP32 to PC |
| Internet Connection | Required for syncing with Google Sheets |
Most of the components were sourced from our college IoT lab with approval from Mr. Shishir Subedi. Additional components were purchased by team members.
- ✅ Scan RFID Card
- 📟 UID displayed on LCD
- ⏱️ UID + Timestamp sent to Google Sheets
- 📊 Attendance stored securely in the cloud
| RC522 Pin | ESP32 Pin | Purpose |
|---|---|---|
| 3.3V | 3.3V | Power Supply |
| GND | GND | Ground |
| RST | D4 | Reset |
| SDA | D5 | SPI Slave Select |
| SCK | D18 | SPI Clock |
| MOSI | D23 | SPI Data Out |
| MISO | D19 | SPI Data In |
| LCD I2C Pin | ESP32 Pin |
|---|---|
| VCC | VIN |
| GND | GND |
| SDA | D21 |
| SCL | D22 |
- 🧰 Arduino IDE
- 📄 Google Account with access to Google Sheets & Apps Script
- 📦 ESP32 board package in Arduino IDE
- 🔌 Connect ESP32 using USB Type-C.
- 🧠 Upload code via Arduino IDE.
- 📄 Create a Google Sheet with headers:
UID,Timestamp. - 🧰 Deploy Apps Script Web App (set access to
Anyone). - ✅ Scan card → Logs attendance → Confirms via Serial Monitor.
- On card scan, UID appears on LCD.
- Sheet logs timestamp + UID in real-time.
- Monitor shows:
Data sent to Google Sheet ✅
Troubleshooting: Check wiring, power (3.3V), Wi-Fi credentials, Apps Script permissions.
💡 Suggested improvements:
- 🔊 Buzzer/LED feedback on scan
- 🧠 AI for smart attendance tracking
- 📱 Mobile app for real-time alerts
- 🔐 Biometric fusion (Face/Fingerprint + RFID)
- 🧾 Automatic attendance reports to email
- 🏫 Smart Campus integration (library, labs, etc.)
- ⏱️ Reduced attendance time
- ❌ Eliminated proxy marking
- 💾 Reliable cloud-based data storage
- 💰 Budget-friendly and scalable
- 🔁 Reusable for schools, colleges, offices
The RFID Attendance System revolutionizes traditional attendance marking. It’s fast, efficient, scalable, and secure. From hardware wiring to Google Sheets integration — this system delivers a modern attendance solution ready for 2025 and beyond.
- 🧠 Supervised by: Shishir Subedi
| 🙋♂️ Name | 💼 Role |
|---|---|
| Sameer Sah | 🚀 Project Lead & Developer |
| Anshumala Bhandari | 🔧 Developer & Researcher |
| Bibhuti Sigdel | 📝 Developer & Documentation |
| Sanshree Shrestha | 🔍 Research & Data Handling |
| Shraddha Budhathoki | 🎨 UI/UX Designer & Report Writer |
| Sagun Budhathoki | 🧪 Assistant Developer & Tester |
This project is open-source under the MIT License.
This project uses code and instructions originally created by UtehStr.
The documentation and additional features are developed independently by the contributors of this repo.