Author And Publish Blog Posts From Google Sheets 2873 – n8n Workflows – Free Template

What This Workflow Does

This n8n workflow automates the entire blog post creation and publishing process. It generates original blog content using AI, processes the data, logs activities to Google Sheets, and automatically publishes posts directly to WordPress.

How It Works

The workflow combines multiple automation stages:

• Manual or scheduled triggers initiate the blog creation process
• Configuration settings define AI models and publishing parameters
• OpenRouter API powers configurable AI models for each authoring stage
• Generated content undergoes post-processing with placeholder replacement
• Data is normalized and logged to Google Sheets for tracking
• WordPress publication occurs via XMLHttpRequest with response handling
• Results are saved and consolidated for final output

Use Cases

• Content agencies automating blog post generation for multiple client websites
• SaaS companies publishing regular product updates and feature announcements
• Publishers managing high-volume content calendars with consistent formatting
• Marketing teams scaling blog content production without manual writing
• News websites automating routine article creation and publishing pipelines

Nodes Used

• Schedule Trigger: Initiates workflow on defined intervals
• Manual Trigger: Allows on-demand workflow execution
• Set: Configures variables and workflow parameters
• Google Sheets: Logs workflow data and retrieves content parameters
• Code: Executes custom processing and data transformation
• LM Chat OpenAI: Generates blog content using configurable AI models
• Chain LLM: Sequences multiple AI processing stages
• If: Conditional logic for workflow branching
• HTTP Request: Publishes content to WordPress via XMLHttpRequest
• Sticky Note: Provides workflow documentation and setup notes

Prerequisites

• Active n8n instance with workflow editing access
• OpenRouter API key for AI model access
• Google Sheets API credentials and target spreadsheet
• WordPress website with API access enabled
• WordPress user account with post publishing permissions
• Configured blog post templates with placeholder variables

Difficulty Level

Advanced. This workflow requires configuration of multiple external APIs, custom code modifications, and understanding of XML request formatting for WordPress integration. Users should have experience with n8n, API authentication, and WordPress administration.

This workflow template is shared under the n8n fair-code license. Free to use and modify.