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 integrationWhy most Notion CRMs collapse
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.
8-database CRM
Tasks, emails, documents, meetings, proposals, companies, contacts, deals — all linked. Impressive to build. Impossible to maintain. Abandoned by month two.
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.
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.
The minimum viable schema
Four databases. The complete CRM for a solo consulting practice.
The resistance list
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.
Automation wiring
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.
The AI layer
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.
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.
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.
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.
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.
When this guide is wrong for you
Four disqualifiers — honest guidance on when to use Pipedrive or HubSpot instead.
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.
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.
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.
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.
Related resources