runbookify
← All plans
Sales & CRM / Lead Capture & Routing

Speed-to-Lead SLA Watchdog

Build an internal tool that times every new lead from the moment it's assigned, nudges the rep as the response deadline nears, and escalates to a manager (with approval-gated reassignment) when the clock runs out - so hot leads never go cold in someone's queue.

BeginnerAn afternoonBuilds onNext.js (App Router) on VercelSupabase (Postgres, Auth, RLS, Storage)Resend (email alerts + digests)
What you'll build

A logged-in watchdog where every new lead starts an SLA clock that respects business hours and time zones, reps get warning emails as the deadline approaches, managers get a breach alert and approve any reassignment, and you can pull per-rep / per-team breach reports and a clean CSV - all with a full audit trail.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A free Supabase account
  • A free Vercel account
  • A free Resend account (for warning + breach emails)
  • A feed, export, or Google Sheet of new leads with their assigned-time, plus a first-touch log (calls/emails logged) and your rep roster

The problem this kills

You promise prospects you'll respond "within 5 minutes" or "within the hour" - and most of the time you actually do. But the leads that slip through are exactly the ones that cost you deals: the one that landed during lunch, the one assigned to a rep who was on a call, the one that sat unread over a weekend. Nobody is watching the clock on every single lead, all the time. By the time anyone notices, the prospect has already booked a demo with a competitor who called back first.

Speed-to-lead is one of the most reliable predictors of whether a lead converts, yet it's almost always enforced by hope and the occasional spot-check. A spreadsheet of "assigned times" doesn't help unless someone is staring at it - and they're not.

This tool turns your SLA from a slogan into something that actually gets enforced, automatically, on every lead, around your real business hours.

What you'll build

A small, secure web app for your sales team that:

  • Starts a clock the moment a lead is assigned to a rep.
  • Stops the clock when a genuine first touch is logged (you define what counts - a logged call, a sent email, a connected conversation).
  • Counts only business hours - it pauses overnight, on weekends, and across time zones, so a lead that arrives at 6pm Friday isn't unfairly "breached" by Monday morning.
  • Warns the rep by email as the deadline approaches ("you have 10 minutes left on this lead").
  • Alerts the manager the instant the SLA is breached - once per breach, never spamming the same one twice.
  • Lets a manager reassign a stalled lead to another rep - but only after the manager reviews and approves it.
  • Reports breaches per rep and per team, and exports a clean CSV.

What's inside the Implementation Plan

The plan is a single file you paste into an AI coding agent (Claude Code), and it builds the tool with you step by step - no prior coding needed.

Crucially, it opens by interviewing you about your business before it writes a single line. It asks how leads reach your reps today, what your SLA targets actually are by lead tier, what your business hours and time zones look like, exactly what counts as a "first touch," who's in the escalation chain, and the messy edge cases (re-opened leads, after-hours arrivals, leads with no owner). Then it reads back a short tailored spec, waits for your thumbs-up, and shapes the data model and rules around your answers - so you get a tool fit to your team, not a generic template you have to bend to.

Inside you'll find:

  • The full discovery interview, written out question by question.
  • A clear data model for leads, touches, SLA rules, and breach events.
  • Step-by-step build prompts you copy and paste, one at a time.
  • The business-hours / time-zone clock logic, explained in plain language.
  • The warning + breach email setup with Resend.
  • The manager approval gate for reassignments.
  • The reporting screens and CSV export.
  • A "No API yet?" path so you can build the whole thing today from a Google Sheet, even before anyone wires it to your CRM.

The governance it includes (this is the point)

This isn't a toy. The plan bakes in the controls that make an internal tool safe to actually run on real sales data:

  • Login so only your team can open it.
  • Row-level security so each user only ever sees their own organization's leads and reps.
  • A complete audit trail - who logged a touch, who approved a reassignment, who changed an SLA target, and exactly when.
  • A human-in-the-loop approval gate: the watchdog can recommend pulling a cold lead off a rep, but nothing is reassigned until a manager reviews and approves it. SLA-target changes are reviewed and published by an admin, not silently edited.
  • Duplicate guards so the same breach can't fire two alerts and the same lead can't be processed twice.

Who it's for

SDR managers, sales leaders, and revenue-ops people who tell prospects "we respond within X" and want that promise to be true on every lead - not just the ones someone happened to watch. If you live in a CRM and a stack of spreadsheets and you're tired of hot leads quietly going cold, this is for you.

You've got this. Make a folder, start your agent, and paste the first prompt - the plan takes it from there.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.