One leave request path for a 1,000+ staff care provider, built inside their own Google Workspace

Problem

Requests for unplanned leave travelled by phone call, text message or email to whichever manager picked up, and the manager then had to find the right person to approve it. The same request could be approved twice, or by nobody, and nothing was written down in one place.

Build

A web application inside the client's own Google Workspace, written in Apps Script with a Google Sheet as the operational database and Google's own identity for sign-in. A staff lookup searches across 1,000+ employees as you type, each request is routed to the approver for that person's outlet with a one-click decision, and there is an escalation path when nobody responds. Every request, decision and edit is logged with who did it and when.

Result

Requests go in, decisions come back and the record is in one place. The application, code and data live in the client's own Google account, and a follow-on tool was commissioned on the strength of it.