Creative Project Tracker Built from a Google Sheet — Free

A video hits "round four of revisions" and nobody can say how it got there. The client swore round two was final. The edit lives in one Frame.io link, the raw footage in a Drive folder someone shared from a personal account, and the approved script is an attachment on an email thread titled "Re: Re: Re: quick tweaks." Meanwhile the studio's other eight projects inch along, and the producer's actual job has become archaeologist — excavating links and reconstructing which cut is current.

Most studios and in-house creative teams track the pipeline in a spreadsheet, and it's the right instinct: a row per project, a stage, an owner, a due date. What the flat sheet can't do is push back. It won't tell you a project has been parked in Review for six days, that one client is on revision five of a two-revision scope, or that both of next week's deliveries are assigned to the same editor. You find those things out the way everyone does — too late.

The production-management platforms will sell you the fix at $10 per user per month, per editor, per freelance animator, forever. Or you can keep the pipeline sheet and have AI build the studio dashboard on top of it, free.

Step 1: Start With Your Production Sheet

One row per project, with columns along these lines:

Those two link columns are the quiet heroes — they end the archaeology. Add anything else you track (format, runtime, brief link); the sheet stays untouched structurally and becomes the database behind the tracker.

Step 2: Create a Free Account

Register at lovespreadsheets.com — the free plan handles both the build and everyday use; logins for the whole team on your studio's domain come with the paid tier.

Step 3: Describe Your Pipeline

Grab the Project Tracker template and write down how a project actually flows, in plain sentences:

• "Work moves Concept, then Script/Design, then In production, then Edit, then Review, then Revisions, then Delivered."
• "Review means it's with the client. Every trip back from Review bumps the revision number by one."
• "Editors and designers juggle several projects at once, and due dates are contractual."

Then request the three features that stop the usual bleeding:

• A revision counter per project, with anything past the scoped revision count highlighted — so overage conversations happen while there's still leverage
• Review-waiting flags: projects sitting in Review beyond a set number of days get marked stale and trigger an email nudge
• A workload board per creative — columns per person, cards per project, so assignment decisions take one look instead of a standup interrogation

AI Optimize will sharpen a loose description; answer whatever the AI asks back, and the build wraps in about 15–20 minutes.

Step 4: The Whole Slate on One Wall

You get a URL that works like a studio wall: every project as a card, staged left to right from Concept to Delivered, each card carrying its asset and review links, its revision count, and its due date. A producer sees stalls and overloads at a glance. An editor finishing a cut drags their card to Review from wherever they're working — the sheet updates in real time, and anything typed into the sheet flows straight back to the wall.

Nobody hunts through email for the current cut again; the card is the source of links.

Why Creative Teams Keep the Sheet

Freelancers make per-seat pricing absurd. A colorist for one week and an animator for one project each become a billed seat on the big platforms. When the tracker sits on your own sheet, the roster can breathe without the invoice noticing.

Producers keep their formulas. Capacity math, margin-per-project tabs, the end-of-quarter delivery report — everything you've built in the spreadsheet keeps running, now on data the team actually maintains.

Revision history becomes evidence. When a client disputes the overage invoice, the sheet holds every revision bump with its dates. That paper trail is worth more than any feature a platform sells.

Common Questions from Creative Teams

Can clients get a view of their own projects? Yes — scope a login to one client's rows and they can watch progress without emailing "any update?" twice a week.

We run design and video in one sheet — problem? No. Describe both flows in Step 3; a design project can skip Edit while video keeps the full path. The board follows your columns.

What keeps the revision count honest? Whoever moves a project out of Review updates the number — one cell, either in the app or the sheet. The highlight rule and the email flag do the enforcement for you.

Build Yours

Open the production sheet, go to lovespreadsheets.com, and describe the pipeline from concept to delivered. Around twenty minutes later the whole slate hangs on one wall — revision counts, stale reviews, and all.