Staff Attendance with Lunch Break Tracking – Google Sheets

A staff attendance system with proof attached to every punch. Employees clock in from their phone and the app records the time, a selfie, the GPS coordinates and the IP address — so attendance is a verified record, not a claim.

Four signals on every punch

• Timestamp — exact clock-in and clock-out time
• Selfie — camera capture at punch time, uploaded automatically to Google Drive
• GPS location — where the punch actually happened
• IP address — logged against the entry

Together these close the two loopholes that make honour-system attendance useless: someone else clocking you in, and clocking in from somewhere other than work.

Lunch breaks counted properly

Break start and break end are tracked as their own events rather than being folded into the working day. That gives an honest picture of hours actually worked — which matters when attendance feeds into payroll, and matters more when staff are paid hourly.

The monthly view

Every entry rolls up into a monthly summary per employee showing days present, days absent and days remaining in the period. Login history with employee validation sits alongside it, so an unrecognised attempt is visible rather than silently accepted. The app also blocks a second punch for a slot already filled, which stops the most common accidental double entry.

Who it suits

Offices without biometric hardware, field and site teams where GPS is the point, retail and restaurant shifts with real break tracking, and any business that wants a verifiable attendance trail without buying a device per location.

Setup

Copy the sheet, deploy the script, share the web app link with staff. Google Sheets holds the attendance data and Google Drive holds the photos — no external server and no hardware. The video covers the full build, and support is free if you get stuck.