C1 Project Tracker for Freelancers

Description

Stop running agency ops in your head

Most Studios under 20 people run projects on a mix of Google Sheets, Slack, and notes in the founder’s head. This template replaces that mess with a single Notion or Airtable system — 6 databases wired together so one piece of client work flows from briefing to delivered without breaking.

What’s included

• Notion markdown import — full 6-database scaffold (Projects, Milestones, Tasks, Deliverables, Time entries, Clients) with pre-built views, formulas, and templates
• Airtable schema JSON — import-ready for non-Notion teams
• Google Sheets version — 6-tab CSV for the simplest path
• 20-page setup guide (PDF) covering setup, customization, automation, and reporting
• 6 automation recipes — n8n/Zapier workflows for Slack alerts, digests, reminders, and invoice generation
• 3 adaptation guides — agency (5-15 people), startup/in-house, solo consultant
• 4 illustration diagrams showing data model + rollup chain

Who this is for

• Agency founders (5-20 people) running multiple concurrent projects
• In-house project managers at startups
• Solo consultants ready to graduate from Google Docs

Format

Instant download. ZIP (~150 KB) with PDF + Notion MD + Airtable JSON + CSVs + SVG illustrations. Lifetime access. No subscription.

Pairs well with

• C4 Client Onboarding System — the pre-delivery companion
• D1 Agency Starter Kit — bundles B1 + A2 + A4 + A7 + B4 for agency founders