Lead clean-up

How to find the leads hiding in your inbox

7 min read · Gmail and Outlook

Most small businesses don’t have a lead problem. They have a finding problem. The quote you sent in March, the person who said “let’s talk after the summer”, the enquiry that came in while you were on holiday: they’re all still sitting in your inbox. Nobody followed up because nobody could see them.

Here’s how to pull them out in about 30 minutes, using nothing but the search bar.

1. Search for the words people use when they’re interested

Buyers write in predictable ways. Paste these into your search bar one at a time and skim the results:

In Gmail you can add older_than:30d to skip anything recent. In Outlook, use the date filter under Search > Filters.

2. Find emails where you were the last to reply

A conversation that ends on your message is a lead waiting for a nudge.

• Gmail: search in:sent older_than:14d, then open threads with a quote or question in them. If there’s no reply underneath, it’s a follow-up.
• Outlook: open Sent Items, sort by date, and look for threads with no reply.

3. Find people who emailed you and never got an answer

This is the painful one. In Gmail, search is:unread plus one of the buying phrases above; in Outlook, filter by Unread. Anything with a question in the first line deserves a look.

4. Write them down somewhere other than your inbox

Don’t follow up straight from search results. You’ll lose your place. Open a spreadsheet with five columns:

1. Name
2. Company
3. Email
4. Last contact date
5. What they wanted (one line)

Twenty rows is a good first target. If you hit fifty, you’ve found a real pipeline.

5. Sort by warmth, not by date

Add one more column: hot, warm or cold. Hot means they asked about price or timing in the last 90 days. Warm means a real conversation that went quiet. Cold is everything else. Start with hot, and send a short, specific message: “You mentioned looking at this in Q4. Is that still the plan?” For more on wording, see follow-up email templates.

What this won’t catch

Search finds emails. It won’t connect the person in your inbox to the same person in your phone contacts, your old spreadsheet or LinkedIn. It won’t spot duplicates, and it won’t remind you next month. That’s the point where a simple pipeline starts to pay for itself. See spreadsheet vs CRM for when to make the switch.