C1 Project Tracker for Freelancers

Description

The C1 freelancer project tracker replaces the tangle of Google Sheets, Slack threads, and founder’s-head notes that most studios under 20 people rely on — giving you a single Notion or Airtable system with 6 interconnected databases so client work flows from briefing to delivered without anything falling through the cracks. Built for teams who are past spreadsheets but not ready for enterprise PM software, it turns scattered project chaos into one calm, queryable source of truth.

What’s inside the download

• Notion markdown import — full 6-database scaffold (Projects, Milestones, Tasks, Deliverables, Time entries, Clients) with pre-built views, rollup formulas, status pipelines, and reusable project templates so you’re operational the day you import it
• Airtable schema JSON — import-ready for non-Notion teams, with linked-record relationships and view configurations preserved
• Google Sheets version — 6-tab CSV for the simplest, no-tool path when you just need something working today
• 20-page setup guide (PDF) covering installation, customization, automation wiring, and weekly/monthly reporting rhythms
• 6 automation recipes — ready-to-adapt n8n and Zapier workflows for Slack deadline alerts, weekly digests, overdue-task reminders, and draft invoice generation from logged time
• 3 adaptation guides tailored to agencies (5–15 people), in-house startup PMs, and solo consultants — so you’re not reverse-engineering someone else’s workflow
• 4 illustrated diagrams showing the data model and rollup chain, so you understand *why* each field exists before you start editing

Who it’s for

• Agency founders (5–20 people) juggling multiple concurrent client projects and losing hours to status-chasing
• In-house project managers at startups who need structure without a six-figure PM tool contract
• Solo consultants who need a real freelancer project tracker rather than a graveyard of scattered Google Docs and half-updated Trello boards

Format & access

Instant download. ZIP (~150 KB) containing PDF + Notion MD + Airtable JSON + CSVs + SVG illustrations. Lifetime access, free future updates, no subscription — one freelancer project tracker you own for good.

Pairs well with

• C4 Client Onboarding System — the pre-delivery companion that feeds cleanly into your project pipeline
• D1 Agency Starter Kit — bundles B1 + A2 + A4 + A7 + B4 for agency founders building the full ops stack