๐Ÿ“ Content & PublishingIntermediate๐Ÿง  AI-powered

Blog Automation TEMPLATE

A 22-step content & publishing automation, triggered by schedule, manual, connecting Google Sheets, OpenAI (LLM), HTTP / REST API, with built-in AI reasoning.

โฌ‡ Download workflow JSON
๐Ÿ’ก

What this does for your business

In plain terms: this writes and publishes content for you. It uses AI to understand and generate content, so it handles judgement-style work, not just moving data. It runs on a set schedule (e.g. daily), creates the piece, and pushes it to Google Sheets, OpenAI (LLM) โ€” replacing hours of manual writing and posting.

22
Nodes
3
Integrations
21
Connections
Schedule, Manual
Trigger

๐Ÿš€ Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

๐Ÿ—๏ธ Architecture diagram

The real node graph exported from n8n โ€” triggers (green), AI nodes (violet), services and logic โ€” laid out as they run.

โ€ขSettingssetโ–ถScheduleTriggerscheduleTriggerโ–ถManualTriggermanualTrigger๐Ÿ“ŠSchedulegoogleSheetsโ€ขConfigcode๐Ÿ“ŠfetchConfiggoogleSheets๐Ÿง AgentLLMlmChatOpenAiโ€ขIfScheduledNowifโ€ขPreparedDatacodeโ€ขRecombinedDataRowcode๐Ÿ“ŠSaveBackToSheetgoogleSheetsโ€ขIfActionPublishifโ€ขIfTakeActionifโ€ขIfPromptExistsif๐Ÿง Basic LLM ChainchainLlm๐ŸŒCreatePosthttpRequest๐Ÿ“ŠSetToPublishgoogleSheetsโ€ขPrepareXmlPostcodeโ€ขHandleXMLRPCResponsecodeโ€ขPostingSuccessfulif๐Ÿ“ŠLogStatusgoogleSheets๐Ÿ“ŠLogPublishedgoogleSheets

โš™๏ธ How it works

  1. ScheduleTrigger ยท scheduleTrigger
  2. ManualTrigger ยท manualTrigger
  3. AgentLLM ยท lmChatOpenAi
  4. Settings ยท set
  5. Basic LLM Chain ยท chainLlm
  6. fetchConfig ยท googleSheets
  7. Schedule ยท googleSheets
  8. RecombinedDataRow ยท code
  9. Config ยท code
  10. PreparedData ยท code
  11. LogStatus ยท googleSheets
  12. IfTakeAction ยท if
  13. SaveBackToSheet ยท googleSheets
  14. IfActionPublish ยท if

๐Ÿ’ผ Business analysis

๐ŸŽฏ

Business use case

An end-to-end content production line โ€” research, generation, formatting and publishing (Google Sheets, OpenAI (LLM), HTTP / REST API) โ€” that lets one operator ship the output of a whole content team. It turns a keyword or brief into a published, SEO-ready asset.

๐Ÿ“ˆ

Market need

Content is the #1 demand-gen channel and the most time-expensive. Automating the pipeline collapses cost-per-article from hours to minutes.

๐Ÿ’ฐ

Market value

Content pipelines replace retainers of $1,500โ€“$8,000/mo. Sold as a service or template, they carry strong recurring value tied to output volume.

๐Ÿงฉ Integrations & stack

๐Ÿ“ŠGoogle Sheets๐Ÿง OpenAI (LLM)๐ŸŒHTTP / REST API
Node typesset, scheduleTrigger, manualTrigger, googleSheets, code, lmChatOpenAi, if, chainLlm, httpRequestWorkflow IDhprnv26TrRYOxwEN
โฌ‡ Download workflow JSON โ† Back to library