How to Build a Lead Tracking CRM in Notion That Actually Closes Deals

Most small businesses lose 50% of potential revenue because leads slip through the cracks. This post shows exactly how to build a lead tracking CRM in Notion that keeps deals moving—from first contact to closed sale. You'll walk away with a working system (not theory) that costs $0 and scales with your business.

Why Notion for CRM Instead of Dedicated Tools?

Here's the thing: Salesforce and HubSpot are powerful. They're also expensive, bloated, and require a certification just to set up properly. For startups and small teams burning cash on product development, a $1,200/year CRM subscription is money that could hire a contractor or buy ads.

Notion handles CRM basics remarkably well. Databases, relations, rollups, and views give you 80% of what $100/month tools offer—without the sales calls. The catch? You have to build it right. A sloppy Notion setup becomes a digital junk drawer faster than you can say "follow-up."

Teams under 10 people typically outgrow spreadsheets but aren't ready for enterprise software. Notion fills that gap. It also consolidates your wiki, docs, and CRM in one place—fewer tabs, less context switching.

What's the Best Structure for a Notion Lead Tracking Database?

The best structure uses a single master database with filtered views for different stages, not separate databases for leads and deals. One database. Multiple views. That's the secret.

Start with these properties:

Worth noting: Keep it lean. Twenty properties look impressive but slow you down. If you're not using it weekly, delete it.

How Do You Create Views That Actually Drive Action?

Create four specific views: a pipeline board (grouped by status), a follow-up list (sorted by last contact), a calendar (expected close dates), and an "action this week" filter (deals needing attention).

The pipeline board is your war room. Group by Status, drag cards left to right. Visual progress keeps momentum alive. Set up conditional formatting—deals untouched for 14 days turn red. Shame is a powerful motivator.

The follow-up list prevents the classic "oh crap, I forgot about them" moment. Filter by Last Contact > 7 days ago. Review it every Monday morning. Five minutes. No exceptions.

Calendar view shows expected close dates. It's humbling. You'll notice 80% of your pipeline supposedly closes this Friday. (It won't.) Spread those dates out. Be honest about timelines.

The "action this week" view is your daily driver. Filter: Status is not Closed Won/Lost AND (Last Contact is empty OR more than 5 days ago). These are the deals that need your thumbs on the keyboard today.

What Formulas Make This CRM Actually Useful?

Raw data is useless. Formulas turn your database into a decision-making machine. Notion's formula syntax is quirky—think Excel from 2003—but it works.

Add a Weighted Pipeline Value property:

prop("Deal Value") * (parseInt(replaceAll(replaceAll(prop("Probability"), "%", ""), "90", "90")) / 100)

This shows realistic revenue. A $10,000 deal at 25% probability counts as $2,500. Sales managers at Salesforce call this "pipeline coverage." It's how you know if you'll hit quota.

Add a Days Since Contact formula:

dateBetween(now(), prop("Last Contact"), "days")

Now filter views by "Days Since Contact > 7" for your follow-up list. Automated guilt.

Add an Expected Revenue formula combining deal value with close probability and expected date. This feeds dashboard charts. Yes, Notion does charts now—bar graphs, line trends, the works. Visual beats spreadsheet every time.

How Does This Compare to Real CRM Software?

Fair question. Here's the straight comparison:

That said, Notion loses on email integration. You won't get automatic logging or open tracking. Workaround? A browser extension like Mailtrack for Gmail, then manually update Last Contact. Extra step? Yes. But you're saving $2,000+ annually.

When you outgrow Notion (around 15-20 active deals per person), migrate to Pipedrive or Close. Export your database as CSV. Import elsewhere. The data structure translates cleanly.

What Templates and Workflows Keep Deals Moving?

Templates standardize your process. Create a "New Lead" template with pre-filled sections: Company Research, Contact History, Discovery Questions, Proposal Notes, and Next Steps. Every new lead gets the same structure. No more blank page syndrome.

Build an intake form for your website. Notion forms (yes, they exist now) capture leads directly into your database. Set Status to "New Lead" automatically. Add a Slack notification so someone actually sees it.

The real workflow magic? Weekly pipeline reviews. Block 30 minutes every Friday. Sort by Expected Close date. Update probabilities based on actual conversations (not hope). Move stalled deals to "Closed Lost" if there's been 30 days of radio silence. Pipeline hygiene prevents fantasy forecasting.

Set up a simple scoring system in a formula: Company Size (1-3) × Budget Clarity (1-3) × Decision Timeline (1-3). Leads scoring 20+ get priority. Everything else waits. HubSpot's lead scoring guide explains the methodology if you want to get fancy.

Common Mistakes That Kill Notion CRMs

Too many properties. People build 30-field monsters nobody fills out. Start with 8-10. Add only when pain appears.

No owner assigned. "Someone else is handling it" means no one is. Every lead needs a person. Use the Assigned To property. No exceptions.

Status bloat. "New," "Contacted," "Connected," "Engaged," "Interested," "Qualified"—too granular. Five stages max. New → Qualified → Proposal → Negotiation → Closed. Done.

Ignoring the Last Contact date. That field is worthless if you don't update it. Make it a habit: send email, update date. Send email, update date. Muscle memory.

Not using reminders. Notion doesn't have native CRM reminders (the catch?), but you can hack it. Create a "Follow-Up Due" formula that turns true when Days Since Contact > your threshold. Filter a view by that. Check it daily.

Quick Setup Checklist

1. Create a new database called "Sales Pipeline"
2. Add the 9 core properties from the table above
3. Set up Status options: New Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost
4. Create Board view grouped by Status
5. Create Table view filtered to show only your assigned leads
6. Add the Weighted Pipeline Value formula
7. Build a "Stalled Deals" view (Last Contact > 14 days)
8. Create page templates for consistent note-taking
9. Set a weekly calendar block for pipeline review
10. Share with your team and add comment permissions

Your CRM is only as good as the data you put in. A mediocre system used religiously beats a perfect system abandoned after week two. Start simple. Stay consistent. Close more deals.