Freelance Project Tracker from One Sheet — Free & AI-Built

Six projects, six clients, one calendar — yours. The logo package needs its third revision round, the whitepaper went out Tuesday and hasn't come back, and the ecommerce build you quoted in May finally got its deposit paid this morning. None of these clients know the others exist. All of them believe they're the priority.

So each project lives wherever that client prefers to talk — one in Trello because the agency insisted, two buried in email threads, the rest in your head. The first forty minutes of every workday go to reconstructing the answer to a single question: what's due next, and for whom? That daily reconstruction is the context-switching tax, and freelancers pay it in their most focused hours.

The usual fix is a work-management platform — Asana, Monday, ClickUp, roughly $10 a seat per month — but those tools assume a team: assignees, managers, sprint rituals. You need something smaller and more personal. The spreadsheet you already keep, wearing an interface that answers the morning question before coffee.

Step 1: Start With Your Deliverables Sheet

One row per deliverable — not per project, because clients don't pay for projects, they pay for the things you send them:

The Status column carries the weight. Five stages cover almost any freelance workflow: Queued → In progress → Sent → Feedback → Final. "Sent" and "Feedback" matter most, because they mark the moments when a deadline is technically the client's problem — and about to boomerang back into yours.

Step 2: Get a Free Account

Start at lovespreadsheets.com and create your account. Everything in this article fits inside the free plan; paid extras like client logins on a domain you own can wait until you actually want them.

Step 3: Describe How You Work

Choose the Project Tracker template, then explain your workflow in plain sentences, as if briefing a very literal assistant:

• "Each row is one deliverable for one client. Queued means booked but not started; In progress means it's on my desk today."
• "Sent means the client has it. Feedback means notes came back and the clock restarted."
• "Final means approved — but a row isn't truly closed until Invoiced? says Yes."

Then request the three views that pay for the whole exercise:

• A Today view — every deliverable due within 48 hours, all clients merged into one list, sorted by date
• Feedback-waiting flags — anything Sent for more than five business days gets highlighted, so you can nudge before the deadline compresses
• A done-but-not-invoiced view — rows where Status is Final and Invoiced? is No, which is the exact list of money you're forgetting to collect

Hit AI Optimize if your write-up feels loose — it tightens the description, and the AI may double-check what a stage or a column means. Then run it; fifteen to twenty minutes later you have a link.

Step 4: One Screen for Six Clients

The link opens a web app that starts with today: what's due, what's overdue, what's been sitting in a client's inbox too long. Behind that are a kanban of your five stages, a calendar of due dates, and per-client filters for when a check-in call needs a quick rundown.

Change a status in the app and the sheet updates the same moment; type in the sheet and the app follows. There's no import step and no export step, because both are the same data.

Why Freelancers Keep the Sheet

Your quoting history stays queryable. Every finished row records what you built, how many revision rounds it took, and when. When a similar project comes in, last year's rows are your estimate.

One seat shouldn't have a subscription. Per-user pricing is a rounding error for a company and a real cost for a person. A tracker that rides on your own sheet has no meter running.

Clients never have to adopt anything. They keep emailing; you keep the board. The tool serves you without asking anyone else to change.

Common Questions from Freelancers

Can a client see their own project without seeing the others? Yes — request a client-facing view filtered to one Client value, read-only, so Meridian never learns about the other five.

What happens when a revision round blows a deadline? Update the Due cell — from the app or the sheet — and the Today view, calendar, and reminders all shift with it.

Can it chase me about invoicing? Ask for an email nudge whenever a row has been Final for a week with Invoiced? still No. It's a nag you'll be glad you built.

Build Yours

Take the sheet where your deliverables already live — or type out the seven columns above in ten minutes — open lovespreadsheets.com, and show it how a deliverable travels from Queued to paid. Tomorrow morning, "what's due and for whom" has a URL instead of a forty-minute answer.