If you've ever thought "I really need a CRM" and then closed the tab because the options were either too expensive, too complicated, or built for a sales team you don't have — you're not wrong to have closed the tab.
Most solopreneurs and small teams don't have a CRM problem. They have a "my leads and clients live in six different places and I can't see the whole picture" problem. A $50-a-month platform doesn't fix that. A little bit of structure does.
Here's how to build a simple pipeline in a tool you probably already have open right now: a spreadsheet.
Why a spreadsheet actually works here
A spreadsheet gets a bad reputation because messy spreadsheets are everywhere. But the mess usually isn't the spreadsheet's fault — it's a structure problem. People type notes into the wrong cell, mix a phone number and a follow-up date into one field, or free-type a status like "sent it," "Sent It!," and "proposal sent" until filtering becomes useless.
Fix the structure, and a spreadsheet holds up just as well as software that costs you monthly.
Three rules make the difference:
- One row, one record. Every lead, donor, or client gets exactly one row. Never stack two people in a single row to save space.
- One idea, one column. Don't combine a name and a note in the same cell. Split things out — first name, last name, date, status — so you can sort and filter on any of them.
- Dropdowns instead of free text. If status is typed by hand, you'll eventually get three versions of the same status. A dropdown keeps it clean.
Building it: about 10 minutes
Step 1: Set up your headers
Open a fresh sheet, rename the tab something like "Pipeline," and set up these columns across row 1:
- Date Added
- First Name
- Last Name
- Organization
- Phone
- Status
- Estimated Value
- Next Step
- Follow-Up Date
- Notes
Bold the header row and freeze it (View > Freeze > 1 row) so it stays visible as you scroll.
Step 2: Turn Status into a dropdown
Click the Status column header, then Data > Data validation > Add rule, and choose Dropdown. Add options that match how work actually moves through your world — something like:
- New Inquiry
- Contacted
- Proposal Sent
- Active
- Complete
- Not a Fit
Give each one a light background color if you want a quick visual read at a glance.
Step 3: Make new entries impossible to miss
Select your full data range, then Format > Conditional formatting, and add a custom formula rule: =$G2="New Inquiry" (adjust the column letter to match your Status column). Set it to a soft highlight color. Now anything brand-new stands out the moment you open the sheet — no scanning required.
That's it. No integrations, no monthly fee, no onboarding call with a sales rep.
When a spreadsheet stops being enough
This setup will carry a lot of solopreneurs a long way. But it's worth being honest about where it hits a ceiling:
- More than one person needs to update it at the same time without overwriting each other
- You want automatic reminders instead of remembering to check a Follow-Up Date column
- You're manually re-typing the same info from an intake form into the sheet
- The sheet has quietly turned into five tabs and nobody remembers what half of them are for
None of those mean you need expensive software. Often they mean the structure needs to grow up a little — usually still inside tools you already have.
If you're at that point and want a second set of eyes on it, that's exactly the kind of thing a roadmapping call is for — one session to look at what you've actually got and figure out what it needs next, whether that's a small fix or something more.