My Weekly Content Workflow: One Sheet, Three AI Tasks

My Weekly Content Workflow: One Sheet, Three AI Tasks

In short:

  • I run my content week from one spreadsheet with four tabs: the plan, findings with original-source links, what I’ve already posted, and fixes carried over from last week.
  • An AI tool does three small jobs: it summarizes what I’ve read, flags plans that repeat something I already posted, and reshapes drafts for each channel, and I approve everything before it goes out.
  • I’m changing three things: I’ll click through to the original source while I research, read my avoid list before I plan, and close old fixes before I start anything new.

Every week I publish one blog post and a handful of shorter posts for Google, Facebook, Instagram and Twitter. The whole thing runs on one spreadsheet, one AI chat tool and six steps. None of it is fancy, and that’s on purpose.

Below is the full process so you can copy it, plus what I’d change now that I’ve run it for a couple of weeks. You don’t need to publish as much as I do. A Pittsburgh shop that posts to Google once a week and to its blog once a month can use the same sheet with fewer rows.

Step 1: Set up one sheet with four tabs

Open a blank spreadsheet and make four tabs:

  • Plan. At the top, a one- or two-sentence focus for the week. Under that, an avoid list: topics you’re resting and anything you said too recently. Then one row per piece: channel, type of post, angle.
  • Findings. One row per thing you might write about: a plain sentence, the link, and a column that says “original” or “secondhand.”
  • Already said. Your posts from the last two weeks, one row each, with the date and channel.
  • Open fixes. Anything from earlier posts that still needs correcting.

This week, my focus line says to move my social posts toward AI updates and practical tech for Pittsburgh small businesses. The avoid list matters as much as the focus. It’s what stops me from repeating myself when I’m busy.

Step 2: Gather findings, with the original source next to each one

Here’s the first job I give the AI tool. I paste in the articles and pages I’ve read that week and ask it for one plain sentence per item, with the link. I also ask it to say whether each page is the company or researcher who published the information, or a report about someone else’s work.

Then I check that column myself, because it’s the one that matters most. If a page is secondhand, I don’t link it or quote it. If I still want the fact, I go find the original. A few real examples:

  • I wanted to say that businesses can buy ChatGPT ads on their own, without a partner. Before I wrote it, I confirmed it on OpenAI’s own May 5 post. It describes a beta self-serve Ads Manager where businesses can register, set budgets and bids, upload ads and view performance.
  • The first place I saw one search statistic was a site reporting on someone else’s study. I went back to the research company’s own study and cited that instead.
  • A draft about a free AI tool offer pointed to a news write-up. The right source was the company’s own program page, so that went on my fix list.
  • When the original page doesn’t show a date, I don’t add one. A date that sounds about right is still a guess.

The sources for my real estate pieces barely change from month to month. I keep NAR’s monthly existing-home sales report and Redfin’s Pittsburgh housing market page side by side on their own tab. NAR gives me the national picture. Redfin gives me Pittsburgh. Having both on one screen shows me right away when the two don’t match. That tab is general background, not a forecast. If you’re making a move of your own, talk to a licensed real estate professional about your situation.

Step 3: Check the plan against what I’ve already said

The second AI job is matching, which these tools are good at. I paste in the Plan tab and the Already said tab and ask: “Which of these planned posts repeat a topic, a statistic or an example from the earlier ones?” It gives me a short list. I decide what to do with it.

I check against three things:

  • My last two weeks of social posts. If a finding already ran on social, it doesn’t get to lead a blog post. My readers have seen it. It can come up later as a mention, but the post opens with something new.
  • My sister brands. Minnock Marketing and East End Living reach a lot of the same people I do. If one of them just covered a topic, I either take a clearly different angle or skip it.
  • A “worn out” list. These are topics I’ve written about too often lately and am resting for now.

To be honest, I only started that third list after I’d already run a couple of topics into the ground. More on that below.

Step 4: Draft one piece per row, with one action each

The third AI job is reshaping. The tool takes the plan, the findings and my voice notes and turns them into a first draft for each channel. A blog post and a two-line Twitter post need very different shapes. The reshaping is where I save the most time.

Every draft has to pass three tests:

  • One action. One thing the reader can check, change or do this week. Not five.
  • One real example. Something that actually happened or is actually on the page, never a made-up customer.
  • Say what I don’t know. If a study only covers certain industries, I say so. If I can’t tell you what it means for your shop, I say that too.

Step 5: Read, score and approve

I read every draft and score it out of 25 before I approve it or send it back. Nothing posts on its own. The scores are useful because they show me patterns I’d miss otherwise. Mine say my weak spots have been sources and repetition more than wording, which is why most of my changes below are about research and planning.

Step 6: Keep the open fixes in front of me

Anything I catch after a piece goes out goes on the Open fixes tab: a date to add, a source to swap for the original, a stray line to delete. That tab comes with me into the next week’s plan, so fixes don’t depend on my memory.

What I’d change

  1. Read the avoid list before planning, not after. When I ran the same topic again and again, it wasn’t a strategy. I just didn’t look back before I looked ahead. The avoid list now sits at the top of the Plan tab.
  2. Go to the original source during research, not during fixes. Every secondhand citation turned into a fix later. Five extra minutes clicking through to the company’s own page is cheaper than correcting a post that’s already live.
  3. Close old fixes before starting new pieces. My Open fixes tab is longer than I’d like. Starting next week, the first block of time goes to clearing it.

Here’s what I don’t know yet: whether fewer posts would do better than more. I haven’t tested it, so I’m not going to pretend I know.

Copy this: the template and the three prompts

Set up the four tabs from Step 1. Then save these three prompts in a note so you can paste them each week:

  1. Summarize: “For each page below, give me one plain sentence on what it says, the link, and whether the page is the original publisher or a report about someone else’s work.”
  2. Flag repeats: “Here’s my plan for this week and my posts from the last two weeks. Which planned posts repeat a topic, a statistic or an example?”
  3. Reshape: “Turn this approved draft into a short post for [channel]. Keep one action, keep the link, and don’t add any facts.”

Each one is a boring, repeatable task, the kind you’d hand a careful new hire. You still click the links, make the calls and approve what goes out.

One thing to do this week

Start with the Already said tab. Open a blank spreadsheet, list the last three things you posted on any channel, and keep that tab open while you plan next week. It takes about ten minutes. It’s the easiest way I know to stop repeating yourself without noticing, and it’s what the “flag repeats” prompt needs to work.

If you’d like help setting up a weekly system like this for your business, let’s connect.

Howard Hanna
Squirrel Hill Office, PA
6310 Forbes Avenue
Pittsburgh, PA 15217
(412) 421-9120

Keep reading: Connecting Brand, Technology and Franchise Growth

Tags :

Facebook
Twitter
LinkedIn