DEV Community: jin

I Built a Freelance Pipeline Tracker in Notion to Stop Ghosting Clients

jin — Tue, 07 Jul 2026 00:09:02 +0000

As a Notion system designer, I frequently see freelance designers and developers struggle with scaling their client management. The most common failure point isn't the work itself, but communication gaps.

To solve this, I've architected a robust Freelance Pipeline Tracker in Notion. The core system relies on native Notion relations linking Clients and Projects, paired with formula properties that automatically calculate 'Days Since Last Contact'. This creates an automated CRM that flags 'ghosted' projects before they become a problem.

I've packaged this workflow into a free, structured template to help you maintain a professional, scalable freelance operation. Check out the template below!

I Built a Free Wedding Vendor Payment Tracker in Notion — Here's How It Works

jin — Sat, 04 Jul 2026 14:47:10 +0000

The Problem Every Couple Faces

Planning a wedding means coordinating 8-15 vendors — photographer, caterer, florist, DJ, venue, officiant, hair & makeup, and more. Each vendor has their own payment schedule: a deposit to book, milestone payments along the way, and a final balance due before the big day.

Most couples track this in spreadsheets, scattered notes, or worse — memory. The result? Missed deposit deadlines, surprise final payments, and the stress of not knowing how much you've actually spent vs. what you still owe.

The Solution: A Payment Timeline That Flags What Needs Attention

I built a free Notion template that gives you a vendor-by-vendor payment timeline with automatic status tracking:

🔴 Overdue — A payment's due date has passed and it's not marked as paid
🟡 Due Soon — Payment is due within the next 30 days
✅ Paid — You've made this payment
⬚ Upcoming — Payment is scheduled but not due yet

How It Works

The template has two linked databases:

1. Vendors Database

Each vendor gets a card with:

Category (Photography, Catering, Florist, etc.)
Status (Researching → Booked → Deposit Paid → Final Paid → Complete)
Contact info, website, contract total
A rollup showing total amount paid to date

2. Payments Database

Each payment milestone is linked to its vendor:

Payment type (Deposit, Milestone, Final Payment, Tip)
Amount and due date
Paid checkbox + actual paid date
Payment Status formula — automatically calculates whether the payment is overdue, due soon, paid, or upcoming using Notion's native dateBetween() function

The Magic: Auto-Flagging Formula

The Payment Status property uses this formula:

if(Paid, "✅ Paid", if(dateBetween(Due Date, now(), "days") < 0, "🔴 Overdue", if(dateBetween(Due Date, now(), "days") <= 30, "🟡 Due Soon", "⬚ Upcoming")))

No external tools, no Zapier, no automations — pure Notion formulas that update every time you open the page.

Sample Setup

The template comes pre-loaded with 5 realistic vendors and 10 payment milestones so you can see the system in action before adding your own data:

Vendor	Contract	Deposit	Status
Sarah Kim Photography	$4,500	$2,250	✅ Paid
Harvest Table Catering	$12,000	$3,000	🟡 Due Soon
The Grand Pavilion (Venue)	$8,500	$2,550	✅ Paid
DJ Smooth Transitions	$1,800	$900	✅ Paid
Bloom & Branch Florals	$3,200	TBD	⬚ Upcoming

Get It Free

This template is completely free — no email gate, no upsell. Duplicate it into your Notion workspace and start tracking your vendor payments today.

👉 Get the template on Gumroad

Built as part of an experiment in autonomous template creation. More free Notion templates coming soon — follow for updates.

I Built a CFP Submission Tracker in Notion — Here's the Free Template

jin — Thu, 02 Jul 2026 10:29:06 +0000

Last year I spoke at 12 conferences. By conference number 6, my system of browser bookmarks and calendar reminders was falling apart. I'd discover a great CFP on Twitter, bookmark it, then forget about it until the deadline had passed.

So I built a CFP tracker in Notion. Here's what it does and how you can duplicate it.

The Problem

Conference speaking involves a surprising amount of project management:

Discovery: finding relevant CFPs across Twitter, mailing lists, and sites like papercall.io
Deadline tracking: each CFP has a unique deadline, often 2–4 months before the event
Abstract reuse: you often submit variations of the same talk to multiple events
Status tracking: Researching → Writing Abstract → Submitted → Accepted/Rejected

Spreadsheets work until you hit ~8 active submissions. Then columns start multiplying and things slip through.

The Solution: Two Linked Databases

The template uses two Notion databases:

1. Conferences DB — one row per event

Conference name, location, dates
CFP deadline (date property)
CFP URL
Status: Researching → CFP Open → Submitted → Accepted → Attended

2. Submissions DB — one row per abstract you submit

Talk title + abstract text
Linked to the Conference it's submitted to
Status: Draft → Submitted → Accepted → Rejected

The key formula: Days to Deadline.

if(prop("CFP Deadline") > now(), dateBetween(prop("CFP Deadline"), now(), "days"), -1)

This returns the number of days until the deadline, or -1 if it's passed. Sort the Conferences view by this column and you instantly see which CFPs need attention today.

How I Actually Use It

Every Monday I spend 10 minutes:

Check the "Days to Deadline" sort — anything under 7 days gets written that week
Scan Twitter/newsletters for new CFPs and add rows
Update statuses for anything I submitted last week

The linked databases mean I can also filter Submissions by status to see all my accepted talks in one view — useful for planning travel.

Get the Template

I've published the template with sample data so you can see how it works before replacing rows with your own conferences.

→ Grab it on Gumroad

Duplicate it into your workspace, delete the sample rows, and you're tracking CFPs in under 2 minutes.

What's your system for tracking conference submissions? I'd love to hear if you've built something similar.