DEV Community

Otto
Otto

Posted on

How to Build a Free CRM for Freelancers in Notion (No Subscriptions Ever)

#freelancing #productivity #notion #career

How to Build a Free CRM for Freelancers in Notion (No Subscriptions Ever)

Every freelancer needs a CRM. But paying $50-100/month for HubSpot or Salesforce when you're solo? Overkill.

Here's the system I built in Notion that handles my entire client pipeline — for free.

Why Notion Over Dedicated CRM Tools

Notion isn't a CRM out of the box. But with a properly designed database, it beats most paid CRMs for solo freelancers because:

  • Zero monthly cost (free tier is enough)
  • Fully customizable — track what matters to YOU
  • Connected to your whole workspace (projects, invoices, notes)
  • Available on every device

The 5 Databases You Need

1. Contacts Database

Track every lead and client with:

  • Status (Lead, Prospect, Active Client, Past Client, Cold)
  • Company, Role, Budget range
  • Last contact date
  • Source (How did they find you?)
  • Relations to Projects and Deals

2. Deals Pipeline

Your sales funnel in a Kanban view:

  • Discovery → Proposal Sent → Negotiating → Won / Lost
  • Deal value, probability, expected close date
  • Linked contact and notes

3. Projects Database

Active work tracking:

  • Status, deadlines, deliverables
  • Linked to client
  • Hours logged vs estimated

4. Interactions Log

Never forget a conversation:

  • Date, type (email/call/meeting/DM)
  • Key points discussed
  • Next action + due date

5. Follow-Up Tracker

The money is in the follow-up:

  • Contacts due for follow-up (filtered view)
  • Last contact date + days since
  • Priority level

The Kanban Pipeline View (This Changes Everything)

Create a Board view of your Deals database, grouped by Stage. At a glance you see:

  • 3 leads in Discovery
  • 1 proposal pending answer
  • 2 projects in negotiation

This is your revenue pipeline. Check it every Monday.

The Weekly Review System

Every Monday, 15 minutes:

  1. Open Deals Pipeline → move stalled deals, add next actions
  2. Check Follow-Up Tracker → who haven't you contacted in 2+ weeks?
  3. Review Active Projects → on track? Any blockers?
  4. Log last week's wins → what closed? What revenue came in?

This simple habit keeps your pipeline full and prevents dry spells.

Formula: Calculate Your Pipeline Value

In your Deals database, add a formula property:

prop("Deal Value") * prop("Probability") / 100
Enter fullscreen mode Exit fullscreen mode

Sum all weighted values → that's your realistic expected revenue for the next 30-60 days.

If it's too low, you need to fill the pipeline NOW, not when you finish current projects.

Template Tips for Real Usage

Color coding for urgency:

  • 🔴 Follow up overdue (>14 days no contact)
  • 🟡 Follow up due soon (7-14 days)
  • 🟢 Recently contacted

Linked views:

  • From a Client page, see ALL their projects and interactions
  • From a Project page, see the client details immediately

Automation trigger:
When a Deal moves to "Won", create a linked Project automatically (using Notion automations).

The Reality Check

Most freelancers lose clients not because of bad work — but because they forget to follow up. A client you talked to 3 months ago might be ready to hire now. But they called someone else because that person checked in.

Your CRM's main job is simple: make sure you never lose a relationship because you forgot to reach out.

Want a pre-built version of this system? The Freelancer OS Notion Template includes the full CRM setup + project management + financial dashboard in one workspace.

👉 Get the Freelancer OS Template — €19

Zero subscriptions. Buy once, use forever.

Tags: notion, freelancing, productivity, career

Top comments (0)