CRM for Consultants: Free, from Your Google Sheet with AI

Ask a consultant where their last three engagements came from and the answer is almost never "marketing." It's a former client who changed companies, a referral from someone they worked with in 2023, a conversation at a conference that turned into a scoping call eight months later. Consulting is a long game played through a network — and most CRMs are built for a short game played through a lead list.

That mismatch is why so many independent consultants and small firms track everything in a Google Sheet instead. The sheet holds the network fine. What it can't do is run the cadence: the quarterly check-in with the VP who championed you, the thank-you loop back to whoever made an introduction, the gentle nudge when a scoping conversation has been "circling back" for a month. Those touches are the actual business development engine, and they live entirely on discipline and memory.

You can put structure around that without abandoning the sheet or paying for a sales tool that keeps asking about your "lead velocity." Have AI build a relationship-first CRM directly on the spreadsheet you already keep.

Step 1: Start With Your Network Sheet

Your sheet probably already has the right shape — one row per relationship, not per deal. Here's a layout that works well for consulting:

Two columns do most of the work here. Relationship (past client, referrer, prospect) captures that your network has tiers a pipeline can't express. Referred by records how work actually arrives — so a year from now you can see that James has quietly sent you three engagements and deserves more than a holiday card.

Step 2: Create a Free Account

Go to lovespreadsheets.com and sign up. Free covers building and running the CRM; the paid tier adds things like logins for partners on your own domain.

Step 3: Describe the Practice, Not a Funnel

Select the CRM template and write down how engagements really develop:

• "Work moves Conversation → Scoping → Proposal → Active → Alumni. A stage can last months, and that's normal."
• "When an engagement ends, the client becomes Alumni — not closed. Alumni are my best source of future work."
• "Every contact has a keep-warm date. Prospects get touched more often; alumni and referrers at least quarterly."

Asks worth making for a consulting practice:

• Quarterly keep-warm reminders driven by the keep-warm date column, so no relationship goes twelve months cold
• Referral-chain tracking — a view of who has referred whom, so you can see which relationships generate work
• An alumni-network view — every past client in one screen with their company, engagement history, and last touch

Upload the sheet and run the build. Use the AI Optimize button if your description feels loose; the AI may come back with a clarifying question or two. Builds land in about 15–20 minutes.

Step 4: Your Network, Finally Legible

The result is a private web app on top of your sheet: the active pipeline on one screen, the alumni network on another, referral chains traceable, and today's keep-warm touches queued up when you open it. It syncs with the Google Sheet both ways in real time — update a stage after a call from your phone, and the sheet already knows; add a contact in the sheet, and the app picks it up.

For a solo consultant, this is the business development system. For a small firm, share the URL and every partner sees the same living picture of the network instead of three private versions of it.

Why Consultants Keep the Sheet

The network outlives every engagement — and every tool. Your contact history is a career asset measured in decades. Keeping it in a sheet you own means no CRM vendor ever stands between you and it.

A missed keep-warm is a five-figure event. One quarterly touch that doesn't happen can be the difference between being top of mind and hearing "we just signed someone" — on engagements worth tens of thousands. The math on reminders is not subtle.

Referrals compound only if you can see them. When Referred by becomes a report instead of a half-remembered fact, you learn who your real channel is — and you invest in those people deliberately.

Common Questions from Consultants

My pipeline is eight conversations, not eight hundred leads. Does a CRM make sense? That's precisely when each one matters most. This isn't volume tooling — it's a cadence and memory layer over a small, high-value network.

Can it distinguish a referrer from a prospect? Yes. Your Relationship column drives views and cadence, so a referrer gets relationship maintenance, not a sales sequence.

We're two partners with separate networks. Can we share it? Yes — share one app over one sheet, and with paid team logins each partner can work their own contacts while both see the whole network.

Build Yours

Open the sheet with your contacts and past clients, head to lovespreadsheets.com, and describe how relationships turn into engagements in your practice. In about 20 minutes, keeping warm stops depending on memory — and starts looking like the system your network deserves.