Meta: A free, copy-paste lead pipeline template for freelancers — five columns, five statuses, one weekly review — and the optional automation that logs leads for you.
Freelancer lead pipeline template (free)
Most freelancers don't need a CRM; they need a pipeline they'll actually maintain. Here's a template that survives contact with real work — copy it into Google Sheets and start today. (Link below is the honest version: paste these headers, don't download a 12-tab monster you'll abandon.)
The template — copy this row into A1
`` contact | email | source | status | quote_sent | last_touch | notes ``
Statuses: NEW (inquiry arrived, you haven't replied) → REPLIED → QUOTED → WON / LOST. Use exactly these — conditional formatting and filters depend on consistent values.
One row per lead. Source = where they found you (referral, website, platform) — after 30 rows you'll see which source actually pays.
Three setup clicks that make it work
- Filter view "Stuck": status = QUOTED, sorted by quote_sent ascending. This is your revenue leak, ranked. Bookmark it.
- Conditional formatting: WON = green, LOST = gray, any QUOTED row older than 7 days = yellow.
- Weekly review (Friday, 5 min): open "Stuck" → anything yellow gets a follow-up or a LOST status. Nothing stays yellow twice.
When the manual version breaks
Somewhere around 20 leads/week, data entry becomes the bottleneck — you start skipping rows, then skipping weeks, then the pipeline is fiction. The fix is the same template plus one automation: an n8n workflow that watches your Gmail leads label and appends each new inquiry (contact, email, timestamp) automatically. You only flip statuses.
The Follow-Up Autopilot pack ($39) includes this pipeline sheet, the auto-append workflow, and the 3-touch follow-up sequence — free tiers to run. The template above stays free regardless; steal the headers, they're yours.
The 90-day test
Run it honestly for 90 days: every lead logged, every Friday review done. You'll know three things you didn't before — your real close rate, your real reply lag, and which source sends buyers vs tire-kickers. That knowledge is worth more than the CRM you were about to buy.