Community Blog Automation

Name: Community Blog Automation
Rating: 1.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

47 views

0 downloads

Community Contributedautomationbloggingcontent creationgoogle sheetsllmwordpress

Automate blog post creation and updates using Google Sheets and WordPress.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of creating and updating blog posts on WordPress. It reads data from a Google Sheet, processes it using a configurable prompt, and then either publishes new posts or updates existing ones based on the Action and Status fields in the sheet.

Key Features

Reads blog post data from a Google Sheet.
Configurable prompts and model selection via Google Sheets.
Supports publishing new posts and updating existing ones.
Uses environment variables for webhook URLs.
Integrates with WordPress for post management.

How To Use

Import Workflow: Import the JSON into your n8n instance.
Configure Settings Node:
- Set urlSpreadsheet to your Google Sheet URL.
- Update urlWordpress, wordpressUsername, and wordpressApplicationPassword with your WordPress credentials.
- Define sheetSchedule, sheetConfig, and sheetLog as the names of your respective Google Sheets.
- Set actionPublish and actionUpdate to trigger publishing or updating.
Set up Google Sheets: Ensure you have three sheets named as specified in the Settings node: Schedule, Config, and Log.
- The Config sheet should contain key-value pairs for prompts, models, and output formats (e.g., prompt_generate_title, prompt_generate_title_model).
- The Schedule sheet should contain rows with data for each blog post, including an Action and Status column.
Configure Credentials: Set up your Google Sheets OAuth2 API credentials and an OpenAI (or compatible) API credential for LLM operations.

Apps Used

automation

blogging

content creation

google sheets

llm

wordpress

Workflow JSON

{
  "id": "048f6422-3fb8-4729-b4e1-b07d822ab343",
  "name": "Community Blog Automation",
  "nodes": 0,
  "category": "Community Contributed",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.