Guides

How to Build a Simple CRM in Notion (Step-by-Step Guide)

Learn how to build a simple, free CRM in Notion using databases, relations, and views. A step-by-step guide for freelancers, startups, and small teams.

By Sanat Biswal · 2026-08-13 · 7 min read

How to Build a Simple CRM in Notion (Step-by-Step Guide)

If you're a solopreneur, a freelancer, or a small team tired of managing leads across multiple spreadsheets or lost in email threads, you've come to the right place.

Today, we'll look at how to build a simple CRM in Notion that can replace expensive CRM software and give you a clean way to track and manage everything in-house, inside the tool you're probably already using.

This will help you start tracking your contacts, deals, and follow-ups, all organized in one place.

Related Reading: How to Use Notion for Solopreneurs

Why Use Notion for Your CRM?

Before diving in, it helps to understand why so many freelancers and small businesses are switching from expensive, dedicated CRM tools to Notion:

It's free (or very cheap) — Notion's free plan covers what most solo users need, and its paid plans still cost far less than most dedicated CRM software on the market.
It's fully customizable — Notion supports a wide range of field and view types, so you adapt the tool to your workflow instead of adapting your workflow to someone else's CRM.
It combines CRM with everything else — Notes, documents, tasks, and your CRM can all live in the same workspace.
It has no steep learning curve — Getting started with Notion is simple, as long as you know what you want to build.

This makes Notion handy and quick for setting up a simple CRM, but it won't handle advanced needs like bulk email campaigns, deep automation, or advanced reporting the way a dedicated CRM would.

If you're managing a few hundred contacts, though, you likely won't need those advanced features. You can also layer in third-party tools later to add more advanced functionality on top of Notion.

What You'll Need Before You Get Started

Here are the three basic things you need to set up a simple CRM in Notion:

A free or paid Notion account.
A rough list of your current contacts, leads, or clients (even a messy spreadsheet works).
About an hour or two to set everything up.

Here are the steps to follow:

Step 1: Create Your Contacts Database

!Notion Contacts Database Properties

A contacts database is the foundation of your CRM. To set it up:

Create a new page and add a Table database with the following properties:

Name (Title property)
Company (Text property)
Email (Email property)
Phone (Phone property)
Status (Select property: Lead, Prospect, Active Client, Past Client)
Source (Select property: Referral, Website, Cold Outreach, Event)
Last Contacted (Date property)
Next Follow-Up (Date property)
Notes (Text property)
Tags (Multi-select property for industry or priority level)

If you already have a contact list, you can import it as a CSV instead. Notion will map your spreadsheet columns to properties automatically, so you won't need to type everything in by hand.

Related Reading: How to Import CSV into Notion

Step 2: Build a Deals (or Pipeline) Database

!Notion Deals Pipeline Database

Next, create a second database called Deals (or Pipeline) to track opportunities separately from your contacts.

Key properties to include:

Deal Name (Title property)
Associated Contact (Relation property, linked to the Contacts database)
Deal Value (Number property)
Deal Stage (Select property: New, Contacted, Proposal Sent, Negotiation, Won, Lost)
Expected Close Date (Date property)
Probability (optional — Select or Number property)

The relation property is what turns two simple database tables into an actual CRM: it connects each deal back to the right contact, so you can open a contact's page and immediately see every deal tied to them.

Related Reading: How to Use Relations and Rollups in Notion

Step 3: Turn Your Pipeline into a Kanban Board View

!Notion Deals Kanban Board View

Tables are great for storing data, but a visual pipeline is what makes a CRM feel like a CRM.

Add a new view to your Deals database, choose Board, and group it by the Stage property. This creates a drag-and-drop sales pipeline much like the ones built into paid CRM tools, letting you move a deal from one stage to the next — say, from "Negotiation" to "Proposal Sent" — with a simple drag.

Step 4: Add an Activity Log for Tracking Interactions

!Notion Activity Log Database

To keep track of every call, email, and meeting with a contact, add a database called Activity Log with these properties:

Date (Date property)
Type (Select property: Call, Email, Meeting, Note)
Related Contact (Relation property)
Summary (Text property)

For this to work well, embed a filtered view of the Activity Log directly on each contact's page. That way you can see a contact's entire history without digging back through old emails.

Step 5: Build Useful Filtered Views

!Notion Filtered CRM Views

The real power of a Notion CRM comes from custom views that surface exactly what you need, when you need it. A few worth creating:

This Week's Follow-Ups — contacts where Next Follow-Up falls within the next 7 days.
Hot Leads — contacts filtered by Status = Lead and Tags = High Priority.
Deals Closing This Month — deals filtered by Expected Close Date falling within the current month.
Won Deals — deals filtered by Stage = Won, useful for reviewing revenue.

Each view can use a different layout — table, board, calendar, or gallery — depending on how you want the information presented.

Step 6: Automate the Repetitive Parts

This is where you set up automations that handle repetitive tasks for you, saving time and keeping the system consistent. A few worth implementing right away:

Templates — Create a "New Contact" template with default properties pre-filled, so adding a lead takes seconds. Set it as the default template so every new page uses it automatically.
Formulas — Add a formula property that calculates "Days Since Last Contact," then filter or highlight anyone who's overdue.
Reminders — Use Notion's built-in date reminders on the Next Follow-Up property to get notified automatically.
Generate PDFs — A tool like PDFOutput can automate PDF generation — invoices, contracts, proposals — directly from your Notion database using a template. You can also convert Notion pages to PDFs the same way.

Tips to Keep Your Notion CRM Organized

Update the Status and Stage fields as soon as an interaction happens — a CRM is only useful if the data stays current.
Keep Status and Stage options limited to 4–6 choices; too many options makes filtering harder, not easier.
Review your Hot Leads and Follow-Ups views weekly, not just when you happen to remember.
Archive past clients and lost deals instead of deleting them — historical data is useful for reporting later.

Should You Use a Notion CRM Template Instead?

If building from scratch feels like too much setup, use Notion's template gallery instead. It has dozens of free and paid CRM templates you can duplicate and customize in minutes — a quick way to get a structured CRM without building every database by hand.

Frequently Asked Questions

Is Notion good for CRM?

Yes, especially for freelancers, solopreneurs, and small teams managing a moderate number of contacts and deals. It's less suited to large sales organizations that need advanced automation and integrations out of the box.

Is a Notion CRM free?

Yes. Notion's free plan supports the databases, relations, and views needed to build the CRM described above. You'll likely only need a paid plan once your team grows or you need more advanced permissions.

Can Notion replace Salesforce or HubSpot?

For small operations, often yes. For larger sales organizations that need dedicated pipeline forecasting, bulk email tools, and deep reporting, a dedicated CRM is usually still worth the cost.

Final Thoughts

Building a simple CRM in Notion doesn't require any technical skill — just two connected databases, a handful of filtered views, and the discipline to keep your data current.

Start with the Contacts and Deals databases above, add the Kanban pipeline, and layer in automations once the basics are working.

For most freelancers and small teams, this lightweight setup is all it takes to stop losing track of leads and start closing more deals.

If you need help setting up anything in Notion, reach out at notionformyuse@gmail.com and I'll be happy to help.