Generate SEO WordPress blog posts from Google Sheets with Perplexity and GPT-5

Go to Workflow
0 views
Built by Dr. Firas Dr. Firas
Created on August 20, 2026

Description

Quick overview
This workflow pulls blog topic ideas from Google Sheets, researches each topic with Perplexity, generates an SEO-ready HTML article plus metadata with OpenAI GPT-5, then creates a WordPress draft and attaches a DALL路E cover image as the featured image.

How it works
Starts when you manually run the workflow.
Reads a content idea (from the PROMPT column) from a Google Sheets content plan.
Uses Perplexity to research the topic with a defined recency window and returns bullet-point findings.
Uses OpenAI GPT-5 to write a structured output containing an SEO title, meta description, slug, and the full article body formatted as HTML.
Creates a new WordPress post using the generated title, slug, and HTML content with the configured post status.
Generates a photorealistic cover image with OpenAI DALL路E, uploads it to the WordPress media library, and sets it as the post鈥檚 featured image.
Updates the original Google Sheets row to record publishing details such as the WordPress post ID.

Setup
Create a Google Sheet (for example with columns like PROMPT, TITLE, and ID POST) and select the target spreadsheet and sheet/tab in both Google Sheets nodes.
Add credentials for Google Sheets OAuth2, Perplexity, OpenAI (for GPT-5 text and DALL路E image generation), and WordPress (REST API access, typically via an application password).
Update the Configuration values, especially wordpress_site_url, wordpress_post_status, language, word-count limits, and the Perplexity search recency.
Ensure your WordPress site allows REST API media uploads and that the WordPress credential has permission to create posts and upload media.

Additional info
Generate SEO content with Perplexity and GPT-5 for WordPress
馃摜 Open full documentation on Notion

Need help customizing?
Contact me for consulting and support : Linkedin

MY NEW YOUTUBE CHANNEL
馃憠 Subscribe to my new YouTube channel. Here I'll share videos and Shorts with practical tutorials and FREE templates for n8n.

Nodes Used (8)

AI Agent
@n8n/n8n-nodes-langchain.agent
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
OpenAI
@n8n/n8n-nodes-langchain.openAi
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Perplexity
n8n-nodes-base.perplexity
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
Wordpress
n8n-nodes-base.wordpress