CRM for Freelancers: Free, Built on Google Sheets with AI

Freelancing has a rhythm everyone warns you about and nobody escapes: when you're busy delivering, you stop selling. Then the project ships, the calendar goes quiet, and you scroll back through old emails looking for that person who said "let's talk in a few weeks" — six weeks ago.

The information was never lost. It was sitting in a Google Sheet the whole time: a proposal you sent on the 3rd, an invoice due on the 15th, a warm intro you meant to chase. But a sheet doesn't tap you on the shoulder. It waits politely in a tab while you miss the follow-up window, and it definitely doesn't tell you that two clients still owe you money while you're quoting a third at a discount because cash feels tight.

The standard fix — subscribe to a CRM — is a hard sell when you're a business of one. Another monthly fee, another tool built for sales teams with quotas and managers you don't have. There's a cheaper route: keep the sheet, and have AI build a small CRM on top of it. Free tier, no migration, about 20 minutes.

Step 1: Start With Your Client Sheet

No restructuring required. One row per piece of work is plenty. A solid freelancer setup looks like this:

The Status column carries the pipeline. Something like Lead → Proposal sent → Won → Delivering → Invoice sent → Paid covers the whole life of a gig, from first hello to money in the bank. Notice that "Paid" is a stage, not an afterthought — for a freelancer, the deal isn't done when you win it; it's done when it clears.

Step 2: Create a Free Account

Sign up at lovespreadsheets.com. The free plan builds and runs the whole thing. Paid features — team logins, a custom domain — mostly matter once you're no longer solo.

Step 3: Describe How You Actually Work

Choose the CRM template and explain your world in plain English, the way you'd brief a virtual assistant:

• "Every row is one project for one client. Work moves Lead → Proposal sent → Won → Delivering → Invoice sent → Paid."
• "If a row has a follow-up date, it's a promise. Surface anything due today or overdue before everything else."
• "Value is what the project pays. I want to see total value by status so I know what's real money versus maybe money."

Three asks that earn their keep for solo work:

• Follow-up nudges — a reminder tied to the follow-up date column, so proposals stop dying of silence
• A "waiting on payment" view — every row sitting in Invoice sent, oldest first, with amounts totaled
• A pipeline-versus-capacity glance — what's in Delivering next to what's in Proposal sent, so you know whether to sell harder or stop selling

Upload the sheet and run it. If your description rambles, the AI Optimize button will tighten it, and the AI might ask one or two clarifying questions before building. Expect roughly 15–20 minutes.

Step 4: A Business Dashboard for a Business of One

You get a URL. Behind it: your gigs as a pipeline board, each client clickable, follow-ups sorted by urgency, unpaid invoices totaled at the top. Everything reads from and writes to the sheet in real time — log a call in the app on your phone, and the row updates; fix a typo in the sheet, and the app reflects it.

Nothing about your workflow has to change on day one. You just stop relying on memory for the parts of freelancing that pay the rent.

Why Freelancers Keep the Sheet

Zero recurring cost, which is the whole point. A $29/month CRM is $348 a year — a real number when your income arrives in lumps. Building on your own sheet costs nothing to run.

Your history is your asset. Every past client, rate, and outcome already lives in that sheet. Move to a proprietary CRM and that history is behind someone else's export button. Here, the sheet never stops being yours.

Feast-or-famine is a visibility problem. The cycle happens because selling is invisible while delivering is loud. A pipeline you glance at daily — with nudges that fire whether or not you're busy — is the cheapest smoothing mechanism there is.

Common Questions from Freelancers

I only have a dozen clients. Is this overkill? Twelve clients is exactly when follow-ups start slipping — enough to forget, too few to afford forgetting. The build takes 20 minutes either way.

Can it remind me before an invoice goes overdue? Yes. Ask for reminders on your date columns — follow-ups, invoice due dates, or both.

What happens if I hire a subcontractor later? Share the URL. Paid team logins exist when you want them to see only their projects, but the sheet-plus-app setup grows with you.

Build Yours

Open the sheet where your clients already live, go to lovespreadsheets.com, and describe how a gig moves from first email to paid invoice. Twenty minutes later, the next "let's talk in a few weeks" actually gets talked to in a few weeks.