Notion as a CRM — How to Enrich It and Track Deals Like the Pros

Notion as a CRM — How to Enrich It and Track Deals Like the Pros

There's a stage in every early-stage company where the founder tries Salesforce, recoils, and ends up running the sales pipeline out of a Notion database. It's the right call. Hubspot Free is great if you outgrow Notion; Salesforce is overkill for the first thirty deals; spreadsheets lose history; Airtable charges for it.

Notion gets you to product-market-fit pricing with no CRM bill, no admin, and no implementation project.

The catch is that Notion's CRM mode is missing two things the proper CRMs ship with: enrichment (so contacts come pre-tagged with industry, headcount, and revenue), and analytics (so you can chart pipeline health over time, not just look at it). This post is about how to add both, without giving up Notion.

Step 1 — The Schema

A real Notion CRM has at minimum three databases:

Companies. One row per account. Properties: Name, Domain, Industry, Headcount, Country, ARR (or revenue bucket), ICP tier, Status, Owner.

Contacts. One row per human. Properties: Name, Email, Title, LinkedIn URL, Company (relation → Companies), Owner.

Deals. One row per opportunity. Properties: Name, Company (relation → Companies), Stage, Amount, Probability, Expected Close Date, Owner, Source, Notes.

Pro tip: if you only have one of these, make it Deals. Companies and Contacts can grow out of it later. A deals database without context still gives you pipeline analytics; a companies database without deals doesn't.

Stage column choices matter. The most useful stages for an early-stage B2B funnel are: Inbound, Discovery, Demo, Proposal, Closed-Won, Closed-Lost. Six stages, no more — every stage you add halves the rate at which deals can transition cleanly, which makes the analytics noisier.

Step 2 — The Enrichment

The reason real CRMs feel different from a Notion database is enrichment. When a contact gets added to Salesforce, the company auto-fills with industry, headcount, location, and revenue range. The rep doesn't type any of that. Notion ships with none of it.

There are three practical ways to add enrichment to a Notion CRM:

1. AI enrichment via Notion Buttons / formulas. Newer Notion AI features can fill in fields based on the company domain. Reliable for industry and short descriptions; less reliable for headcount and revenue. Free if you're already paying for Notion AI.

2. Manual fill-in from a paid enrichment provider. Clearbit, Apollo, ZoomInfo, RB2B, Datafast, etc. Many have free tiers that let you enrich a handful of contacts per month. Workable for tens of contacts, painful for hundreds.

3. Integration tools that sync enrichment. Several Zapier/Make-style workflows watch for new rows in a Notion database, call an enrichment API, and write the results back. This is the "pros" path — it auto-fills on new entry and is the closest thing to Salesforce behaviour you'll get without a CRM.

The right answer for a 10-person team is usually option 1 plus option 3 for the highest-volume entry path. Free tier for trickle-in contacts; sync workflow for the one bulk-imported source.

Step 3 — The Pipeline Analytics

This is the part where Notion-as-a-CRM teams quietly suffer. The database itself shows the present state of the pipeline. There is no built-in concept of pipeline last week or pipeline last month. Standard CRM reports — coverage ratio, stage conversion, deal velocity, weekly closed-won — all require comparing the present to the past, and Notion doesn't remember the past.

Most teams who hit this gap try one of:

• Manual screenshots into a Slack channel every Monday. Decays inside a quarter.
• CSV export to Sheets and pivot. Decays inside a quarter unless you're very disciplined.
• Move off Notion to Hubspot Free. Works, but you lose all the reasons you picked Notion in the first place — speed of customisation, the relations to other Notion docs, the shared workspace muscle memory.

The fourth option is to layer analytics on top of Notion without moving the data. That's what Chartcastr does for the CRM use case: pick the Deals database, let the AI suggest CRM-shaped charts, schedule them to Slack.

The CRM Charts a Notion-Based Sales Team Actually Needs

If you're building this on top of a Notion CRM today, here are the six charts that earn their place in a weekly cadence:

1. Pipeline by stage. Stacked bar of Amount summed by Stage. Filter out Closed-Won and Closed-Lost. Tells you where the pipeline is concentrated. If 70% of pipeline is in Discovery, that's a different problem than 70% in Proposal — the chart surfaces it without anyone having to ask.

2. Weekly closed-won. Line chart of summed Amount filtered to Closed-Won, grouped by week of the Expected Close Date (or actual close date if you track it). Drives the weekly leadership question: are we trending up or down on revenue.

3. Pipeline coverage ratio. Open pipeline divided by quarterly target. One number, tracked over time. If coverage drops below 3x, you have a prospecting problem; below 2x, you have a forecast problem.

4. Deal velocity by stage. Bar chart of average days-in-stage per Stage. Tells you where deals stick. Most B2B teams have one stage that's secretly 3x longer than every other — knowing which one is a coaching moment.

5. New pipeline created per week. Line chart of count of new Deals rows per week. Leading indicator that things have stopped or started. The earliest sign that prospecting is slipping.

6. Win rate by source. Bar chart of Closed-Won divided by total closed (won + lost), broken down by Source. Tells you which channels are giving you good-fit deals vs. tire-kickers. Affects where the marketing budget goes.

All six of these can be set up on a Notion CRM in about ten minutes with the free Notion chart tool — pick the Deals database, let the AI propose the chart, refine the title, schedule to Slack.

A Note on Forecasting

Forecasting from a Notion CRM is the one analytics task where leaving the data in Notion stops being the right call. Weighted pipeline forecasts that age probability by stage and account for slippage need real modelling — formulas, what-ifs, sensitivity analysis. Sheets or a forecasting tool is the right tool for that work.

The good news: the forecast model can read from your Notion CRM. You don't have to move the data permanently — just feed the model with an export at the start of each forecasting session. The operational analytics (the six charts above) keep flowing out of Notion automatically; the forecast pulls a snapshot when needed.

When to Graduate Off Notion

If you outgrow Notion as a CRM, you'll know. The signals:

• More than three people editing the pipeline daily. Concurrent editing is fine; concurrent interpretation of the schema gets ambiguous fast.
• Multi-pipeline orgs. One pipeline per team works in Notion; the relation/rollup mechanics get complex if you have five.
• Deals with complex products (multi-line, multi-currency, recurring + one-off). The flat row model creaks.
• Compliance requirements that demand audit trails on every field edit.

For the first 100 deals or the first $1M ARR, Notion + enrichment + Chartcastr-style analytics is genuinely competitive with a junior CRM. By $10M ARR, you'll have outgrown it on at least two of the four signals above.

The Takeaway

You don't need to suffer through Salesforce to run a real sales pipeline. A Notion CRM with enrichment and a layer of recurring analytics will get you to product-market-fit at a fraction of the cost. The historical insight gap is the only meaningful weakness, and it's the easiest one to fix — let a chart tool snapshot for you each pulse, deliver the charts to where the team already talks (Slack, email), and you're running a real pipeline by Monday morning.

If you want to try it, the free Notion chart tool is the fastest path to the first chart. Pick the Deals database, let the AI pick the chart, and ship it to your sales channel. The rest of the CRM hardening can come later.