Recurring Task Tracker with Escalation by Prateek SahniRecurring Task Tracker with Escalation by Prateek Sahni

Recurring Task Tracker with Escalation

Portfolio project
Prateek Sahni

The Problem

A small operations team repeats tasks daily, weekly, fortnightly and monthly, some closed with a portal ticket and one with a WhatsApp update. Nobody could see what was pending, misses surfaced late and nothing escalated by itself.

What I Built

A Google Sheets + Apps Script system built as a hiring assignment for an AI Operations Manager role:
Recurring cycles: Each task has a frequency and a start date. Cycles open automatically, anchored to the start date so a late finish never shifts the schedule. Each has a deterministic ID so it can never be created twice.
One place per employee: Each employee works from one My Tasks tab and types a single value: the portal Ticket ID, or the WhatsApp update they posted. That one entry records who and when, closes the cycle and opens the next.
Same-day alerts: 30 minutes after the 18:00 deadline the manager gets one email with an Acknowledge button that opens a small web page.
Escalation SLA: If nobody acknowledges by noon the next working day, or the task is still open two working days after it was due, leadership gets one escalation email.
Working-day calendar: Sundays and Indian public holidays (synced weekly from Google Calendar) never count.
Role-based access: Every tab carries a real protection by role — employees edit only their own tab, the manager only the dashboard.
Manager Dashboard
Manager Dashboard
My Tasks tab
My Tasks tab
Alert and Acknowledgement
Alert and Acknowledgement
Escalation SLA
Escalation SLA

The Outcome

All eight assignment scenarios pass in the live sheet. 110 automated tests (Jest) cover scheduling, SLA, holiday and access rules, run by GitHub Actions on every push. Testing also caught a real bug: dates shifted by hours when the sheet's time zone differed from the script's.

0 likes · 2 views · Nov 15, 2026

Google Sheets + Apps Script system that tracks recurring tasks, alerts managers same-day and escalates to leadership. 110 automated tests.

Timeline

Jan 1, 2026 - Ongoing

Tags