Do consultants need a CRM, or is a spreadsheet enough to track prospects?

CRM or spreadsheet for a solo consultant's prospect list

A spreadsheet can be enough when you're starting out and only have a few prospects. Where it falls short is follow-ups: a spreadsheet won't remind you when it's time to reach out to someone. When you start missing follow-ups, that's a good sign it's time for something more.

The short answer

A spreadsheet is good at showing you where everyone stands, as long as you open it. The trouble is the days you don't. A follow-up you meant to send on Wednesday won't tell you it's due.

There's also a middle ground. Tools like Airtable and SmartSuite look like spreadsheets, but they can link records together and run automations, like sending you a reminder. They take some setup, though. You build the tables, connect them and set up the automations yourself, or hire a no-code developer to do that for you.

A CRM made for small businesses skips that setup. The prospect records, statuses and reminders are there from the start.

When is a spreadsheet enough?

When your list is short, you check it every day, and you're the only one using it. That's how a lot of consultants start, and it works.

If you go this route, add a column for the next step and a column for the date it's due. Sort by that date every morning.

What are the signs I've outgrown my spreadsheet?

The big one is a missed follow-up. Others creep in slowly. Your notes about one person are spread across your inbox, a notes app and a cell that's too long to read. You can't remember which referrals turned into clients. You start a second tab for people who went quiet and never open it again.

What about Airtable or SmartSuite?

They're a real step up from a spreadsheet. Both let you link records, so a prospect can connect to their company, their calls and their proposal, and both have automations. Airtable has a free plan. SmartSuite has a 14-day free trial.

The tradeoff is setup. You're building your own system, so you decide the tables, the fields, how they link and what sets off each automation. Some people enjoy that. If you don't, it can take a while before it saves you any time.

What does a CRM give me that a spreadsheet doesn't?

Mostly reminders and history. You log each call or email on the person's record, set a date to follow up, and get reminded when the day comes. Everything about that person is in one place.

Opsette works this way out of the box. Each lead has a status and a history of your calls, emails and meetings, and any of those can have a follow-up date that turns into a reminder. When a lead becomes a client, their details carry over to a new client record.

What should I track for each prospect?

Their contact details, where they came from, where things stand, a note for each conversation, and the date of your next follow-up. If you send a proposal, link it to them so it's all together.

What statuses should I use?

A short list you use the same way every time. Here's one that covers most situations:

  • New: you have their details but haven't reached out yet.
  • Contacted: you reached out and haven't heard back.
  • Responded: they wrote back and you're talking.
  • Nurturing: they're interested, but the timing isn't right yet.
  • Qualified: they have a real need and you can help.
  • Converted: they became a client.
  • Lost: they went with someone else or stopped replying.
  • Disqualified: they're not a fit.

Should prospects and clients be on the same list?

It's cleaner to separate them. You send invoices from your client list, and it gets cluttered fast with people who never signed. Move someone over when they become a client, and bring their details with them so you aren't typing anything twice.

Do I need a CRM that sends emails for me?

Probably not at first. Most of your follow-ups will be personal notes about a real conversation, and those come across better from your own inbox.

If you do start sending automated emails to a list, that's marketing email, and the FTC's CAN-SPAM rules apply even when you're emailing other businesses. Each email needs your mailing address and a way to opt out.

How do I protect the prospect information I collect?

Only collect what you need. The FTC's advice to businesses is to know what personal information you have and to hang on to only what your business needs. For a prospect list, that's usually contact details and notes.

If your spreadsheet is shared, check who has access. Google Sheets has a version history, so you can restore an earlier version if something gets deleted.

A worked example

Here's the same week of follow-ups, once with a spreadsheet and once with a CRM.

DayWith a spreadsheetWith a CRM
MondayYou sort the sheet by date. Three follow-ups are due today, and one was due last Thursday.Your reminders show the three due today. Nothing is overdue.
TuesdayAfter a call, you update the row and type in a new date.After a call, you log it and set a follow-up for Friday.
Wednesday and ThursdayYou're busy and don't open the sheet.Nothing is due, so there's nothing to check.
FridayThe follow-up is due, but nothing tells you.The reminder goes off. You send what you promised and set the next date.

The information is the same either way. The difference is that the CRM tells you when something is due, so a busy week doesn't cost you a prospect.

How consultants handle this

A lot of consultants start with a spreadsheet, a notes app or just their inbox. They usually switch after the first time a good prospect slips through, or when referrals start coming in faster than they can track them.

Consultants who get most of their work through referrals pay attention to where each lead came from. It tells them who to thank and where their time is best spent.

The big sales CRMs are built for teams with sales managers and pipelines. One person working on their own usually needs a lot less.

Frequently asked questions

Is Google Sheets a CRM?

Not really. It's a spreadsheet you can use as a prospect list. It records what you enter, but it won't remind you to do anything.

How many prospects do I need before a CRM is worth it?

There's no set number. The sign is a missed follow-up, and that can happen with eight prospects just as easily as with eighty.

What's the most important thing to track?

The date of your next follow-up. Everything else is about what already happened. That date tells you what to do next.

Should I delete prospects who said no?

No. Mark them as lost or nurturing. Someone who says no today may need help next year, and you'll be glad to have your notes from the first conversation.

Can I move my spreadsheet into a CRM?

Many CRMs can import one. Even if yours can't, you only need to bring over the people you're talking to now. The rest can wait.

Leads and client records, ready to use

See leads