How to Use Notion as a Full CRM for Your Sales Pipeline

Most salespeople get a CRM recommended to them — Salesforce, HubSpot, Pipedrive — and spend the first week setting it up, the second week complaining about it, and the third week ignoring it entirely. The tools are powerful, but they're built for teams, not individuals. They assume a sales ops person. They assume training. They assume you want to pay $80/month before you've closed a single deal.

Notion costs nothing to start, takes an afternoon to build, and does 90% of what a paid CRM does for a solo founder or small sales team. More importantly, it does it in a way you'll actually use — because you built it yourself, exactly the way you think. This guide shows you how.

Watch the Video First

The walkthrough below follows this tutorial closely. Watch it for the full visual setup, then use this guide to move at your own pace or reference specific steps.

https://www.youtube.com/watch?v=aLsW4WkuAuk

What You'll Need

• A free Notion account — the free plan handles everything in this guide

• Your existing lead list (if you followed Post 02, export it from Google Sheets as a CSV — Notion can import it directly)

• 60–90 minutes to build and populate it the first time

• A clear definition of your pipeline stages before you start — more on this in Step 1

The Five Pipeline Stages You'll Build

Before touching Notion, decide what your stages are. Every pipeline is different, but most solo sales processes map to some version of this:

Prospect → Contacted → Qualified → Proposal Sent → Closed (Won/Lost)

You'll create these as select options in your Notion database. They become the columns on your Kanban board and the filter options on your table view. If your process has more nuance — a discovery call stage, a demo stage, a negotiation stage — add them. Just don't add stages you don't actually use. Empty columns are demoralising.

Step-by-Step: Building Your Notion CRM

Step 1 — Create your pipeline database

Open Notion and create a new page. Title it something you'll want to open: "Pipeline," "Deals," "Sales Tracker" — not "CRM" (nobody opens something called CRM).

Click the / command and select Database — Full Page.

This creates a table with a default set of columns. You'll replace those with your own.

Delete the default columns and add these:

This is your master table. Every other view you create in the next steps pulls from this same database — you enter data once and it appears everywhere.

Step 2 — Build your Kanban board view

The table view is great for bulk editing. The board view is what you'll actually stare at every morning.

Click + Add a view at the top of your database. Select Board. Set the grouping to your Stage property. Notion will create a column for each stage value you defined.

Each card on the board represents one deal. By default it shows the contact name and company. To customize what appears on the card, click the card, then click the three dots → Properties and toggle on the fields you want visible — Deal Value and Next Action are the most useful at a glance.

Set up color coding: Click the Stage property → Edit property → add a color to each stage. Green for Closed Won, red for Closed Lost, neutral tones for everything in between. Visual differentiation makes the board scannable in seconds.

Step 3 — Create a filtered "Active Deals" view

Your main board will eventually include closed and lost deals, which creates noise. Build a clean view that shows only what's live.

Click + Add a view → Board → name it "Active Pipeline." Then click Filter → Add filter → Stage → does not contain → Closed Won, Closed Lost.

Now your active view only shows deals in motion. Bookmark this page — it's the one you open every morning.

Step 4 — Build a "Follow-up Due" table view

One of the most powerful things about a Notion CRM is the ability to surface what needs your attention today. Create a filtered table view for this.

Click + Add a view → Table → name it "Follow-up Due." Add two filters:

• Last Contacted is before: @Today - 3 days (or however many days your follow-up window is)

• Stage does not contain: Closed Won, Closed Lost

Now sort by Last Contacted ascending (oldest first). This view shows you every deal you haven't touched in 3+ days, in order of how long it's been neglected. Open it at the start of the week. Work down the list.

Step 5 — Set up your weekly pipeline review template

The best CRM habits are built around a routine. Create a linked database view inside a recurring weekly note.

In Notion, create a new page called Weekly Review Template. Inside it, type /linked view and link to your pipeline database — filtered to Active Pipeline only. Now every week when you create your review note (or use Notion's template repeater), you have your pipeline embedded directly in the page where you do your thinking.

Add three questions below the embedded view:

1. What moved forward this week?

2. What's stuck, and why?

3. What are my top 3 actions for next week?

This turns your CRM from a record-keeping tool into an actual management system. The database holds the data. The weekly review is where you make decisions from it.

Step 6 — Import your leads from Google Sheets

If you've been building your lead list in Google Sheets (Post 02), you don't have to re-enter everything manually.

Export your Google Sheet as a CSV: File → Download → Comma-separated values.

In Notion, open your pipeline database → click the three dots (...) in the top right → Import → CSV. Notion will map your CSV columns to your database properties. The mapping won't be perfect — Company and Contact Name will likely need manual correction — but it will get 80% of the data in cleanly.

Spend 10–15 minutes cleaning up the imported records, filling in missing Stage and Priority values, and adding Next Action notes for your top-priority deals.

Step 7 — Add a contacts database and link it

For simple pipelines, one database is enough. But if you're tracking multiple deals per company, or want to keep a contact record separate from a deal record, link a second database.

Create a new full-page database called Contacts. Add a Relation property to your Pipeline database that links to Contacts. Now when you open a deal, you can link it to a contact record — and opening the contact shows all deals associated with that person.

This is where Notion starts to genuinely outperform a simple spreadsheet. Relational databases are complex to build from scratch; in Notion, it's a 5-minute setup.

Pro Tips

The "Next Action" field is the most important column in your CRM. Most pipelines stall not because leads aren't interested — but because the salesperson doesn't know what to do next. Make it a rule: every deal in your pipeline must have a populated Next Action field. If a deal has a blank Next Action, that's the sign something is stuck.

Use the board view to feel momentum, the table view to work. The board is for energy — seeing deals move across stages, visualizing your pipeline at a glance. The table is for bulk operations — updating multiple deals, filtering, sorting. Use both. Don't live in just one.

Review your pipeline on the same day every week. Not when you feel like it. Not when you're running out of leads. Every week, same day. A pipeline that gets reviewed consistently compounds. One that gets reviewed occasionally decays.

---

Learning Lab is a series of short, practical how-to guides built around the best YouTube tutorials for sales professionals and entrepreneurs. Each post embeds the source video and walks you through it step by step.