Track Employee Attendance with Geolocation & IP | Google Apps Script Tutorial | C26

A focused attendance tracker: an employee marks attendance, and the entry is stored with the time, the device location and the IP address it came from. That is the whole job, done properly. If you want leave, holidays and payroll on top, the larger attendance systems in this catalog cover those — this is the compact build for organisations that only need to know who marked attendance, when, and from where.

What it does

The web app reads the device location through the browser geolocation API and records the IP address at the same moment as the timestamp. Those two together are what makes a punch checkable: a location alone can be argued with, but a location and an IP that do not match the workplace are hard to explain. Everything lands in a Google Sheet, so verifying a disputed day is a matter of reading a row.

Highlights

• Timestamped attendance capture
• Live geolocation on each entry
• IP address validation
• Fake attendance prevention
• Data stored in Google Sheets
• Deployed as a secure web app

Who it is for

Field teams, site staff, delivery crews and small offices that need proof of presence without a full HR system — and developers who want a clean example of the geolocation API and IP capture inside a Google Apps Script web app.