SmartAttendence
System
Node.js • Express • Google Sheets API • Google Drive API • ExcelJS
SmartAttendence is a comprehensive, Express-based attendance management system featuring branch-wise logins, admin reporting, and automated data syncing with Google Sheets and Google Drive for photo uploads.
Live DeploymentShowcase.
Branch Access Portal
A central gateway for different branches to access their specific login panels, ensuring data segregation from the start.
Secure Branch Login
Individualized authentication for each branch location, preventing unauthorized access to local staff data.
Local Operations Hub
A streamlined dashboard for branch managers to oversee daily attendance and process staff leave requests efficiently.
Visual Attendance Logging
Staff can mark their presence with real-time photo uploads, which are securely stored in Google Drive for verification.
Leave Submission UI
A simple, intuitive form for staff to submit leave requests, automatically synced to the central Google Sheet for review.
Transparency for Staff
A dedicated view for employees to track the status of their leave requests and review their historical records.
Administrative Gatekeeper
A protected login area for top-level administrators to gain full system-wide overview and control.
Control Center Overview
Real-time metrics highlighting total staff, active leave requests, and recent attendance movements across all branches.
Employee Directory Control
A centralized interface to add, remove, or update staff details. Changes are instantly propagated to the underlying Google Sheets.
Global Attendance Ledger
A master log of all attendance records across every branch, allowing admins to verify timestamps and photos globally.
Centralized Leave Approval
Admins can review pending leave applications from all branches and update statuses with a single click.
Reporting & Export
Generate and download comprehensive Excel reports using ExcelJS, making payroll and HR logging seamless.
Branch-Specific Audits
Managers can drill down into their specific branch's history to investigate patterns or verify individual records.