Case Study 11 · Sheets-based tracker · SMS alerts

Candidate Tracking Automation — Google Sheets & SMS Alerts

Google Apps Script · Google Sheets · Brevo SMS API

The Problem

A district manager was tracking job candidates in a spreadsheet with no automation — statuses lived in one place, notes lived in someone's head, and nothing was sending alerts. When a candidate sat in 'Pending Schedule' for days, no one noticed until it was too late to move them forward.

The Build

We built a Google Sheets-based candidate tracker with an installable Apps Script trigger that watches for status changes. When a candidate hits 'Pending Schedule,' the system fires an SMS alert via Brevo SMS API routing around Gmail quota limits. When the manager marks a hire, a popup prompts for scheduling notes, hire decision, and rationale — all of which get appended to the candidate's record with timestamps.

The Outcomes

— Zero candidates stall silently — every Pending Schedule status triggers an immediate alert

— Full audit trail: every note, timestamp, and decision logged automatically

— Gmail quota protected by routing through Brevo API instead of MailApp

— Manager UX reduced to two clicks: update status, answer prompts

The Stack

Google Apps Script Google Sheets Brevo SMS API

Have a similar problem?

We start every engagement by understanding what's actually broken before we touch a tool.

Tell us about it →