Plan, draft, and publish blog posts from a spreadsheet

Moves blog topics through planning, drafting, and final review using AI, then publishes to WordPress.

How the work actually flows

A straight line. Runs once per each topic marked ready; a person has to approve before it continues.

Pattern: Sequence (1) ยท Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(["scheduled check of topics"]):::trigtime s0["check topic status"]:::task s1[["AI drafts and finalizes post"]]:::mi s2(("you review and approve draft")):::human s3["publish post to WordPress"]:::svc trig --> s0 s0 -->|"one per each topic marked ready"| s1 s1 --> s2 hg(("you approve the draft")):::human s2 --> hg hg -->|"approved"| s3 hg -. "sent back" .-> s2 out[/"finished post published to WordPress"/]:::out pay{{"steady blog output without a writer"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemA personResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Content Generation & CopywritingSpreadsheet & Database Ops
Connects
Google SheetsWordPressOpenRouter

The problem it solves

Writing blog posts consistently means juggling topic ideas, drafts, and edits across different tools, and it's easy for the process to stall out. Getting from an idea to a published post takes more coordination than most small teams have time for.

Who it fits

A small marketing team or solo business owner who wants a steady blog without hiring a full-time writer.

How it works

  1. You add a topic and its status to a spreadsheet
  2. On a schedule, the system checks each topic's status
  3. AI plans, drafts, and finalizes the post based on your prompts
  4. You review and approve the draft in the spreadsheet
  5. The approved post is published to WordPress automatically
What you get

Blog drafts ready for your final approval

You get a blog post moved from topic to polished draft automatically, ready for you to review and approve before it goes live.

What you get

A finished blog post published to your WordPress site, with the whole process tracked in a spreadsheet.

What you need

A Google Sheets account, an AI model API key, and a WordPress site with app password access.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Generate and publish SEO-optimized blog posts to WordPress

It writes a full blog post with title, image, and SEO meta tags from AI, then publishes it as a WordPress draft.

Advanced

Turn RSS news into published Wordpress blog posts automatically

Reads RSS feeds, picks the best stories, writes full articles with AI, and publishes them to Wordpress.

Advanced

Create SEO content designed to get picked up by AI search

AI writes blog posts, newsletters, landing pages, and social posts built to rank with Google and AI tools like ChatGPT.

Advanced

Turn a content idea into a published WordPress draft

Turns a one-line topic in your spreadsheet into a full SEO blog post with a cover image, saved as a WordPress draft.

Standard
Back to the AI Playbook