Building a Personal CRM for Job Applications in Notion (Free Template)

Spreadsheets work for tracking 10 applications. They break at 50. By 100, you cannot remember which company uses which ATS, who you spoke to, or whether you already applied to that "Senior Engineer" role at the startup with the blue logo. You need a CRM.

Why Notion

Notion sits at the right abstraction level for a personal job-search CRM. It gives you a database with custom properties, multiple views, and relational linking—without the overhead of a real CRM like HubSpot or Salesforce. It is free for personal use, works on every platform, and supports the one feature that matters most: filtered views that show you exactly what needs your attention right now.

The database schema

Create a single database called "Job Applications" with these properties:

Property	Type	Purpose
Company	Title	The company name
Role	Text	Job title
Status	Select	Applied, Phone Screen, Interview, Offer, Rejected, Archived
Source	Select	LinkedIn, Company Site, Referral, Recruiter, Other
Applied Date	Date	When you submitted
Last Contact	Date	Most recent communication
Next Step	Text	Action item (e.g., "Send follow-up email")
Contact Name	Text	Recruiter or hiring manager name
Contact Email	Email	Their email address
Job URL	URL	Link to the original posting
Notes	Text	Freeform research and interview notes

The views that replace your spreadsheet

Create at minimum four filtered views:

Active Pipeline (Board view). Group by Status. This gives you a Trello-style Kanban board. Applications move left to right as they progress. At a glance, you see how many roles are in each stage and where the bottleneck sits.

Needs Action (Table view). Filter to applications where Next Step is not empty. Sort by Last Contact ascending. This is the view you open every morning. It tells you exactly who needs a follow-up and when you last reached out.

This Week's Applications (Calendar view). Display Applied Date on a calendar. Shows your application cadence at a glance. If a week looks sparse, you know to increase volume. If a week is packed with no movement to Phone Screen, you know to investigate your resume or timing.

Company Research (Gallery view). Each card shows the company name, role, and a Notes preview. Use this view when preparing for interviews to review your research without opening 40 individual pages.

Automating reminders

Notion does not have native reminders tied to database dates, but you can wire it together with a simple formula property. Create a "Follow-up Due" formula:

if(
  empty(prop("Last Contact")),
  dateAdd(prop("Applied Date"), 5, "days"),
  dateAdd(prop("Last Contact"), 7, "days")
)

This calculates the next follow-up date: 5 days after applying if you have had no contact, or 7 days after the last touchpoint. Sort your Needs Action view by this formula to surface the most overdue follow-ups first.

Integrating with your application workflow

Every time you submit an application, create a new entry in the database. It takes 15 seconds. The fields you care about—Company, Role, Source, Applied Date, Job URL—can be filled from the job posting in a single copy-paste-plus-type cycle.

When you get a response, update the Status and Last Contact. When you schedule an interview, set the Next Step to "Prepare for [Company] interview" with a date. When you send a follow-up, update Last Contact and clear Next Step until the next action crystallizes.

Why this beats a spreadsheet

Spreadsheets are passive. They store data and wait for you to interpret it. A Notion CRM with filtered views actively surfaces what needs your attention. It reduces the cognitive load of "where am I with Company X?" to zero. And when you land the role, you have a complete record of your search—conversion rates, timeline, and all—ready for analysis.

The job seekers who stay organized are the ones who follow up consistently. The ones who follow up consistently are the ones who get offers.