The Spreadsheet That Runs My Whole Content Calendar
The Spreadsheet That Runs My Whole Content Calendar
A story from The Silver Geek
Affiliate disclosure: This post may contain Amazon affiliate links. As an Amazon Associate I earn from qualifying purchases, at no extra cost to you. Full disclosure here.
For the first few months of this, every Sunday looked the same: staring at a blank page around 8pm, trying to remember what I'd already posted about, what platform needed what, and whether I'd repeated myself three weeks running without noticing. Thirty years managing other people's workflows, and I hadn't built one for my own.
The fix wasn't a fancy app. It was the most boring tool in existence — a spreadsheet, three columns wide, that I update in about ninety seconds after I publish anything. Topic pillar, title, and date. That's it. No project management software, no content calendar app with seventeen features I'd never touch.
Why This Actually Worked
The problem was never a lack of ideas. It was not being able to see the pattern at a glance. Once I had three columns in front of me, the rotation became obvious — parenting, then AI tips, then tech and creator content, repeat — and Sunday night stopped being a blank-page problem. It became a "which one's next" problem, which takes about four seconds to answer instead of forty minutes of staring.
Try this today: Three columns, nothing fancier. What it's about, what you called it, when it went out. Update it the moment you publish, not later — later never happens.
What Thirty Years of Support Work Actually Taught Me
- Systems beat memory every time. I used to trust myself to remember what I'd covered. I was wrong more often than I'd like to admit.
- The tracker only works if updating it takes less time than not updating it. Three columns. Not fifteen. The moment it becomes a chore, it stops happening.
- A rotation removes decisions, and removing decisions is the whole point. Deciding what to post about is the expensive part. A rotation makes that decision once, in advance, instead of every single week.
None of this is a groundbreaking productivity hack. It's the same lesson every support team eventually learns: the boring, unglamorous tracking system is the thing that actually keeps the whole operation from falling apart. I just hadn't gotten around to pointing that same discipline at my own Sunday nights until I was tired enough of the blank page to finally do it.
If you're building something and drowning in "what do I post about," I'd love to hear what's worked for you. And if you want to see the tools and gear I actually use, check out my recommendations (affiliate links).
Comments
Post a Comment