ScanSync

A custom automation bridge that transforms an existing door access control system into a fully functional HR attendance tracker eliminating the need for separate attendance hardware.

ScanSync is a custom Python automation solution built for a leading Egyptian interior design firm. It scrapes the company's existing biometric access control dashboard every hour capturing fingerprint, face ID, and RFID card scans and writes structured attendance records into a shared Google Sheet, turning every door scan into an HR attendance entry without touching the existing infrastructure.

Biometric door access existed across all offices and workshops, but HR had no access to the data due to lack of API, export, or integration support. Attendance was either tracked manually or required duplicating hardware at every entry point, increasing cost and complexity. ScanSync solved this through browser automation: a scheduled Python script logs into the access control dashboard hourly, scrapes new check-in and check-out events, structures them into employee-level attendance records, and syncs them to an existing Google Sheet, with a pre-midnight validation step to ensure complete daily data before the HR cutoff.