Employee Attendance Tracker – Google Sheets + Web App
✅ Track attendance. Manage overtime. Simplify HR.
This Employee Attendance Tracker is a complete solution built using Google Sheets + Google Apps Script, perfect for startups, small businesses, and HR teams.
With secure login, real-time attendance, overtime requests, and a full admin dashboard — this tool requires no coding and is ready to deploy in minutes.
💡 WHAT'S INCLUDED
- ✅
Code.gs(backend logic) - ✅
Login.html,dashboard.html,admin.html - ✅
README.md– Setup + Deployment Guide - ✅
EmployeeAttendanceTemplate.xlsx– Ready-to-use Sheet - ✅ Demo GIF + Promo Images
🚀 FEATURES
- 🔐 Secure Employee Login (via ID & password)
- ⏱️ Clock In & Out Buttons – Logs timestamp to sheet
- 📅 View My Attendance – Past 15 days per employee
- 🕒 Overtime Request Form – With auto email to manager
- 🛠️ Admin Dashboard:
- Approve OT requests
- Add/edit/remove employees
- Search/filter employees
- Log admin actions
- 📤 No Google login required | 📧 Email alerts included
✅ Features Included: Google Sheets Integration Centralized live data Auto-updated attendance logs Separate sheets: Employees, Attendance, OvertimeRequests, AdminLogs Clock In / Out System Web app interface for employees to clock in/out Timestamp-based tracking Mobile & desktop compatible Email Alerts Auto-notification for late entries, OT requests, admin actions Configurable recipient list HR Admin Tool View, approve, or reject overtime Track attendance trends Filter/search by employee/date Secure Google login access 👩💼 Use Cases: Remote teams Small & mid-size businesses Freelancers managing teams School/college staff tracking