Skip to content
Tutorials Center
My learning

Topics

Lesson 35 of 36 ยท Projects and Practice

Project: A Simple CRM

Build a small CRM in Notion with Companies, Contacts and Deals databases, a pipeline board, follow-up automations, rollups for deal value and a weekly review.

A CRM (customer relationship manager) keeps track of who you talk to, what you have offered, and what to do next. Freelancers, small agencies and small teams often do not need a big tool; three connected Notion databases cover most of it.

In this project you design the databases, the pipeline, the follow-up reminders and the reports. Notion is not available on this site, so the steps describe the app and the JavaScript blocks are stand-ins for the calculations, labelled as such.

The three databases

flowchart LR
  C["Companies"] -->|"has many"| P["Contacts"]
  C -->|"has many"| D["Deals"]
  P -->|"involved in"| D

A company has contacts and deals; a deal can involve several contacts.

Companies

Property Type
Name Title
Website URL
Industry Select
Contacts Relation
Deals Relation
Open value Rollup: Sum of Value over Deals where Stage is open

Contacts

Property Type
Name Title
Company Relation to Companies
Email Email
Role Text
Last contacted Date
Next follow-up Date

Deals

Property Type
Name Title
Company Relation
Contacts Relation
Stage Status or Select: Lead, Contacted, Proposal, Negotiation, Won, Lost
Value Number (formatted as currency)
Probability Formula or Number (by stage)
Expected close Date
Owner Person

Pipeline view

Create a Board view of Deals grouped by Stage. Drag a card across columns as the deal moves. Show Value and Company on the card. Add a filter to hide Won and Lost deals in the main pipeline, and make a second view for closed deals.

Weighted pipeline

Forecasting is more honest when each stage has a probability. A simple scheme:

Stage Probability
Lead 10%
Contacted 25%
Proposal 50%
Negotiation 75%
Won 100%
Lost 0%

In Notion add a Probability formula that maps stage names to numbers with ifs (or nested if), and a Weighted value formula equal to Value times Probability. The stand-in below calculates the same.

JS Stand-in: weighted pipeline

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The weighted forecast includes won deals at 100%, which is usual; decide whether you want a separate "won this quarter" figure.

Follow-ups that do not slip

The reason people use a CRM is the next action. Add a Next follow-up date to Contacts and build a view named Follow up: Next follow-up is on or before today, sorted by date. Then automate:

  • A button "Log contact" that sets Last contacted to today and Next follow-up to a chosen offset (for example +7 days).
  • A recurring weekly automation that notifies you if the view is not empty.
  • A template for meeting notes related to the deal (see Meeting Notes and OKRs).

Stand-in: who needs a follow-up?

JS Stand-in: follow-up list

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Reports

  • Pipeline by stage: a Board or Chart view (charts are available in newer versions) of Value grouped by Stage.
  • Revenue by month: Won deals grouped by Expected close month.
  • Win rate: Won divided by Won plus Lost; compute with filtered rollups or a quick script.
  • Stale deals: open deals with no activity in 30 days.

Put a linked view of Follow up and the pipeline on a CRM home page, with a weekly review checklist: update stages, log contacts, set the next follow-up on every open deal.

Privacy and sharing

A CRM holds personal data. Keep it in a closed teamspace or a private page, share with the fewest people at the lowest permission they need (see Sharing Pages and Permissions), and do not paste sensitive details you would not want exposed. If you handle customer data under privacy laws, check your obligations; a Notion workspace is not a certified CRM.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. Why is a Deals database separate from Companies?

    One company can have many deals, so each deal gets its own row related to the company.
  2. 2. What does a weighted forecast multiply?

    Weighted value = deal value times the probability of its stage.
  3. 3. Which view helps make sure follow-ups do not slip?

    A filtered view of due and overdue follow-ups keeps the next action visible.

Summary

  • Three related databases (Companies, Contacts, Deals) cover a small CRM.
  • A Board grouped by Stage is the pipeline; probability by stage gives a weighted forecast.
  • A Next follow-up date, a button and a view keep outreach moving.
  • Restrict access, because a CRM contains personal data.

Next: Practice: Notion Exercises