how to build a no-code CRM with Notion and Zapier (free template)
I spent months paying for CRM tools I barely used. HubSpot was too bloated. Salesforce felt like it was built for a company ten times my size. all I needed was a simple way to track leads, follow up on time, and see where each deal stood. so I built my own CRM in Notion, wired it up with Zapier, and I haven’t looked back since.
this guide walks you through the exact setup I use to manage contacts, deals, and follow ups without writing a single line of code. I also included a free template you can duplicate and start using in under an hour.
for more on this, see our guide on 5 workflows every solo founder should automate in 2026.
why build your own CRM instead of paying for one
most dedicated CRM tools are designed for sales teams with dozens of reps and complex pipelines. if you’re a solopreneur, freelancer, or small agency, you’re paying for features you’ll never touch.
here’s what a Notion CRM gives you that the big platforms don’t. full control over your fields and layout without a learning curve. zero monthly cost if you’re on Notion’s free plan. the flexibility to combine your CRM with project management, notes, and content planning all in one workspace. and the ability to customize views without begging support to unlock a feature.
the tradeoff is that you won’t get built in email sequences or advanced reporting out of the box. but for most people managing under 500 contacts, a Notion CRM paired with Zapier automations covers everything you actually need.
what you need before you start
| tool | purpose | cost |
|---|---|---|
| Notion (free plan) | hosts your CRM database, views, and templates | free for personal use |
| Zapier (free plan) | connects forms, email, and other apps to your CRM | free for 100 tasks/month |
| Google Forms or Tally | captures new leads from your website | free |
| Gmail or Outlook | triggers automations when emails arrive | free |
you can get this entire setup running without spending a dollar. if you outgrow Zapier’s free tier of 100 tasks per month, their Professional plan starts at $19.99/month billed annually.
for more on this, see our guide on zapier vs make comparison.
step 1: set up your Notion CRM database
open Notion and create a new page. name it something like “CRM” or “sales pipeline.” then add an inline table database by typing /table and selecting Table, Inline.
now add these properties to your database. each one serves a specific purpose.
name (title property, default). this is the contact or lead name. keep it as the first column.
email (email property). stores the contact’s email address for quick access.
company (text property). useful if you’re doing B2B sales or working with agencies.
status (select property). create options like: new lead, contacted, meeting scheduled, proposal sent, won, lost. this powers your pipeline view later.
last contact (date property). I update this manually or through Zapier every time I interact with a lead. it’s the single most important field for follow up discipline.
notes (text property). a free text area for call summaries, meeting notes, or anything relevant.
deal value (number property, formatted as currency). even rough estimates help you prioritize which leads to chase first.
source (select property). options like: website form, referral, LinkedIn, cold outreach. tracking where leads come from helps you double down on what works.
you can add more fields later, but these eight cover 90% of what a solo business needs.
step 2: create views for different workflows
the real power of a Notion CRM is views. one database, multiple perspectives. here are the three I use daily.
pipeline board view. create a new Board view grouped by the status property. this gives you a Kanban style board where you drag leads from “new lead” to “contacted” to “won.” it’s a visual snapshot of your entire pipeline at a glance.
follow up table view. create a filtered Table view that only shows contacts where the last contact date is more than 7 days ago and status is not “won” or “lost.” sort by last contact ascending. this view is your daily to do list for follow ups. I check it every morning.
won and lost view. create a Table view filtered to show only “won” and “lost” contacts. this is your performance log. at the end of each month, I review this to calculate close rates and average deal values.
you can also add a Calendar view mapped to the last contact field if you prefer a time based layout for scheduling follow ups.
step 3: connect Zapier to automate lead capture
this is where things get interesting. instead of manually adding every new contact to your CRM, let Zapier do it automatically.
zap 1: new form submission to Notion. set the trigger to Google Forms (or Tally) with the event “new form response.” set the action to Notion with the event “create database item.” map each form field to the corresponding Notion property. name goes to name, email goes to email, and so on. set the status to “new lead” by default and the source to “website form.”
every time someone fills out your contact form, they appear in your CRM instantly.
zap 2: new email to Notion. set the trigger to Gmail with the event “new email matching search.” use a search query like from:@specificdomain.com or a label you assign to inbound leads. set the action to Notion and map the sender’s name and email into your database. this is great for capturing inbound interest from people who email you directly rather than using a form.
zap 3: update last contact date. this one is optional but powerful. set the trigger to Gmail with “new email sent” and filter for emails sent to addresses already in your CRM. set the action to Notion with “update database item” and update the last contact field to today’s date. this keeps your follow up view accurate without any manual work.
for more on this, see our guide on automate email follow ups.
step 4: build your template structure
a good CRM template has three layers.
the database is your core table with all the properties I described in step 1. this is where every contact lives.
the dashboard page sits above the database and contains your board view, follow up view, and won/lost view side by side. I use callout blocks at the top to show quick stats like total leads this month and total deal value in pipeline.
the contact page template is a Notion database template that auto fills when you create a new entry. set it up with sections for meeting notes, action items, and a timeline of interactions. click the dropdown arrow next to “new” in your database, select “new template,” and design your layout once. every new contact inherits it.
if you want to skip building this from scratch, you can duplicate the free Notion CRM template from Notion’s official template gallery. search for “CRM” at notion.com/templates and pick the one that fits your workflow. then customize the fields to match what I outlined above.
when to switch to a real CRM
a Notion CRM works brilliantly up to a point. here are the signs that it’s time to move on.
you have more than 500 active contacts. Notion databases slow down noticeably at scale. if you’re managing hundreds of leads across multiple pipelines, a dedicated tool like HubSpot or Pipedrive handles that volume better.
you need built in email sequences. Notion can’t send automated email follow ups natively. if drip campaigns are central to your sales process, you’ll want a CRM with that built in.
your team has more than 3 people using the CRM. Notion’s permission model isn’t granular enough for sales teams. you can’t restrict who sees specific deals or contacts without awkward workarounds.
you need reporting and forecasting. dedicated CRMs offer pipeline analytics, revenue forecasting, and activity tracking dashboards that Notion simply can’t replicate.
for most solopreneurs and small teams under 5 people, though, I’d recommend starting with Notion and Zapier. you can always migrate later, and the time you spend building your CRM teaches you exactly what features you actually need versus what sounds nice on a pricing page.
5 frequently asked questions
is Notion really free for a CRM?
yes. Notion’s free plan supports unlimited pages and blocks for individual use. you can build a full CRM database, create multiple views, and share pages with guests at no cost. the paid plan at $10/month adds features like unlimited file uploads and 30 day page history, but the free tier is enough to start.
how many Zapier automations can I run for free?
Zapier’s free plan gives you 100 tasks per month with single step zaps only. each form submission or email that triggers a Notion update counts as one task. if you process more than 100 leads per month, you’ll need to upgrade to the Professional plan at $19.99/month for 750 tasks and multi step zaps.
can I use Make instead of Zapier?
absolutely. Make (formerly Integrobot) offers a free plan with 1,000 operations per month, which is more generous than Zapier’s free tier. the interface is more visual and supports branching logic natively. I wrote a detailed comparison if you want to dig deeper.
for more on this, see our guide on zapier vs make comparison.
will I lose my data if I stop paying for Notion?
no. if you downgrade from a paid Notion plan to free, your content stays intact. you just lose access to premium features like unlimited file uploads. your CRM database, contacts, and views remain fully accessible.
can I connect Notion to Slack for deal notifications?
yes. create a Zapier zap with the trigger “updated database item in Notion” filtered to status changes like “won.” set the action to Slack with “send channel message.” I use this to get a Slack ping every time I close a deal. it takes about 5 minutes to set up.
start building today
you don’t need a $50/month CRM subscription to stay organized. Notion gives you the structure, Zapier gives you the automation, and together they handle everything a solopreneur or small team needs to track leads and close deals.
grab the free template from Notion’s gallery, follow the steps above, and you’ll have a working CRM before lunch. when your business outgrows it, you’ll know exactly which features matter to you because you built the system yourself.
for more on this, see our guide on how to automate invoicing with zapier.
for more on this, see our guide on 5 workflows every solo founder should automate in 2026.
looking for more automation guides? check out our full library of no-code workflow tutorials to save hours every week.
related reading
more articles from the same topic I think you will find useful: