Start hereConsultant OS ToolsComparePlaybooks Resources Media Kit Finance Stack ↗ Get the $97/mo OS

Implementation Guide · CRM · Layer 2 · Brief 15

Notion CRM Setup Guide
for Solo Consultants.

Most Notion CRMs fail for one reason — overdesign. Eight databases, fourteen relations, twenty-two properties per contact. By month two nobody opens it because nobody can remember where to put anything. This guide builds the minimum viable Notion CRM that survives contact with reality: four databases, clear views, specific automation wiring, and an AI layer that makes it smarter over time.

Updated: May 2026 · 20 min read · Verified against Notion's current API and Make/Zapier integration

Overdesign, not underpower.

The standard progression: a consultant builds an initial Notion CRM after watching a YouTube tutorial. The tutorial has 8 databases, 40 properties on Contacts, and advanced rollups for pipeline velocity. It looks impressive. They spend a weekend building it. They use it for 3 weeks. By month 2 it's read-only — too complex to update consistently, not worth the friction to maintain.

The discipline is building fewer things. Every database, property, and view you add costs maintenance over the next 12 months. Add only what survives the question: "Would I actually update this every week?" The four databases in this guide have all passed that test. Everything on the resistance list at the end of this guide has failed it.

Death pattern

8-database CRM

Tasks, emails, documents, meetings, proposals, companies, contacts, deals — all linked. Impressive to build. Impossible to maintain. Abandoned by month two.

This guide

4-database CRM

Contacts. Companies. Deals. Touchpoints. Each with a clear job. Each with essential views only. Updates take 3 minutes per week, not 30.

The rule

Add at month 6

If a capability gap is genuinely painful after 6 months of use, add one new property or view. Never add something because it would be nice to have. Add only what you're actively missing.


Four databases. The complete CRM for a solo consulting practice.

Database 1
Contacts
The atomic record. Every person you've had a meaningful professional conversation with.
12 properties — no more
Name (title)
Status (select: Cold / Warm / Active / Client / Past Client / Dormant)
Company (relation → Companies)
First Contact (date)
Role (text)
Last Touch (date — rollup from Touchpoints)
Email (email)
Notes (text)
Phone (phone)
Deals (relation → Deals)
LinkedIn (URL)
Source (select: Referral / Inbound / Outbound / Event / Other)
Essential views
All Contacts (table) · Active Pipeline (filter: Status = Warm or Active) · Needs Follow-Up (filter: Last Touch > 30 days AND Status ≠ Dormant) · By Company (group by Company)
Database 2
Companies
Separate from Contacts because consulting often involves multiple stakeholders at one company.
Properties: Name (title) · Website (URL) · Industry (select) · Size (select: Solo / 2–10 / 11–50 / 51–200 / 200+) · Contacts (relation, rollup) · Deals (relation, rollup) · Notes (text)

Why not a property on Contact? When one company has 3 stakeholders, a separate Companies database lets you roll up all contacts, all deals, and all revenue under one record. This becomes important at 10+ active clients.
Database 3
Deals
Where money lives. The database HubSpot and Pipedrive readers will be most familiar with.
7 stages: Inquiry → Qualified → Proposal Sent → Negotiation → Won → Lost → On Hold

Properties: Deal Name (title) · Contact (relation) · Company (relation or rollup) · Stage (select) · Value (number, currency) · Expected Close (date) · Actual Close (date) · Next Step (text) · Next Step Due (date) · Notes (text)
Essential views
Pipeline Board (board view by Stage — this is your daily homepage) · Closing This Month (filter: Expected Close in next 30 days) · Stuck Deals (filter: Next Step Due is past) · Won This Year (filter: Stage = Won, current year)
Database 4
Touchpoints
The activity log. Every meaningful email, call, meeting, or DM as a queryable record.
Properties: Title (title) · Contact (relation) · Deal (relation, optional) · Type (select: Email / Call / Meeting / DM / Event / Other) · Date (date) · Notes (text) · Follow-Up Needed (checkbox) · Follow-Up By (date)

Why this exists separately from Notes on Contacts: Notes on contacts get long and unsearchable. Touchpoints give you a queryable history. The "Last Touch" date on Contacts can be a rollup from this database — showing you automatically who you haven't reached in 30+ days.

What NOT to add. The actual hardest part.

This section is the core value of the guide. Most Notion CRM templates fail because they include all of the following. Every item below represents a well-intentioned feature that collapses under the maintenance weight of a real consulting practice.

Tasks database — Use your existing task system. Don't merge tasks and CRM. When tasks live next to deals, you stop updating one of the two. Always the CRM.
Email database — Notion is not an inbox. Sync touchpoints manually or via API. An email database becomes a laggy, half-synced shadow of your real inbox within 3 weeks.
Documents connected to Deals — Keep client docs in a Project workspace separate from the CRM. Mixing reference materials and pipeline data makes both worse.
Multi-step automation with Notion Buttons — Use Make or Zapier. Notion's native automation is too brittle for CRM workflows. Button automations break on schema changes, which happen constantly in early-stage CRMs.
More than 4 Statuses on Contacts — You will not maintain 7. Cold / Warm / Active / Client / Past Client / Dormant is the complete set. If you add "Nurture" and "Prospect" and "Qualified Lead," none of them will mean anything by month three.
Pipeline velocity and conversion-rate rollups — You don't have enough data to make these meaningful in year one. Build them at the 6-month mark if you still want them. Starting with them creates maintenance overhead for metrics you're not using yet.

