The Spreadsheet That Runs My Whole Content Calendar

The Spreadsheet That Runs My Whole Content Calendar — The Silver Geek Blog

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

Popular posts from this blog

Why Parenting Later in Life Might Be the Best Thing That Ever Happened to You

What I Wish Someone Had Told Me Before Becoming a Dad at 57

Complete Guide to Parenting in Later Life with Technology