Spreadsheets vs lead routing software: when to upgrade?

Most lead distribution operations start in spreadsheets. A tab per buyer, formulas for round-robin, a Zapier zap to send the email. It works, and the cost is near zero. The question is not whether to start there — it's recognizing precisely when that setup starts costing you more than it saves.

This is a practical guide to that threshold, with concrete failure modes and the break-even math between DIY and dedicated software.

What spreadsheets actually handle well

Sheets plus Zapier covers a specific operating envelope: one buyer, simple round-robin or manual assignment, under 200 leads per month, no cap enforcement, no time-of-day restrictions, and no dispute workflow. Inside that envelope, the setup costs less than $20/month and takes a few hours to wire up. There's nothing wrong with staying there if your operation genuinely fits. The problem is that most agencies outgrow this faster than they expect — usually within 90 days of signing a second buyer.

Where the breakdown happens

The failures are predictable and cluster around a few specific features that Sheets + Zapier cannot implement reliably:

• Real-time caps: If two leads arrive simultaneously and buyer A is at 99 of their 100-lead daily limit, Sheets can't prevent both from going to A. Cap enforcement requires atomic state management, which a spreadsheet doesn't provide.
• Cross-pipeline dedup: Checking a new lead against historical records across multiple pipelines in real time requires hashing and querying a database, not scanning a spreadsheet row by row.
• Time-of-day routing: Routing leads only during buyer business hours — timezone-aware, with after-hours overflow — requires stateful schedule logic that Zapier cannot express natively.
• Buyer disputes: When a buyer emails saying a lead was bad, there's no structured workflow in Sheets to log it, review it, and issue a credit. It happens over email and often slips through.

The cost math at real volume

The signals that tell you it's time

Three reliable signals, roughly in order of severity:

1. Your first duplicate complaint. A buyer receives a lead they already have. This happens because Sheets dedup is reactive, not real-time. One complaint is the signal; the third is the buyer threatening to reduce their volume commitment.
2. More than 30 minutes per week on manual routing. If you're spending more than 30 minutes a week moving leads, assigning them, checking caps, or reconciling buyer counts, you're effectively paying yourself or an employee to do what software should handle.
3. A second buyer asks for an exclusivity clause. Sheets has no concept of lead exclusivity. Honoring it manually is unreliable at any volume above 50 leads/week.

What dedicated software actually changes

The switch from Sheets to a dedicated router changes three operational realities. First, cap enforcement becomes atomic — a buyer at their daily limit is simply skipped and the next eligible buyer receives the lead. Second, dedup runs at ingestion and rejects duplicates before they reach any buyer. Third, buyers get a self-serve portal rather than emailed reports, which removes a recurring support burden. For rules-based routing, LeadMove ($149/mo Starter, $299/mo Pro, $499/mo Scale with unlimited buyers) and LeadProsper ($499+/mo) are the realistic options. Boberdoo at $1,000+/mo is built for real-time auctions and is overhead if your pricing is pre-negotiated.

The most common regret is waiting too long — agencies typically switch after losing a buyer over a duplicate dispute rather than before it happens.