runbookify
← All plans
Customer Support & Service / CSAT / NPS Surveys & Voice of Customer

Detractor Alert & Recovery: Rescue Unhappy Customers Before They Churn

Watch incoming survey results, instantly flag low scores and angry comments, draft a recovery message, and assign a follow-up owner — with a manager approving every outreach before it sends.

IntermediateA weekendBuilds onNext.jsSupabaseResend
What you'll build

A web tool that reads your survey responses, flags detractors by low score and negative sentiment, drafts a tailored recovery message and suggests an owner, lets a manager approve and assign before anything sends, then emails the outreach via Resend and opens a tracked recovery task — plus a detractor worklist CSV export.

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 Supabase account (free)
  • A Vercel account (free)
  • A Resend account (free)
  • A CSV or Google Sheet of your survey responses (score, comment, customer, ticket/agent)
  • Claude Code or any AI coding agent

The problem this kills

A customer rates you a 2. They leave a comment that practically begs for a call back. And then... nothing. The response lands in a survey dashboard nobody opens until the monthly review, the customer quietly cancels, and by the time anyone notices, the relationship is gone. The cruel part is that detractors are the most rescuable customers you have — they cared enough to tell you they're unhappy. They just need someone to reach out fast, with the right message, before they give up.

Most teams know this and still drop the ball, because catching every low score in real time, writing a thoughtful recovery note, deciding who owns the save, and making sure it actually happens is a lot of manual work spread across a dashboard, an inbox, and somebody's memory. It falls through the cracks on busy days — which are exactly the days you get the most detractors. You don't need a developer or an expensive "customer experience platform" to fix this. You can build a tool that watches the results, raises the alarm, drafts the outreach, and keeps a human in charge of every send.

What you'll build

A simple internal web tool for your CX team. It takes in your survey responses — from a CSV, a Google Sheet, or live capture — each with a score, a comment, the customer, and the related ticket or agent. The moment a response qualifies as a detractor (low score, negative sentiment, or both), the tool flags it, drafts a tailored recovery message, and suggests an owner to run the save. It even tells "unhappy with us" apart from "unhappy with the product or price," so the right person gets it.

Then comes the part that makes it safe: a manager reviews each flagged detractor alongside the AI draft, edits if needed, assigns the owner, and clicks Approve. Only then does the outreach send via Resend and a tracked recovery task open with a due date. Nothing about an apology is ever auto-sent. If you have no survey integration yet, the tool runs entirely on a CSV/Sheet import and exports a clean detractor worklist your team can work from today.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — your survey type (NPS, CSAT, CES) and score scale, where responses live today, the exact columns and naming in your data, your detractor thresholds, who owns recovery, your typical and peak response volumes, and the messy edge cases like multi-language comments or responses with no contact info. It reads a short spec back to you for a thumbs-up, then builds the tool around your answers instead of a generic template. From there it walks the agent through the data model, the import and optional live capture, the detractor-detection and routing engine, the AI recovery draft, the manager review-and-approve gate, the send-and-track step, and the worklist export. Every step ends with a ready-to-copy prompt.

The governance it includes (this is the point)

This isn't a toy that fires off apologies on its own. The plan builds in the controls a real CX function needs: login so only your team can use it, row-level security so people only see their own organization's responses, a complete audit trail of every flag, draft, edit, approval, and send (who, what, when, and why), a hard human-approval gate so no recovery message ever leaves without a manager's sign-off, and duplicate guards keyed on the response ID so one survey response becomes exactly one recovery case — never two outreaches to the same upset customer. The AI drafts the suspicion and the words; a person makes the call.

Who it's for

CX managers, support team leads, and customer-success owners who are responsible for saving unhappy customers and are tired of detractors slipping past until it's too late. If you can describe what a "detractor" means in your world and who should reach out, you can build this.

You've got this — open the plan, paste the first prompt, and you'll be flagging and rescuing your first real detractors this weekend.

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.