The average small business CRM story goes like this. The business starts with leads tracked in a spreadsheet. The spreadsheet grows unwieldy. Someone suggests a CRM tool. The team tries Hubspot, finds the free tier too limited and the paid tier too expensive. They try Pipedrive, which is good but does not integrate with their notes or documents. They try Notion and build something that works for three weeks until it falls apart because it was not structured properly from the start.
The problem is not Notion. The problem is that building a CRM in Notion requires understanding three specific database patterns — and most guides skip the architecture in favour of screenshots of pretty layouts. This guide does the opposite. The architecture first, the interface second.
To build this yourself, you need a Notion workspace. Create your free account here. If you want the system already built, the Sales CRM for Business template has everything below configured and connected.
Why Most CRMs Fail Small Businesses
Dedicated CRM tools are built for sales teams with defined processes, predictable pipelines, and the time to input structured data consistently. Small businesses rarely have any of those things. A freelancer’s sales process is a conversation, not a funnel. A consulting firm’s deals take months of informal relationship-building before anything looks like a pipeline stage. A small agency’s “leads” are referrals from existing clients who might mention an opportunity in passing.
The rigidity that makes a CRM powerful for a sales team makes it friction-heavy for a small business. Fields that must be filled. Stages that do not match how the business actually sells. Dashboards that report metrics nobody looks at. The result: the CRM gets used inconsistently, becomes an inaccurate picture of reality, and gets abandoned in favour of a spreadsheet that at least accurately reflects what is there.
A Notion CRM is different because it is built around how you actually work, not how a software vendor thinks a sales process should work. The databases, properties, stages, and views are all defined by you — matching your actual pipeline rather than a generic template of what a pipeline should look like.
What Notion Offers That Dedicated CRMs Do Not
Three things. First: each contact, company, and deal record is a full Notion page. Your notes from a call, the brief they sent, the proposal you wrote, and the email thread summary all live on the same page as the structured CRM data. No switching between a CRM and a notes app.
Second: the database is fully customisable without code or admin access. Add a property, rename a pipeline stage, create a custom view — all in seconds with no developer involvement. Small businesses change how they sell. A Notion CRM changes with them.
Third: the CRM lives in the same workspace as your projects, tasks, and documents. When a deal closes, the client record links directly to their project. The project links to their invoices. The whole business picture is connected, not siloed.
The Foundation: Your Contacts Database
Create a Contacts database. One row per person. Properties: Full Name (title), Company (Relation to the Companies database you will create next), Role (text), Email (email), Phone (phone), LinkedIn (URL), Source (Select: Referral, Cold Outreach, Event, Social Media, Inbound, Partner), Status (Select: Lead, Active, Past Client, Partner, Do Not Contact), and Last Contacted (date).
Add a Days Since Last Contact formula: dateBetween(now(), prop("Last Contacted"), "days"). This number, visible in the table view, tells you at a glance which relationships are going cold without any manual tracking. A contact you have not spoken to in ninety days is a relationship at risk. The formula makes that visible without requiring you to remember when you last spoke to anyone.
Views: Active Contacts (filtered to Status = Active or Lead), Needs Follow-Up (filtered to Days Since Last Contact is greater than 30 and Status is not Past Client or Do Not Contact), and By Source (grouped by Source to see where your contacts originate).
The Companies Database
Create a Companies database. One row per organisation. Properties: Company Name (title), Industry (Select), Size (Select: Solo, 2–10, 11–50, 51–200, 200+), Website (URL), Location (text), Status (Select: Prospect, Active Client, Past Client, Partner), and Annual Revenue Range (Select — optional, for deal sizing context).
The Companies database is the parent level of your CRM hierarchy. Companies have Contacts (multiple people per company). Contacts are involved in Deals. This three-level structure — Company, Contact, Deal — mirrors how B2B relationships actually work: you sell to companies, you communicate with contacts, and any given company might have multiple deals in different stages simultaneously.
Add Rollups to the Companies database: Total Contacts (count of related contacts), Total Deal Value (sum of deal values from related deals), and Active Deals (count of deals in active stages). Open any company record and you see the full relationship: who you know there, what you have sold them, and what is currently in progress.
The Deals Pipeline: Where Revenue Lives
Create a Deals database. One row per opportunity. Properties: Deal Name (title), Company (Relation), Primary Contact (Relation to Contacts), Stage (Select: Discovery, Proposal, Negotiation, Closed Won, Closed Lost, On Hold), Value (number, currency), Close Date (date), Probability (number, percentage), Expected Revenue (formula: prop("Value") * prop("Probability") / 100), and Source (Select — same options as Contacts source).
The Board view grouped by Stage is the primary pipeline view. Every deal is a card. Moving a deal from Discovery to Proposal is one drag. Closing a deal is moving it to Closed Won. The visual pipeline makes the state of your business development immediately readable — without opening any individual record.
The Expected Revenue formula multiplies deal value by probability. Summing Expected Revenue across all active deals (using the table view’s Calculate row) gives you a weighted pipeline value — a more realistic revenue forecast than simply summing all open deal values at face value. This is the metric that tells you whether your pipeline is healthy enough to hit your revenue targets.
Add a Closed This Month view filtered to Stage = Closed Won and Close Date = this month. This view shows your actual sales performance for the current period — the ground truth of what your business development efforts are producing.
The Activities Log
Create an Activities database. One row per interaction. Properties: Activity Name (title — usually a brief description like “Intro call with Sarah” or “Proposal sent”), Type (Select: Call, Email, Meeting, Demo, Proposal, Contract, Follow-up), Contact (Relation), Deal (Relation), Date, Notes (text), and Next Step (text).
The Activities log is the audit trail of your sales process. Every meaningful interaction with a prospect or client gets logged here. The linked view of Activities on each Deal page shows the complete history of that deal — every call, every email, every proposal — in chronological order. When a deal goes quiet and you need to pick it back up six weeks later, the activity log tells you exactly where you left off and what the agreed next step was.
Add a Next Actions view filtered to Next Step is not empty and Date is before today — showing every overdue follow-up in one place. This view is the daily action list for your business development effort: the things you said you would do and have not done yet.
Connecting Everything: The Relation Architecture
The four databases connect in a specific pattern. Companies relate to Contacts (one company, many contacts). Contacts relate to Deals (one contact can be involved in multiple deals). Deals relate to Activities (one deal has many activities). Activities relate back to both Contacts and Deals.
This means: open a Company and see all their contacts and all their deals. Open a Contact and see all their deals and all their activities. Open a Deal and see the contact, the company, and the full activity history. Open an Activity and navigate to the deal it belongs to. Every record is a hub that connects to every other relevant record — no orphaned data, no broken trails.
The CRM Dashboard
A home dashboard with five linked views: Active Pipeline (Deals filtered to open stages, sorted by Close Date), Needs Follow-Up (Contacts with Days Since Last Contact over 30), Overdue Next Actions (Activities with past dates and non-empty Next Step), Closed This Month (Deals closed won this month), and New Leads This Week (Contacts added this week).
This dashboard answers the five questions that matter in any sales operation: what is in the pipeline, who needs attention, what actions are overdue, what have we won, and what new opportunities have arrived. Opening Notion first thing in the morning gives you the complete business development picture in under thirty seconds.
The Daily CRM Workflow
The system works when it becomes a habit rather than a task. The daily habit is simple: after every meaningful interaction with a prospect or client, add an Activity record. Takes two minutes. Keeps the audit trail current. Ensures the Next Actions view always shows what actually needs doing.
Once a week, review the pipeline board. Move deals to their correct stage. Update Close Dates on deals that have shifted. Check the Needs Follow-Up view and make contact with anyone who has gone quiet. The weekly review takes fifteen minutes and keeps the CRM accurate rather than letting it drift into a historical record of where deals were rather than where they are.
Where Notion CRMs Have Limits
Email integration does not exist natively. You cannot see emails in Notion the way you can in Salesforce or Hubspot — you log them manually as Activity records, which adds friction. For businesses where email volume is high and manual logging is impractical, a dedicated CRM with email sync is more appropriate.
Automation is limited. Notion cannot automatically move a deal to the next stage when a proposal is sent, or send a follow-up reminder when a deal has been inactive for two weeks, without third-party automation tools like Make or Zapier. If your sales process relies on automated sequences and triggers, Notion requires automation middleware to replicate that behaviour.
For businesses with ten or fewer salespeople, pipelines with under fifty active deals, and sales processes that involve significant relationship management and documentation alongside the structured pipeline data, Notion is an excellent CRM. For high-volume, highly automated sales operations, it is a starting point rather than a final destination.
The Sales CRM for Business template has all four databases described above already built, connected, and documented — with views for every workflow situation and a user manual explaining how the architecture works. If you want a working Notion CRM today rather than an afternoon building one, it is the fastest starting point.
Disclosure: This post contains affiliate links. If you sign up for Notion through the links in this post, we may earn a small commission at no extra cost to you. All opinions are our own.
0 Comments