n8n Workflow: Create WordPress SEO Posts from Google Sheets + OpenAI

Turn a Google Sheets queue into SEO-ready WordPress drafts—automatically

This n8n workflow creates SEO-optimized WordPress blog drafts from your Google Sheets using OpenAI (GPT-4o) for structured article content and DALL·E 3 for realistic featured images—then publishes each post as a draft and marks the row as Done.

What this workflow does

• Runs manually when you click “Test workflow”.
• Reads rows from Google Sheets where the Status column is set to Pending, processing items in batches.
• For each row, sends the topic, category, keywords, and meta description to an OpenAI-powered agent to generate a structured JSON article with an HTML body.
• Generates a featured-image prompt with OpenAI and creates an image using DALL·E 3.
• Uploads the image to the WordPress Media Library via the WordPress REST API.
• Creates a new WordPress post in draft status using the generated title and content.
• Updates the source Google Sheets row to Status = Done, then waits one minute before moving to the next item.

Use cases

• Maintain a content pipeline for health and lifestyle topics in Google Sheets and generate SEO-Writing.ai style drafts in WordPress.
• Automation engineers and SaaS operators: produce consistent SEO posts without manual writing/editing for every draft.
• Queue-based publishing: keep Pending/Done statuses to track progress end-to-end.

Technical details

• Google Sheets OAuth: spreadsheet ID, tab/sheet name, and column names (including Status).
• OpenAI: GPT-4o for text/JSON article generation; DALL·E 3 for featured images.
• WordPress: create posts via WordPress node; upload media using /wp-json/wp/v2/media (replace with your domain).
• n8n nodes: set, no op, wait, wordpress, sticky note, HTTP Request.