Five Make scenarios that make Notion a real CRM.

A Notion CRM is most valuable when it's the source of truth — not a duplicate of data living elsewhere. These five Make scenarios are the wiring that converts a well-structured Notion database into a functioning CRM. Build them in this order.

Scenario 1 — highest priority
Calendly booking → Notion Contact + Touchpoint
When someone books a discovery call, check if a Contact with that email already exists. If not, create one. Then create a Touchpoint of type "Meeting" linked to the contact. This eliminates the #1 manual step in CRM maintenance: logging new relationships after a call.
Scenario 2
Stripe invoice paid → Notion Deal stage = Won
When a Stripe invoice marked as paid matches a deal by metadata or amount, advance the Deal stage to "Won" and update the Actual Close date. The deal record is always current — no manual stage updates required after payment.
Scenario 3
Gmail labeled email → Notion Touchpoint
Apply a Gmail label like "crm-log" to any email you want logged. Make grabs labeled emails and creates Touchpoint records with type "Email," the date, and the email subject as the title. Selective — not an inbox firehose.
Scenario 4
Deal "Proposal Sent" → 5-day follow-up reminder
When a Deal stage changes to "Proposal Sent," Make creates a calendar event 5 business days later: "Follow up with [Contact] on [Deal Name] — check if proposal has been reviewed." Never forget a follow-up again.
Scenario 5 — high leverage
Weekly digest → email yourself
Every Monday at 7am, Make queries Notion and emails you: deals with Next Step Due in the past (stuck), deals closing this month, contacts with Last Touch over 30 days in Warm status. The CRM proactively surfaces what needs attention — without opening Notion.

Where Notion beats Pipedrive and HubSpot — by a significant margin.

Because Notion is MCP-compatible and has a full REST API, you can wire Claude or GPT directly into the CRM. This is the capability that dedicated CRM tools cannot match — and the primary reason an AI-stack or systems consultant should seriously consider Notion over Pipedrive.

Use case 1

Daily pipeline summary

"Here's what moved in my pipeline yesterday and what needs follow-up today." Claude queries Notion's Deals database and Touchpoints log, returns a one-paragraph morning brief. Replaces opening the CRM to manually reconstruct the picture.

Use case 2

Pre-meeting brief

"Pull the last 3 touchpoints with [Contact] and summarize where we stand." Claude reads the Touchpoints database, returns a focused briefing. Prep that used to take 20 minutes of email archaeology takes 30 seconds.

Use case 3

Stale deal detection

"Which deals have been in Proposal Sent for more than 14 days?" Claude queries the database with a filter, returns the list with contact names and last touchpoint dates. Runs in the background; sends a notification when it finds anything.

Use case 4

Intake-to-CRM creation

When a new Tally or Typeform intake is submitted, Make sends the responses to Claude. Claude extracts company, role, and relevant context. Make creates clean Contact and Deal records in Notion using Claude's extracted, structured data. Zero manual entry.

Build the database first. Add the AI layer when the CRM is alive and you've used it for at least 30 days. The AI layer is only as good as the data it reads — a clean, well-maintained database is the prerequisite.


Four disqualifiers — honest guidance on when to use Pipedrive or HubSpot instead.

Move to Pipedrive if

You do high-volume outbound

50+ new contacts per week is the threshold where Notion's UX won't keep up. Pipedrive's dedicated pipeline interface handles volume; Notion's database views were not designed for it.

Move to HubSpot if

You need real email tracking

Open rates, click rates, and reply tracking on individual emails require HubSpot or Pipedrive Advanced. Notion cannot see into your email client. If email performance tracking is central to your follow-up strategy, a dedicated CRM is the right tool.

Reconsider Notion if

You've failed at Notion CRM twice

A third attempt using a different template will not fix a habit problem. If two well-designed Notion CRM setups have been abandoned, the issue is behavioral, not architectural. Pipedrive's red-deal alerts and pipeline-as-homepage are better behavioral scaffolding for some operators.

Add a real CRM if

You need multi-user permissions

Notion's permission model is too coarse for multi-user CRM use where different team members should see different contacts or deals. HubSpot or Pipedrive have proper role-based access. At 3+ people sharing a pipeline, a dedicated CRM wins.


Get the Notion CRM Template

The 4-database schema pre-built, the 5 Make automation scenarios step-by-step, and the weekly digest query template — free for subscribers.

  • 4-database Notion CRM template (ready to duplicate)
  • Make: Calendly → Contacts + Touchpoints setup
  • Make: Weekly digest automation build guide
  • AI prompt library for daily CRM briefings

Free for subscribers

No spam. Unsubscribe any time.


Compare
HubSpot vs Notion CRM
Review
Pipedrive Review
Compare
Make vs Zapier
Compare
Client Portal OS