← All N8N workflows
AI & researchChain LLMCodeGoogle SheetsHTTP RequestIf

Blog Automation TEMPLATE

Configured with Chain LLM, Google Sheets, HTTP Request, OpenAI Chat Model, and additional nodes. Review the connections and setup before adapting this template.

Workflow preview
TransformSettingsEdit FieldsTriggerScheduleTriggerSchedule TriggerTriggerManualTriggerManual TriggerData storeScheduleGoogle SheetsCodeConfigCodeData storefetchConfigGoogle SheetsAI & modelsAgentLLMOpenAI Chat ModelRoutingIfScheduledNowIfCodePreparedDataCodeCodeRecombinedDataRowCodeData storeSaveBackToSheetGoogle SheetsRoutingIfActionPublishIfRoutingIfTakeActionIfRoutingIfPromptExistsIfAI & modelsBasic LLM ChainChain LLMWeb / APICreatePostHTTP RequestData storeSetToPublishGoogle SheetsCodePrepareXmlPostCodeCodeHandleXMLRPCResponseCodeRoutingPostingSuccessfulIfData storeLogStatusGoogle SheetsData storeLogPublishedGoogle Sheets

Node categories in this workflow

  • Transform
  • Trigger
  • Data store
  • Code
  • AI & models
  • Routing
  • Web / API

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
SettingsTransformEdit FieldsSee node parameters
ScheduleTriggerTriggerSchedule TriggerSee node parameters
ManualTriggerTriggerManual TriggerSee node parameters
ScheduleData storeGoogle SheetsSee node parameters
ConfigCodeCodeSee node parameters
fetchConfigData storeGoogle SheetsSee node parameters
AgentLLMAI & modelsOpenAI Chat ModelSee node parameters
IfScheduledNowRoutingIfSee node parameters
PreparedDataCodeCodeSee node parameters
RecombinedDataRowCodeCodeSee node parameters
SaveBackToSheetData storeGoogle Sheetsupdate
IfActionPublishRoutingIfSee node parameters
IfTakeActionRoutingIfSee node parameters
IfPromptExistsRoutingIfSee node parameters
Basic LLM ChainAI & modelsChain LLMSee node parameters
CreatePostWeb / APIHTTP RequestPOST
SetToPublishData storeGoogle Sheetsupdate
PrepareXmlPostCodeCodeSee node parameters
HandleXMLRPCResponseCodeCodeSee node parameters
PostingSuccessfulRoutingIfSee node parameters
LogStatusData storeGoogle Sheetsappend
LogPublishedData storeGoogle Sheetsappend

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleSheetsOAuth2Api
  • openAiApi

Workflow notes

Author Blog-Post

Author Blog-Post

Using OpenRouter to make model fully configurable for each authoring stage

Post-process Data

Post-process Data

{{ Placehoder }} replacement

Publish Blog-Post

Publish Blog-Post

Use a generic XMLHttpRequest with subsequent response handling, since the Wordpress node did not work at all.

Post-process Data

Post-process Data

Normalize and re-merge output data structure.

Post-process Data

Post-process Data

Extract post id or error message from response.

Blog Automation TEMPLATE

Blog Automation TEMPLATE

Purpose and structure

This folder contains the Blog Automation TEMPLATE workflow. Its executable nodes use chainLlm, code, googleSheets, httpRequest, if, lmChatOpenAi, manualTrigger, scheduleTrigger, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

ScheduleTrigger, ManualTrigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Code/1320_Code_Schedule_Automate_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Settings
  • Log to Sheet
  • Save Result To Sheet
  • Save Status To Sheet
  • Authoring
  • Publishing
  • Config & Data

More in AI & research