Generate SEO WordPress blog posts from Google Sheets with Perplexity and GPT-5
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI Chat Model, Wordpress and OpenAI.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Configuration (Edit Fields (Set)): sets 12 fields: openai_text_model, openai_image_model, image_size…
- Get Unprocessed Idea (Google Sheets): uses Google Sheets
- Research Topic with Perplexity (Perplexity): uses Perplexity
- Write Article and Title (AI Agent): runs an AI agent, with model: OpenAI Model - Writer; output parser: Article Output Parser
- Create Draft Post on WordPress (Wordpress): uses Wordpress
- Generate Cover Image with DALL-E (OpenAI): work with image
- Upload Cover Image to WordPress (HTTP Request): calls an HTTP API (POST)
- Set Featured Image on Post (HTTP Request): calls an HTTP API (POST)
- Update Idea Row in Google Sheets (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Perplexity
n8n-nodes-base.perplexity - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Wordpress
n8n-nodes-base.wordpress - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest
From the author
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…