community-automations/sheets-publish-blog

Content & Docs

PublicClaude subagent

Sheets → Blog Posts

Planning posts in a spreadsheet is easy; turning each row into a published article is the slog. This automation writes and publishes straight from the Sheet.

sonnet4 daysGoogle Sheets APIOpenAIWordPress REST APIn8n
ClaudeClaude
ROI for
README.md

Why this subagent

Planning posts in a spreadsheet is easy; turning each row into a published article is the slog. This automation writes and publishes straight from the Sheet.

Mark a row ready and it drafts the post, sends it to WordPress on the scheduled date, and writes the live URL back into the Sheet. Your editorial calendar becomes the publishing tool.

How it runs

    • Read

      Used at step 01 to kick off the pipeline.

    • Write

      Used at step 01 to kick off the pipeline.

    • WebFetch

      Used at step 01 to kick off the pipeline.

    • WebSearch

      Used at step 01 to kick off the pipeline.

Sample output

json
// Sample output
// (generated when the pipeline finishes)

Turn the spreadsheet row into a publish-ready post; return JSON with title, body HTML, meta, and publish date.

Unlock the rest

The full agent definition, install snippet, and starter task are gated for community members.

Members get the full `.md` agent file, the npm / pnpm install one-liners, a starter prompt that we've tuned against real runs, and the open-source repo when this automation ships there. One email, magic link, done.