How to Use Notion as a CRM for Freelancers and Small Businesses

Notion can replace expensive CRM tools like HubSpot or Salesforce for freelancers and small businesses. By combining a database, customizable views, and automation, you can track leads, manage deals, and nurture client relationships—all within a single workspace. This article walks you through building a Notion CRM from scratch, using templates, and optimizing it for your workflow. You don’t need coding skills or a big budget. Just a Notion account and 30 minutes.

Notion CRM dashboard with lead database and kanban board view

Photo by Startup Stock Photos on Pexels

## Why Notion as a CRM?

Traditional CRMs are overkill for solopreneurs and small teams. They’re expensive, complex, and require training. Notion offers a flexible, free alternative with:

  • Custom databases for contacts, deals, and tasks
  • Multiple views (table, kanban, calendar, gallery)
  • Relations and rollups to connect data
  • Templates for repeatable processes
  • Collaboration features for small teams

You get a lightweight CRM that adapts to your sales funnel, not the other way around.

## Step 1: Set Up Your Core CRM Database

Start with a single database called Clients & Leads. This is your master contact list.

### Database Properties

Create these properties in your table:

Property Type Purpose
Name Title Contact name
Status Select Lead, Qualified, Proposal Sent, Client, Lost
Company Text Business name
Email Text Primary email
Phone Text Phone number
Source Select Referral, Website, Social Media, Cold Outreach
Value Number Estimated deal value
Next Action Date Follow-up date
Notes Text Meeting notes or context

Pro tip: Use the Select property for Status and Source to filter and sort leads quickly.

Notion table view of CRM database with colored status tags and properties

Photo by Markus Spiske on Pexels

## Step 2: Create Views for Your Sales Pipeline

Notion’s strength is multiple views on the same data. Build these three essential views:

### Kanban View (Pipeline)

  • Group by Status
  • Drag and drop deals from “Lead” to “Client”
  • Add a Filter to show only active deals

### Calendar View (Follow-ups)

  • Group by Next Action date
  • See upcoming calls, emails, and meetings
  • Add a Filter to hide completed items

### Gallery View (Contact Cards)

  • Display contact names, company, and status
  • Add cover images for visual recognition
  • Use for quick scanning

## Step 3: Link Deals and Projects with Relations

Don’t stop at contacts. Connect your CRM to your project management.

### Create a Deals Database

  • Properties: Deal Name, Value, Stage, Close Date, Client (Relation to Clients & Leads)
  • Views: Kanban by stage (Discovery, Proposal, Negotiation, Closed Won/Lost)

### Create a Projects Database

  • Properties: Project Name, Client (Relation), Status, Deadline, Tasks
  • Rollup: Sum total project value from Deals

How to set up relations:

1. In Clients & Leads, add a Relation property to Deals

2. In Deals, add a Relation property to Projects

3. Use Rollup to display total deal value on the client page

This creates a connected system. Click a client to see all their deals and projects in one place.

Notion relation between client database and deals database with rollup values

Photo by Polina Zimmerman on Pexels

## Step 4: Automate with Templates and Buttons

Save time by automating repetitive tasks.

### Create a Lead Capture Template

  • Pre-fill Status as “Lead”
  • Set Source based on where you found them
  • Add a default Next Action (e.g., “Send intro email”)

### Use Notion Buttons for Actions

  • Button 1: “Convert to Client” – changes Status, creates a project
  • Button 2: “Log Call” – adds a note and updates Next Action
  • Button 3: “Send Proposal” – creates a proposal template linked to the client

### Set Up Recurring Tasks

  • Use a Tasks database with a Date property
  • Create a Calendar view for daily/weekly follow-ups
  • Duplicate recurring task templates

## Step 5: Track Metrics with Dashboards

A dashboard gives you a bird’s-eye view of your pipeline. Build one with:

### Key Metrics (using Formulas and Rollups)

  • Total Leads – Count of all contacts
  • Active Deals – Count of deals in progress
  • Pipeline Value – Sum of all deal values
  • Conversion Rate – Deals won divided by total deals

### Visual Blocks

  • Linked database view of your kanban pipeline
  • Timeline view for project deadlines
  • Chart block (if using Notion Plus) for revenue trends

### Example Dashboard Layout

“`

Metric Block Metric Block Metric Block
Total Leads Active Deals Pipeline $
42 8 $24,500
Pipeline Kanban Upcoming Follow-ups
[Drag deals] [Calendar list]

“`

## Comparison: Notion CRM vs Traditional CRMs

Feature Notion CRM HubSpot (Free) Pipedrive
Price Free (up to 1,000 blocks) Free (limited) $14/month
Customization Unlimited Limited Moderate
Learning Curve Low Medium Medium
Views 5+ views 3 views 4 views
Automation Buttons + templates Workflows Automations
Integrations Zapier, Slack Native Native
Best for Freelancers, micro-businesses Small teams Sales teams

Verdict: Notion wins on flexibility and cost. Traditional CRMs win on native integrations and reporting.

## 5 Practical Tips for Success

1. Start simple. Only add properties you’ll actually use. You can always expand later.

2. Use templates. Create a lead capture template to standardize data entry.

3. Set a daily review. Spend 5 minutes updating deal statuses and Next Action dates.

4. Tag your sources. Track where leads come from to focus your marketing.

5. Archive, don’t delete. Move lost deals to an Archived status to keep data clean.

## Advanced: Add Client Portal with Notion

Give clients access to a limited view of their projects. Use Share settings to create a read-only link. Include:

  • Project timeline
  • Deliverables checklist
  • Meeting notes
  • Invoice status

This builds transparency and reduces back-and-forth emails.

## Common Mistakes to Avoid

  • Too many properties. Keep it to 10-15 core fields.
  • No follow-up system. Always set a Next Action date.
  • Overcomplicating views. Start with one table view, then add kanban.
  • Ignoring templates. They save hours of repetitive work.

## Conclusion

Notion is a powerful, affordable CRM for freelancers and small businesses. With a single database, smart views, and connected projects, you can manage your entire sales pipeline without leaving your workspace. Start with the core database, add a kanban view, and link it to your deals and projects. In under an hour, you’ll have a CRM that rivals paid tools.

Ready to save time and close more deals? Download our Notion CRM for Freelancers template at notionkit.tech and get a pre-built system with dashboards, automations, and client portals. Stop juggling spreadsheets—start selling smarter.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *