A Google Sheets spreadsheet with the right columns gives you a lesson-by-lesson view of your entire course production. You can see what's been scripted, what's been recorded, and what's still waiting — without learning a new tool or paying for project management software.
Why Google Sheets Works for Production Scheduling
Most course creators already know how to use a spreadsheet. That matters more than it sounds. The best production system is one you'll actually open every day, and a familiar tool removes the friction that makes people abandon fancy project boards after week one.
Google Sheets is free, runs in any browser, and lets you share a live link with an editor or virtual assistant so everyone sees the same status. Formulas do the counting for you — no manual tallying of how many lessons are done. Conditional formatting turns your sheet into a visual dashboard where red rows demand attention and green rows confirm progress.
The structure of a spreadsheet also maps naturally to course production. Each row is a lesson. Each column is a milestone. You read left to right and see a lesson move from idea to published content. That directional flow is harder to replicate in a kanban board or a to-do app.
Step-by-Step: Building Your Production Tracker
Step 1: Set Up Your Column Headers
Open a new Google Sheet and type these headers across row 1: Lesson Title, Module, Content Type, Script Date, Record Date, Edit Date, Upload Date, Status, and Notes. Bold the header row and freeze it (View > Freeze > 1 row) so it stays visible as you scroll.
Each column serves a specific purpose. Lesson Title and Module tell you what the content is and where it lives in your course structure. Content Type distinguishes video lessons from worksheets, quizzes, or audio recordings. The four date columns — Script, Record, Edit, Upload — mark your production milestones. Status gives you a quick-glance indicator. Notes is for anything that doesn't fit elsewhere: "waiting on guest audio" or "needs b-roll from location shoot."
Step 2: Add a Row for Every Lesson
List every lesson in your course, one per row. Include intro and conclusion videos, bonus materials, and any downloadable resources that need production work. If you have 24 lessons across 6 modules, you should have 24 rows (plus a few for bonus content).
Fill in the Module column so you can sort or filter by module later. Use consistent naming: "Module 1," "Module 2," not a mix of module names and numbers. Consistency makes filtering reliable.
Step 3: Add a Status Dropdown with Data Validation
Select the entire Status column (minus the header). Go to Data > Data validation > Add rule. Choose "Dropdown" and enter your status options: Not Started, Scripting, Recording, Editing, Done. Click Save.
Now every cell in the Status column shows a dropdown menu instead of a free-text field. This prevents typos ("Donee," "recording," "DONE") that would break your summary formulas later. It also makes updating status a one-click action.
Five statuses are enough for most courses. If you have a review step — someone else checks your content before it goes live — add "In Review" between Editing and Done. Resist adding more than six statuses. The point is simplicity.
Step 4: Add Conditional Formatting for Visual Tracking
Select your data range (all rows below the header). Go to Format > Conditional formatting. Create three rules:
- Green background when the Status column equals "Done." This gives you an immediate sense of progress as rows turn green.
- Light yellow background when Status equals "Scripting" or "Recording." These are your active items — the work in progress.
- Red background when a date column is past today and Status is not "Done." Use a custom formula like
=AND($G2<TODAY(), $H2<>"Done")(adjusting column letters to match your Upload Date and Status columns). Red rows are overdue and need your attention first.
The color coding transforms a plain data table into a dashboard. You open the sheet, scan the colors, and know where you stand in under five seconds.
Step 5: Fill In Your Target Dates
Work backward from your launch date. If you plan to open enrollment on June 1, your last lesson needs to be uploaded by late May. Space your dates realistically — most solo creators can script, record, and edit about two to three lessons per week.
Fill in the Script Date column first for every lesson. Then offset the Record Date by a day or two, and Edit Date by another day or two after that. Upload Date is your internal deadline for having the lesson ready inside your course platform.
Be honest with yourself about your pace. Optimistic dates that slip every week are worse than conservative dates that you consistently hit. If you've never produced course content before, schedule one lesson as a test run before committing to dates for the entire course.
Step 6: Create a Summary Row with COUNTIF Formulas
Below your last lesson row (or in a separate "Dashboard" area at the top), add summary formulas. Assuming your Status column is column H:
=COUNTIF(H:H, "Done")— total lessons completed=COUNTIF(H:H, "Not Started")— lessons not yet begun=COUNTIF(H:H, "Recording") + COUNTIF(H:H, "Editing")— lessons in active production=COUNTIF(H:H, "Done") / COUNTA(H2:H100)— percentage complete (format as percent)
These numbers update automatically as you change lesson statuses. You don't have to count manually, and you always have an accurate answer when someone asks "how far along is the course?"
Step 7: Share with Your Team
Click the Share button in the top right corner and add your editor, virtual assistant, or co-creator. Give them "Editor" access if they need to update statuses, or "Commenter" access if they only need to leave notes.
A shared sheet eliminates status-update emails. Your editor opens the sheet, sees which lessons are in the "Editing" status, and knows exactly what to work on. You see their progress in real time without asking.
Course Creator Tips
Batch Your Work by Column, Not by Row
Instead of completing one lesson from script to upload before starting the next, try batching by production phase. Script five lessons in a row, then record all five, then edit all five. Batching keeps you in the same mode — writing mode, recording mode, editing mode — and reduces the mental switching cost. Your spreadsheet makes this easy to track because you can sort by Status and see all your "Scripting" lessons together.
Add a "Content Type" Column to Spot Imbalance
If every row says "Video," your students may experience fatigue. Use the Content Type column to audit variety. A healthy course mixes video lessons with worksheets, reflection prompts, quizzes, and downloadable resources. Scanning the column visually reveals whether you have that mix or need to add some variety.
Limitations of the Spreadsheet Approach
A Google Sheet is not a visual kanban board. You won't get the satisfaction of dragging a card from "In Progress" to "Done." If that visual workflow matters to you, a tool like Trello is a better fit for tracking production status.
Spreadsheets don't send reminders. If a deadline passes, the row turns red (with conditional formatting), but you still have to open the sheet to notice it. There are no push notifications or email alerts unless you add a Google Apps Script, which is more complexity than most course creators want.
And if your course exceeds 50 lessons, a single sheet gets long enough that scrolling becomes the dominant activity. At that scale, splitting into tabs per module helps, but a dedicated project management tool might serve you better.
Related Guides
- How to Build a Course Content Tracker in Notion — a database-powered alternative with kanban and calendar views
- How to Plan Your Course Launch Using Trello — track launch tasks alongside your production schedule
- Create Your First Course in 30 Days — a day-by-day timeline that pairs with a production tracker
- The Course Creator's Tool Stack — how Google Sheets fits alongside your other tools
From Spreadsheet to Live Course
A production schedule keeps you accountable and prevents the slow drift that turns a "two-month project" into six months of unfinished recordings. When you can see exactly how many lessons are done and how many remain, the finish line stays concrete.
When your tracker shows green across the board, Ruzuku lets you build your course in the same module-and-lesson structure you planned. Upload your content, add discussion prompts or activities, set your price, and open enrollment — all in one place, with zero transaction fees.