Attendance Tracking System
Developed an automated Google Apps Script system that tracks employee office attendance across multiple India locations, processes leave data, and sends personalized emails to employees about their monthly office visits. The system integrates with internal APIs (Jigsaw, Neo) to handle 1000+ employees, analyzes attendance patterns, generates footfall reports with visualizations, and maintains audit logs while ensuring data accuracy through validation checks.