How to Build a Simple CRM in Notion for Your Small Business

If you’ve ever lost track of a lead because it was buried in an email thread, or missed a follow-up because you were managing contacts in three different places, you already know the problem. A spreadsheet isn’t quite enough, but a full CRM feels like overkill — and the monthly fees for dedicated software add up fast. A notion crm for small business sits comfortably in the middle: structured enough to be reliable, flexible enough to match how you actually work.

The good news is you don’t need to build anything complicated. A well-designed Notion database can handle the core jobs of a CRM — tracking contacts, logging interactions, managing deal stages, and flagging follow-ups — without the learning curve or the subscription cost of a dedicated tool.

Start With a Contacts Database

The foundation of any CRM is a clean contacts list. In Notion, create a new database and call it Contacts. The properties you actually need are simpler than you might think:

• Name — the default title field works fine
• Company — text field
• Email — email field (Notion makes this clickable)
• Phone — phone field
• Status — a select field with options like Lead, Active Client, Past Client, Cold
• Last Contact Date — date field
• Notes — a text field for quick context you don’t want to lose

Resist the urge to add fifteen more properties at the start. You can always add fields later. What kills most self-built CRMs is too much structure upfront, which makes every entry feel like paperwork.

Add a Deals or Projects Database

Contacts alone won’t tell you what’s happening with your revenue. You need a separate Deals database that tracks the actual opportunities you’re working on. Key properties here include:

• Deal Name — title field, usually the project or service type
• Contact — a relation field linking back to your Contacts database
• Stage — select field: Prospect, Proposal Sent, Negotiating, Closed Won, Closed Lost
• Value — number field in dollars
• Expected Close Date — date field
• Next Action — text field for the one thing you need to do next

The relation between Contacts and Deals is what makes this feel like a real CRM rather than two disconnected lists. When you open a contact record, you can see every deal associated with that person. When you’re in a deal, you can click through to the contact’s full history.

Create Views That Match How You Actually Work

One of Notion’s biggest advantages is the ability to look at the same database through different lenses. For your Deals database, set up these views:

• Kanban by Stage — drag deals across columns as they progress. This gives you a visual pipeline at a glance.
• Table filtered to Active — everything that isn’t closed, sorted by Expected Close Date so the most urgent items rise to the top.
• Follow-Up View — filter for deals where the Next Action date is today or past. This becomes your daily work queue.

For your Contacts database, a Gallery view works surprisingly well if you add a profile photo property — it makes the list feel less like a spreadsheet and easier to scan. A filtered view showing only Leads is useful when you’re prospecting.

Log Interactions Without Extra Friction

The part where most DIY CRMs fall apart is interaction logging. If it’s too much work to record a conversation, you won’t do it. In Notion, the simplest approach is to use the body of the contact page itself as a running log. Open the contact record and write a quick note with the date at the top — a few sentences is enough. Over time this becomes a reverse-chronological history of everything relevant.

If you want something more structured, create a third database called Interactions with a relation to Contacts, a date field, a type (Call, Email, Meeting), and a brief notes field. This adds more overhead but gives you the ability to filter interactions across all contacts by date or type — useful if you have a large number of relationships to manage.

For most small businesses with fewer than 100 active relationships, the simple body-of-page approach is plenty. Don’t build complexity you won’t use.

Set Up a Weekly Follow-Up Routine

A CRM only earns its keep if it prompts action. Build a simple habit around it: every Monday, open your Follow-Up view in the Deals database and update any deal where the Next Action date has passed. Write the new next step and update the date. This takes about ten minutes and keeps nothing from slipping.

You can also create a Contacts view filtered for Last Contact Date older than 30 days with Status set to Active Client. Scan it weekly. If a client you’re actively serving hasn’t heard from you in a month, that’s worth a quick check-in.

These aren’t automations — they’re lightweight habits anchored to a reliable system. Automations come later, once you know the process is actually working.

Connect It to the Rest of Your Workspace

Once your CRM databases are stable, you can pull them into other parts of your Notion workspace. A linked database view of open deals on your weekly planning page keeps revenue visible without switching contexts. A filtered view of contacts in a specific segment lives naturally inside a project page for a client campaign.

Notion also connects to Zapier and Make, which means you can automate the boring entry work over time. A common setup: when a contact form on your website is submitted, a Zap creates a new record in your Contacts database with the Lead status already set. The manual work becomes review, not creation.

Building your notion crm for small business doesn’t have to be a weekend project. Start with two databases, five properties each, and one kanban view. That’s a working system. You can grow it from there as the gaps become clear — not before.

If you’re ready to stop managing client relationships in your head and your inbox, the AutoFlow Guide has step-by-step walkthroughs for building and connecting your Notion workspace into a complete business system.