A Weekly Routine for Simple CRM Setup: Capture, Date, Review

The usual reason a customer list fails is not the tool. It is that nobody has a routine for it. People set it up with energy, use it for a week and drift away. This post gives you a short routine to repeat, so the list stays useful without needing willpower. A routine is what keeps a simple CRM setup alive after the first week.

I call it Capture, Date, Review. Three steps, each small, done at fixed times.

Capture every person once, put a date on every next step, and review what is due each day. Do a short tidy each week. That is the whole routine.

Step one: Capture

Every person who shows interest or buys gets added to the list, once, and as soon as possible. The rule is that nothing lives only in your inbox or head.

Where do people come from? Usually your inbox, your contact forms, calls and referrals. For each source, decide how a person gets into the list. For example, "every form entry goes into the list the same day" or "I add anyone I reply to for the first time."

AI makes capture easier. Paste in a message and ask it to pull out the name, contact details and what the person wants. The lesson on this covers the setup so people land in the list without retyping.

Step two: Date

Every person gets a next step and a date. This is the heart of the routine. When you finish a call or send a reply, ask what happens next and when, and write both down.

A few rules make this work:

• The next step is one clear action, such as "send quote" or "check in about timing".
• The date is a real day, not "soon".
• If nothing needs to happen, set the person to "not now" with a date to look again.

Step three: Review

Once a day, at a set time, open the list and look at everything due today or overdue. Do those things. Then update each row with the new next step and date, so it leaves today's pile.

If you only keep one step, keep this one. A list you open daily stays accurate. A list you open monthly becomes a graveyard.

You can ask AI to help: paste the due rows and ask who needs a message and what to say. Treat what it writes as a first draft and edit it into your own voice.

The weekly tidy

Once a week, spend about five minutes on housekeeping:

1. Merge repeatsIf someone is on the list twice, keep one row and the fuller notes.
2. Close outMark deals as won or lost so they leave the active list.
3. Push the cold onesAnyone with no reply after a few tries moves to "not now" with a date to revisit.
4. Check for undated rowsEvery active person must have a next step date. Fix any that do not.

Make the routine stick

Tie each step to something you already do. Review right after your morning coffee. Capture as part of replying to email. Tidy on Friday before you close the laptop. A routine that hangs on an existing habit is far easier to keep.

If you miss a few days, do not rebuild everything. Open the list, clear whatever is overdue, and carry on. The goal is a list you can pick back up at any time.

When the routine works, add a little

After a few weeks, you can add a column or a reminder if you feel a need. Keep additions small. For ideas on what to watch, see the metrics that matter, and for a starting sheet use the free template.

The routine also connects to what comes next in your email: a welcome email for new people, an email journey for the ones not ready yet, and fast replies to new leads.

Simple CRM setup routine: what a normal day and week look like

A routine only helps if you can picture it. Here is how Capture, Date, Review might look in a normal week for someone with a dozen active people. It is an illustration, not a prescription.

Monday morning. Open the list. Sort by date. Four rows are due. Two need a short email, one needs a phone call and one needs a quote. You do them, then update each row with a new next step and date.

During the day. A new enquiry arrives by form. You capture it: add a row, note the source, write "reply to first message" with today's date. You reply, then change the date to follow up in three days if you hear nothing.

Wednesday. A call goes well. Straight after, you update the row: stage "quote sent", next step "check they got it", date two days out.

Friday. Five minutes of tidy. One person is on the list twice, so you merge them. A deal was lost, so you mark it. Two people never replied after several tries, so they go to "not now" with a date in two months.

That is all. Nothing there takes long, and nothing needs special software.

Adapting the routine to your pace

Not every business moves at the same speed. If you have dozens of new people a week, reviewing once a day may not be enough, and you may want a second quick look in the afternoon. If you only have a few conversations a month, a review every other day is fine, as long as you keep the dates honest.

The principle to keep is that the review time is fixed and the dates drive the work. If you notice you are skipping reviews, shorten them rather than dropping them. A two minute look beats none.

Using AI inside the routine

AI fits each step without changing the routine. In Capture it can read a message or form and pull out the name, contact details and request. In Date it can suggest a sensible next step and timing for you to accept or change. In Review it can take the due rows and draft a short message for each, which you edit. Keep one rule: you read everything before it is saved or sent. Lesson 5.1 shows this in practice, including asking the list "who should I follow up with today?" and getting a clear answer.

Common ways the routine breaks

1. Skipping DatePeople get added but not scheduled, so the review shows nothing useful. Make the date a required habit.
2. Reviewing too lateA review at five in the evening gets skipped when the day runs long. Move it earlier.
3. Overloading the listToo many people with vague steps makes review feel heavy. Clean weekly.

If you want to see the full setup first, read the complete guide, and to check you are avoiding the usual traps see the five mistakes.

Questions people ask

How long does the daily review take?

With a tidy list it is usually a few minutes. If it takes much longer, you probably have too many undated or old rows.

What if I have no time for a weekly tidy?

Skip the full tidy and only check that every active row has a date. That is the part that matters most.

Does this need AI?

No. The routine works with a plain spreadsheet. AI just removes some typing.