IntermediateSaves 2-3 hours/week📝NotionZapier💬Slack

Build an Automated Lead Tracking Database in Notion

Use Notion as a lightweight CRM with automated lead capture from your website forms and email — so every lead is logged, assigned, and tracked from first contact to close in one place.

Overview

For small teams that don't want the complexity of a full CRM, Notion makes a surprisingly capable lead tracker. With the right automation layer, leads from your website flow directly into a Notion database, get assigned to team members, and trigger follow-up reminders — all without touching a dedicated CRM.

Before you start

  • Notion Plus plan
  • Website contact form with Zapier integration
  • Zapier Multi-Step plan
  • Slack for notifications (optional)

Step-by-step guide (4 steps)

1

Build your lead database in Notion

Create a Notion database with fields: Name, Company, Email, Phone, Source (website, referral, LinkedIn, etc.), Status (New, Contacted, Qualified, Proposal, Won, Lost), Owner (person), Lead Date, Next Follow-up Date, and Notes. Add a Kanban view grouped by Status.

2

Connect your website form to Notion via Zapier

In Zapier, trigger on your website form tool (Typeform, Gravity Forms, Contact Form 7). Action: 'Notion: Create Page in Database.' Map form fields to Notion properties: name, email, company, message → notes. Set Status = New and Lead Date = today automatically.

3

Set up assignment and notifications

Add a Zapier action after creating the Notion record: post a Slack message to #new-leads or DM the assigned sales person: 'New lead: [Name] from [Company] — [link to Notion record].' If your team is small, assign all new leads to one person; if larger, use round-robin assignment via a Zapier counter.

4

Create follow-up reminder automations

In Zapier, create a daily Zap: query Notion for leads where 'Next Follow-up Date' = today. For each result, send the owner an email or Slack DM: 'Follow-up reminder: [Lead Name] — [link].' This surfaces every lead that needs attention each day.

TIP:

Add a 'Days Since Last Contact' formula in Notion: DATEBETWEEN(NOW(), {Last Contacted}, 'days'). Use this in a filtered view called 'Needs Follow-up' showing leads silent for more than 5 days. Review this view daily.

What you'll get

Every lead captured automatically from web forms

No leads forgotten with daily follow-up reminders

Kanban view shows full pipeline at a glance

Lightweight alternative to a full CRM subscription for small teams

Common mistakes to avoid

Not tagging the lead source (you lose attribution data needed to evaluate marketing channels)

Skipping the follow-up date field (leads get stuck at 'Contacted' indefinitely)

Not transitioning to a proper CRM as the team grows past 5 people

Frequently asked questions

Do I need coding experience to set up this Notion automation?

No coding is required. This guide walks you through everything using Notion's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.

How long does this automation take to set up?

Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.

What happens if the automation fails?

Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.

Can I customize this automation for my specific business?

Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.

Related automations