Sheet, app or full CRM?
The fields and stages
| Field | Type | Used for |
|---|---|---|
| Name, email, phone, company | Text | Reaching them; email stops duplicates |
| Source | Choice | Which channel brings buyers |
| Stage | New, Contacted, Replied, Won, Lost | The pipeline board |
| Deal size | Money | Sorting and the open total |
| Last contact | Date | Spotting leads that went quiet |
| Next follow-up | Date | Today's list |
| Notes | Long text | One line per conversation |
Make Stage and Source dropdowns, not free text, so they sort and count. You need three views: Follow up (open leads, soonest date first, every morning), Pipeline (a board by stage, weekly) and All leads (searchable, when someone calls).
How to build a simple CRM, step by step
Step 1: Make the list with these fields
In a sheet, one tab with one row per lead. In a no-code app, one table.
Step 2: Add the three views
A sorted tab or filter view for Follow up; a board for Pipeline if your tool has one.
Step 3: Bring in what you have
Paste last quarter's leads from email and your notes. Fill Stage and Next follow-up for every open one.
Step 4: Decide how new leads get in
Form entries, enquiry emails, referrals: each needs a route into the list.
Watch out. Without a route in, the CRM goes stale within a month. Automate capture, or set ten minutes a day to add leads.
Do this step in 50agents
Track my leads and follow up
Build itCaptain builds this CRM with an AI agent that reads your email each weekday, adds new people asking to buy, and drafts follow-ups for your approval. See the ready-made version.
Step 5: Set the follow-up rule
Each time you contact a lead, set Last contact to today and Next follow-up to a date. No open lead without a date.
Tip. Make Next follow-up required for every open stage. Leads with no date never show up in Follow up.
Step 6: Review the pipeline weekly
Move dead leads to Lost. A pipeline full of ghosts hides the real ones.
What can go wrong
Duplicate leads
The same person arrives from a form and an email. Use email as the key and search before adding.
Stages nobody agrees on
"Qualified" means three things to three people. Keep five plain stages and write one line on what each means.
Two people, one sheet
Edits overwrite each other and there is no history. Move to an app with records and a change log.
A drafted follow-up misreads the lead
An AI agent can mistake a supplier for a buyer. Approve each draft before it goes, and correct the stage when it is wrong.
Questions people ask
Can Google Sheets be a CRM?
Yes, for one person or a small team with a few dozen open leads. Add the fields above, dropdowns for stage and source, and a Follow up view sorted by date.
What columns should a simple CRM have?
Name, email, phone, company, source, stage, deal size, last contact, next follow-up and notes. Add more only when you make a decision with them.
When should I move to a real CRM?
When several people work the same leads, when you need email tracking and sequences, or when follow-ups keep slipping despite the sheet.
How many stages should a simple CRM have?
Five is enough: New, Contacted, Replied, Won, Lost. Make Stage a dropdown so it sorts and counts. More stages mean more arguments about where a lead belongs.
How do I stop duplicate leads?
Use email as the key. Search before adding by hand, and make imports and automations update the existing lead when the email matches.
How often should I review the pipeline?
Sort Follow up by date every morning, and look at the whole pipeline once a week. Move dead leads to Lost so the open ones stay visible.