How to manage leads without adopting a large CRM on day one

Practical method · Lead Relay team · Updated on 23 September 2026

Five checks to review your follow-up: a free, printable resource without signup.

A five-step lead follow-up system without a CRM

For a small team, a shared spreadsheet can be a starting point if there is an update routine and access is limited to the people handling opportunities.

1. Centralise form and email enquiries. Give each opportunity an identifier and check for duplicates before creating another row.
2. Record source, arrival date, owner, status, latest reply, next action and follow-up date. Keep a link to the original message within an authorised environment.
3. Use statuses with shared meanings: new, awaiting reply, in follow-up and closed. When closing, record the reason.
4. Each morning, review opportunities without an owner, without a first reply or with overdue follow-up. Every open row should have a person and a dated action.
5. Review duplicates, delays and closures weekly. Decide what to improve in the process before adding automation.

A template and example to get started

Download the lead follow-up CSV template (CSV in English). It contains three fictional cases: awaiting reply, in follow-up and closed. It is a CSV without formulas or automation that you can open in a spreadsheet. Share it only with people who need access to the data.

Fictional example: LR-001 arrives through a form, Ana becomes its owner and the status changes to “In follow-up” after replying. The next action is “Confirm scope” with an agreed date. “Contact later” is not enough to check whether follow-up is overdue.

How to use the template

1. Open the CSV using UTF-8 and a comma separator if your spreadsheet does not detect them. Dates use year-month-day format and the same time zone.
2. Replace the examples. Keep one identifier per enquiry and one owner, even if several people are involved.
3. Filter by status to separate pending cases from closed ones. Among open cases, review those without an action or with a past date first.
4. When closing a case, record the reason and remove reminders that no longer apply. Message history remains in your authorised email account.

The file does not send notifications or synchronise email. Do not upload customer data here: work in your own environment and limit spreadsheet permissions.

When a shared spreadsheet is no longer enough

Consider a tool when simultaneous edits are hard to manage, reminders are forgotten, permissions are insufficient or history is lost. If you need sales forecasts, multiple sales processes and broad integrations, compare full CRMs. If the spreadsheet works and someone maintains the routine, there is no need to replace it.

Before migrating, review five recent enquiries: did each have an owner, a dated action and access to the original reply? Record what was missing and how much work it took to reconstruct. If the problem is copying messages between systems, require the alternative to remove that step; a prettier interface is not enough.

How to assess a change of tool

For two people, first try a handover: one replies to a fictional enquiry and the other must locate the reply, take the next step and find its date without asking. Repeat the next day with roles swapped. If a spreadsheet works, keep it; if reconstructing the email conversation is difficult, prioritise thread access and continuity before adding fields.

Try one source and a small team. Before starting, count unassigned leads and overdue follow-ups; then check whether the team keeps information up to date. An operational improvement alone does not prove increased sales.

Try the Lead Relay demo without signup: practise assignment and follow-up with fictional examples and predefined actions. It resets on reload and does not connect real sources. It helps you assess the workflow, rather than verify an integration or measure real savings.

Continue with the lead follow-up assessment or see Lead Relay pricing and scope.

1. Do we know which sources generate real leads?
2. Does every open lead have a visible owner?
3. Is the first action recorded somewhere?
4. Is there a follow-up date for leads that are not closed?
5. Can we review unassigned and overdue work each morning?