Apps

How to build a simple CRM without code

The short answer

Make one list of leads with about ten fields, five stages, and a next follow-up date on every open lead. Sort by that date each morning, and get new leads in from email and forms without typing.

4 min read

Sheet, app or full CRM?

How many people work the same leads?
Do leads arrive faster than you can type them in?

A sheet is enough

Add the fields below, dropdowns for Stage and Source, and a Follow up view sorted by date.

App

A no-code app that captures and reminds

It adds leads from your inbox and puts today's follow-ups in front of you, so nothing depends on your memory.

See the ready-made version: Track leads from your email

App

A no-code app with records

Two people in one sheet overwrite each other with no history. An app gives each lead one record and a change log.

A full CRM

Email tracking, sequences and reporting across reps are what full CRMs are built for.

The fields and stages

FieldTypeUsed for
Name, email, phone, companyTextReaching them; email stops duplicates
SourceChoiceWhich channel brings buyers
StageNew, Contacted, Replied, Won, LostThe pipeline board
Deal sizeMoneySorting and the open total
Last contactDateSpotting leads that went quiet
Next follow-upDateToday's list
NotesLong textOne 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

  1. 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.

  2. Step 2: Add the three views

    A sorted tab or filter view for Follow up; a board for Pipeline if your tool has one.

  3. 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.

  4. 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 it

    Captain 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.

  5. 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.

  6. 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.

Read next

Or let Captain build it

One sentence to Captain. Free to start.

Build it with Captain
How to build a simple CRM without codeBuild it