n8n Workflow: WordPress SEO Blog Posts with Perplexity & GPT-5

Turn your content plan into WordPress SEO drafts—automatically

This n8n workflow takes blog topic ideas from Google Sheets, researches each one with Perplexity, then uses OpenAI GPT-5 to generate an SEO-ready HTML article (title, meta description, and slug). It publishes the result as a new WordPress post draft and creates a DALL·E featured image—while also updating your Google Sheets with publishing details.

What this workflow does

• Manual start: Run the workflow on demand to process the next topic from your content plan.
• Reads your content idea: Pulls the topic prompt from the PROMPT column in your Google Sheets.
• Research with Perplexity: Uses Perplexity to research the topic within a defined recency window and returns bullet-point findings.
• Generates SEO article content with GPT-5: Uses OpenAI GPT-5 to produce structured output including SEO title, meta description, slug, and the full HTML-formatted article body.
• Creates a WordPress draft: Inserts a new post in WordPress using the generated title, slug, HTML content, and your configured post status.
• Adds a photorealistic cover image: Generates a cover image with OpenAI DALL·E, uploads it to the WordPress media library, and sets it as the featured image.
• Tracks publishing back in Google Sheets: Updates the original Google Sheets row with details such as the WordPress post ID.

Use cases

• SaaS marketing teams converting a Google Sheets editorial calendar into consistent WordPress SEO blog drafts.
• Automation engineers building an SEO content pipeline using n8n, Perplexity, GPT-5, and WordPress.
• Operators who want faster topic-to-draft workflows without manually writing metadata and HTML.

Technical details

• n8n nodes / integrations: Google Sheets, Perplexity, OpenAI (GPT-5 text + DALL·E image generation), WordPress (REST API), HTTP Request, and support nodes like Set and Sticky Note.
• Required setup: Configure Google Sheets OAuth2, Perplexity credentials, OpenAI credentials for GPT-5 and DALL·E, and WordPress REST API access (often via an application password).
• Key configuration: Set wordpress_site_url, wordpress_post_status, language, and the word-count limit.