Pre-built Notion templates often look impressive and get used for two weeks before being abandoned. The problem isn’t Notion — it’s templates designed for someone else’s workflow. Building your own from three simple databases takes less time than adapting someone else’s overcomplicated setup.
The three databases you actually need
Notion’s power comes from linked databases. For freelance project management, three tables cover most use cases:
1. Clients — one row per client, with fields for contact info, status (active, prospect, past), and a relation to Projects.
2. Projects — one row per project, with fields for status (proposal sent, in progress, review, complete), deadline, client relation, and a rollup of open tasks.
3. Tasks — one row per task, with fields for project relation, due date, priority, and status.
That’s the foundation. Everything else is optional.
Setting up the Clients database
Create a new full-page database in Notion. Add these properties:
- Name (default title field) — client or company name
- Status (select) — Prospect, Active, On Hold, Past
- Email (email)
- Notes (text) — for anything relevant about how they work
- Projects (relation to your Projects database — add this after creating Projects)
Keep it simple. The temptation is to add 20 fields; you’ll actually use five.
Setting up the Projects database
Create a second full-page database. Add:
- Project Name (title)
- Client (relation to Clients)
- Status (select) — Proposal, Active, Review, Complete, Archived
- Start Date and Due Date (date)
- Budget (number — optional but useful)
- Tasks (relation to Tasks — add this after creating Tasks)
- Open Tasks (rollup of Tasks filtered to incomplete)
Add a Board view to this database using Status as the group-by field. This gives you a visual pipeline of all active work.
Setting up the Tasks database
Create the third database:
- Task (title)
- Project (relation to Projects)
- Due Date (date)
- Priority (select) — High, Medium, Low
- Done (checkbox)
Add a filter to your default view: Done is unchecked. This keeps your task list focused on what’s actually open.
The most useful Notion setup isn’t the most feature-complete one — it’s the one with the fewest clicks between “starting work” and “knowing exactly what to do next.”
Connecting the databases
Once all three databases exist, go back and add the relation properties:
- In Clients, add a relation pointing to Projects
- In Projects, add a relation pointing to Tasks and a relation pointing to Clients (if not already added)
- In Tasks, Notion will auto-create the back-relation to Projects
Now click into any client row and you’ll see all their projects. Click into any project and you’ll see all its tasks. The system starts paying dividends immediately.
Creating your dashboard page
Create a new blank page called “Home” or “Dashboard.” Use the /linked database command to embed filtered views of your three databases:
- Active Projects — Projects filtered to Status = Active
- This Week’s Tasks — Tasks filtered to Due Date = this week, not done
- Pipeline — Projects filtered to Status = Proposal
That dashboard becomes the page you open every morning. Three views, full picture of your workload in seconds.
What Notion doesn’t replace
Notion handles task and project tracking beautifully. It doesn’t replace your proposal tool, invoicing system, or time tracker. Most freelancers add a dedicated tool for proposals and invoicing — something like Waco3 that handles the client-facing business side (proposals with tracking, quotes, and invoices) separately from internal task management.
Trying to run proposals and invoices through Notion is possible but awkward. Keeping the task management layer and the business operations layer separate keeps both cleaner.
The template above takes 45 minutes to build and will serve you for years with minimal modification. Start simple and add only when you actually feel the need.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
