Create and publish SEO blog posts using Google Sheets, Gemini/OpenAI, Ideogram, and WordPress

This workflow automates the complete blog publishing process. It removes manual work from content creation, image generation, category management, and WordPress publishing by using AI and n8n. It helps agencies, SEO teams, and content creators manage blogs at scale.

Key Features

- Scheduled or manual blog publishing - Automated topic research and content writing - AI-generated featured and in-content images using Ideogram - Dynamic WordPress category detection and creation - Automatic media upload with SEO-friendly alt text - Internal linking using sitemap data - Google Sheets logging for published URLs - Error notifications for failed executions

What This Workflow Does

Input

- Blog topics or keywords stored in Google Sheets - Target WordPress site details - Publishing rules and schedule

Processing

1. Triggers the workflow on a schedule or manual run 2. Fetches blog posting data from Google Sheets 3. Validates active projects or websites 4. Performs topic and SEO research 5. Writes long-form, SEO-optimized blog content 6. Generates image prompts and creates images using Ideogram 7. Uploads images to WordPress with alt text 8. Detects or creates blog categories dynamically 9. Publishes the blog post to WordPress