6 min read
A solo business does not lose leads because it picked the wrong software. It loses leads because nobody wrote down who asked, what they wanted, and when to follow up. Any system that fixes those three things is better than the best system you never open.
That said, the three realistic options for a one-person business, a spreadsheet, a free CRM, or an AI assistant sitting on top of one of them, behave very differently once you have more than a couple of dozen leads. This comparison lays out what each does well, where each breaks, and which one fits your stage.
The three contenders at a glance
- Spreadsheet: Google Sheets or Excel with one row per lead. Maximum flexibility, zero cost, zero automation unless you add it.
- Free CRM: a CRM (customer relationship management tool, essentially a contact database built around deals and follow-ups) such as HubSpot’s free CRM. Structure, reminders and email tracking built in.
- AI assistant layered on top: ChatGPT, Claude, Gemini or a built-in AI feature reading your spreadsheet or CRM to summarize, sort and draft follow-ups. Not a system of record on its own, but a powerful helper.
The key distinction: the first two are places where lead information lives. The third is a way to work with that information faster. Treating an AI chat as your lead database is the mistake to avoid.
Option 1: The spreadsheet
Where it wins
A spreadsheet is the fastest thing to set up. Six columns cover most solo businesses: name, contact, source, what they want, status, next follow-up date. You can be tracking leads in ten minutes, and you control every field.
Spreadsheets have also become smarter. Google Sheets now offers an AI function on eligible Google Workspace and Google AI plans, which lets you write a formula that asks AI to classify or summarize a cell. For example, you can have it tag each inquiry as “ready to buy”, “price shopping” or “just curious”. We tested it in our Google Sheets AI function review, and lead tagging was one of the jobs it handled well.
Where it breaks
- No reminders. A follow-up date in a cell does nothing unless you look at it.
- No history. You end up with a “notes” column full of dates and fragments that nobody can read three months later.
- Email lives elsewhere. You still have to search your inbox to see what you last said.
Best for: fewer than about 30 active leads at a time, or a business where most sales close in a single conversation.
Option 2: The free CRM
Where it wins
A CRM fixes exactly what spreadsheets lack. Each contact has a timeline of emails, calls and notes. You get tasks and reminders that actually ping you. Deals move through stages you define, so you can see at a glance who is waiting on a proposal and who has gone quiet.
HubSpot’s free tier is the most common starting point because it covers contacts, deals, tasks and email tracking without a credit card. Several other CRMs offer free or low-cost solo plans too. Pick one that connects to the email you already use.
Where it breaks
- Setup takes an afternoon, not ten minutes. You need to define stages, import contacts and connect email.
- Upsell pressure is real. Free tiers are designed to show you paid features. Decide in advance what you will never pay for.
- Discipline is still required. A CRM nobody updates is just a more expensive spreadsheet.
Best for: anyone with 30 or more active leads, a sales cycle longer than a week, or services where you send proposals and wait.
Option 3: An AI assistant on top
Where it wins
This is where solo owners now save the most time. An AI assistant connected to your lead list can:
- Summarize every lead that has not heard from you in more than seven days.
- Draft a short, personal follow-up for each, based on the notes you kept.
- Spot patterns, such as which source brings the leads that actually buy.
- Clean messy entries, like inconsistent phone formats or duplicate contacts.
Connectors make this easier every month. Many assistants can now read a Google Sheet or a CRM directly through standard connectors; our beginner’s guide to MCP explains how that plumbing works. Workspace tools like Notion have built agents directly into the database itself, which we covered in our Notion Agents review.
Where it breaks
- Chats forget. A conversation is not a database. If your only record of a lead is in a chat thread, you will lose it.
- Privacy deserves thought. You are sharing customers’ names and contact details with an AI provider. Check the data settings of your plan, and leave out anything sensitive.
- Drafts still need you. An AI follow-up that gets a detail wrong does more harm than no follow-up at all.
Best for: anyone who already has a spreadsheet or CRM and wants to spend less time on the weekly review.
Head to head on what matters
- Setup time: spreadsheet 10 minutes; free CRM 2 to 4 hours; AI layer 30 minutes once the first two exist.
- Cost: spreadsheet free; free CRM free until you need paid features; AI layer free to the cost of a paid assistant plan you may already have.
- Reminders: spreadsheet none by default; CRM built in; AI layer only when you ask.
- History per contact: spreadsheet weak; CRM strong; AI layer depends entirely on what it can read.
- Weekly review effort: spreadsheet high; CRM medium; AI layer low.
The verdict: grow through them in order
The right answer for most solo businesses is not one of the three. It is a sequence.
- Start with a spreadsheet the day you get your first few leads. Six columns, nothing fancy.
- Add an AI review every Monday. Ask your assistant to list overdue follow-ups and draft replies from your sheet. This alone fixes most leaks.
- Move to a free CRM when you pass roughly 30 active leads or catch yourself missing a follow-up you wrote down. Import the sheet; it is a one-hour job.
- Keep the AI layer on top of the CRM for summaries and drafts. If you want triggers, such as a new form entry creating a contact automatically, see our Zapier vs Make vs n8n comparison for what each automation step costs.
Do not skip ahead. A CRM set up for 12 leads becomes busywork; a spreadsheet stretched to 80 leads becomes a liability. Match the tool to the volume, and let AI handle the reading and drafting in between.
Where are your leads living right now: inbox, sheet or CRM? Share your setup in the comments.
