New leads land in a shared inbox and nobody owns them. How do I assign them?
Short answer: Give every lead exactly one owner within minutes, using a short list of rules: route by service or area first, rotate between equal people second, and send anything left over to one named person. Then add a timer: if the owner has not replied in 24 hours, the lead moves to someone else and the manager is told. Lead routing means deciding who handles each new enquiry and doing it automatically instead of by whoever happens to see the email first. A small team can build this with a form, a spreadsheet and a few automatic messages, or switch it on inside a CRM (customer relationship management tool, the software that keeps your leads and customers in one place).
You do not need a big sales system, you need every new lead to have one name next to it before the end of the day.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
Why shared inboxes lose leads
A shared inbox feels fair. Everyone can see everything. In practice, everyone assumes someone else has it. Three people open the same enquiry, nobody replies, and the customer calls your competitor.
Speed matters here. A Harvard Business Review study of online sales leads, written by researchers from universities and a sales software company, found that most companies are not responding to online queries nearly fast enough. You do not need a fancy number to see why: a lead who just filled in your form is still looking at other options.
The cause is almost never laziness. It is that nobody was told, in writing, who owns what. Routing fixes that. If your problem starts earlier, with calls and texts scattered across phones, read my guide to keeping calls, texts and voicemails in one shared inbox first.
The four routing rules small teams actually need
Big companies use scoring models and territory maps. A team of 5 to 15 needs four rules, applied in this order.
- Route by specialty or service. If only one person quotes roofing and another quotes gutters, the lead goes to the person who can answer. This rule beats every other rule.
- Route by area. If people cover different towns, postcodes or sales regions, match the lead to the area it came from.
- Rotate between equals. When two or more people can take the lead, share them in turn. This is called round robin: lead one to Sam, lead two to Priya, lead three to Sam again.
- Fall back to one named person. Anything that does not match a rule goes to a single person, never to a shared pile. Pick whoever is most reliable and rename the role "lead triage" for the week.
Keep the rules to one page. If you cannot explain them to a new hire in two minutes, the rules are too clever.
Round robin limits you should know about
Round robin is popular because it feels fair. It has real weaknesses.
- It ignores who is away. A plain rotation sends a lead to someone on holiday. Add an "available" column so people on leave are skipped.
- It ignores fit. A big job and a tiny job count as one lead each. If your jobs vary a lot, rotate within a size band (small, medium, large) instead of across all of them.
- It ignores speed. Your fastest closer gets the same share as your slowest. Some owners deliberately give the best closer a double share on high-value leads. That is a business decision, and it is fine, as long as it is written down.
- It can feel unfair to the people who follow up well. If one person works their leads and another lets them sit, equal shares hand the good worker extra effort for the same pay. Check results per person every month.
The 24 hour reassign rule
This is the rule that stops leads going stale. Decide a time limit for the first reply. For most small businesses I would say 24 hours on a weekday, and a shorter limit (one to two hours) for requests that say "urgent" or "today".
Then write down what happens when the limit passes:
- At the limit, the owner gets a reminder: "Lead from Jordan is still waiting."
- At one more hour, the manager gets a message listing the lead and the owner.
- At the next working morning, the lead moves to the next person in the rotation, and the old owner is told it moved.
People often resist this because it feels like policing. Explain it as protection: nobody should be blamed because a lead arrived while they were on a job site. The system moves the lead, not the blame.
If your stale leads are already piling up, work through them with my guide to bringing back lost leads and old proposals.
A small sheet-based build
You can build all of this with a spreadsheet and a form. It is not glamorous, but it works for a team of up to about 15 and costs almost nothing. Here is the setup.
Step 1: capture every lead in one place
Make one web form for your website, and point every other source at the same sheet: phone enquiries typed in by whoever answers, email enquiries forwarded to one address. Google Forms can save every response into a Google Sheet, which Google documents in its help pages on choosing where to save form responses.
Step 2: build the people tab
Create a second tab named People with these columns: name, email, services they handle, areas they cover, available (yes or no), and last lead assigned (a date and time).
Step 3: add the rules in order
When a new row arrives, a small script reads the service and area, filters the People tab to those who match and are available, and picks the person whose last lead was the longest ago. That single idea, "longest ago first", is round robin without any counting. If nobody matches, it picks your triage person.
Google Apps Script, the scripting tool built into Google Sheets, can run this when a form is submitted. Google lists installable triggers, which run a function on events like a form submission or on a timer. It can also send the email with its MailApp service. Check Google's quotas page for daily email limits: as of November 2026 it lists about 100 email recipients a day for free accounts and 1,500 for Google Workspace accounts, which is plenty for most small teams.
Step 4: write the owner and time columns back
The script writes the owner's name, the assigned time and a status (new, contacted, quoted, won, lost) into the lead row. The owner gets an email with the lead details and a link to the row.
Step 5: add the timer
A second script runs every hour on a timer trigger. It looks for rows where the status is still "new" and the assigned time is more than 24 hours old, then applies the reassign rule above.
If you would rather not write scripts, a no-code automation tool such as Zapier or Make can do the same job with a form trigger, a spreadsheet lookup and an email step. The logic is identical, so write the rules down first and pick the tool second.
A worked example (made-up figures)
Imagine a 9-person home services company. Figures below are invented to show the method.
| Rule | Condition | Goes to |
|---|---|---|
| 1. Specialty | Request is for a bathroom remodel | Rotation between Dana and Luis |
| 2. Area | Request is north of the river | Rotation between Priya and Sam |
| 3. Urgent | Form says "today" or "emergency" | Whoever is marked on call this week |
| 4. Fallback | Nothing matches | Marcus (lead triage) |
On Monday, 6 leads arrive. Dana gets the first bathroom lead, Luis the second, Dana the third. Priya gets the first northern lead. One urgent lead goes to Sam, who is on call. One odd request about fence painting falls to Marcus. By 10am every lead has an owner. On Tuesday morning, one of Dana's leads is still marked "new", so the timer moves it to Luis and tells both of them.
What a CRM can do for you
If you already use a CRM, check its assignment settings before you build anything. Many offer rules such as rotating new leads between users or assigning by a field value. Plan names and limits change often, so check the vendor's current help pages for which plan includes assignment rules. The usual catch is that routing sits on a paid tier.
A CRM is the better choice once you have 15 or more people, several lead sources, or a need to report on which source produces the best customers. Some industries have special tools. If you recruit, see my guides to recruitment CRMs and staffing agency software, where "leads" are both clients and candidates and the routing rules differ.
Common failure points
- Leads that skip the form. A text message or a call that never gets typed in is invisible to the system. Make one person responsible for entering them the same day. If missed calls are your gap, my guide to missed call text back covers capturing them automatically.
- Nobody maintains the People tab. A person leaves, and leads keep going to their old address. Add "update the People tab" to your offboarding checklist.
- Rules that grow. Every exception gets a new rule until nobody understands the system. Review the rules each quarter and delete the ones that rarely fire.
- No weekly check. Even a good system drifts. Spend ten minutes each week on the checks in the next section.
The weekly ownership check
Every Monday, filter the sheet or CRM for five things:
- Leads with no owner. There should be none.
- Leads still marked "new" after 24 hours. These should have been moved.
- Leads where the status is "contacted" but nothing has changed for a week.
- Leads per person over the past month, to see whether the split is what you meant it to be.
- Win rate per person and per lead source, so you can adjust the rules with evidence.
This is a manager's job, not the owner of each lead. It takes ten minutes and it is the best use of ten minutes in your week.
Where AI fits and where it does not
AI can read a free-text enquiry and tag it with a service and an urgency, which saves someone typing. It should not make the assignment decision on its own, and a person should look at anything it tags as urgent. For the wider picture, see my guides to business process automation and AI for small business.
How I'd approach this
I would start on paper. Write the four rules, the 24 hour limit and the name of the fallback person on one page, and have the team agree to it in a ten-minute meeting. That alone fixes half the problem, because the real gap is usually that nobody decided.
Then I would build the sheet version for a month. It is cheap, you can see exactly how it works, and you learn which rules you need before paying for anything. If you outgrow it, move the same rules into a CRM, since the rules transfer even if the tool changes.
If the sheet becomes fragile, or your leads come from five places, that is when a small custom tool starts to pay off: one place for every lead, your rules built in, and no per-seat fees. Blur Studio builds these, and fixes and finishes start around $1,500.
Questions people ask
What is lead routing?
Lead routing is deciding which person handles each new enquiry and assigning it automatically. The goal is that every lead has one owner within minutes, so nothing waits in a shared inbox.
What is round robin lead assignment?
Round robin means sharing new leads between people in turn. The simple version is to give the next lead to whoever was assigned a lead longest ago, and to skip anyone marked unavailable.
How long should someone have to reply to a new lead?
Pick a limit and write it down. For most small businesses, 24 hours on a weekday works as the reassign limit, with a much shorter target for urgent requests. A study in Harvard Business Review found most companies respond to online leads too slowly, so faster is better than slower.
Can I do lead routing in a spreadsheet?
Yes, for a team of up to about 15. A Google Form can feed a Google Sheet, and a small script or a no-code tool can pick the owner and send the email. See the build steps above, and my guide to shared inboxes for calls, texts and voicemails if leads also arrive by phone.
When should I move from a spreadsheet to a CRM?
Move when you have several lead sources, more than about 15 people, or a need to report on win rates by source and person. Take the same rules with you.
What should happen to a lead that has gone quiet?
Reassign it after the time limit, tell the old owner, and set a date to try again. My guide to bringing back lost leads and old proposals shows how to write the follow-up.
More in this topic: Problem solving: automating service business work (21 guides) →