Automated SEO Blog Publishing with WordPress, OpenAI & Perplexity
Automates end-to-end blog creation from Google Sheets: research via Perplexity, AI writing & images via OpenAI, then publishes SEO-optimized posts to WordPress with embedded visuals.
This powerful n8n workflow transforms a simple Google Sheets entry (title, short description, created date) into a fully published, SEO and RAO-optimized WordPress blog post. It handles research with Perplexity AI for accurate, up-to-date information, generates professional article content and contextual images using OpenAI (GPT and DALL-E), uploads images to Cloudinary for seamless embedding between paragraphs, and finally publishes to WordPress including title, excerpt, slug, body, and feature
- Platform
- n8n
- Category
- Sales
- Price
- $24.99
- Creator
- Halle Kowalczyk
- SEO
- Blogging
- WordPress
- OpenAI
- Perplexity
- Content Automation
- AI Writing
- Image Generation
- Marketing
- Google Sheets
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Sales workflows
- Automate B2B Lead Generation from Company Websites Using Brightdata and OpenRouter AI$14.99
- Automate Cold Calling Pipeline with Apify, OpenAI, and WhatsApp$19.99
- Automate Lead Generation and Enrichment Using Google My Business and Supabase$13.57
- Automate Sales Outreach with OpenAI, Airtable & Google Sheets for Prospect Research$9.99
- AI-Powered Lead Research & Personalized Email Generation with Groq & Google Sheets$14.99
- Automate Spare Parts Quotation with Gmail, Google Sheets, and Gemini AI$14.99
More from Halle Kowalczyk
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.