Automate SEO-Optimized WordPress posts with AI & Google Sheets

This workflow automates the process of creating a complete SEO-optimized blog post, including generating content, titles, images, and meta tags, and publishing it on WordPress. It leverages AI models (like DeepSeek and OpenRouter) for content generation and SEO optimization, and integrates with Google Sheets, WordPress, and OpenAI for image generation.

This is a powerful tool for automating the creation and optimization of blog posts, saving time and ensuring high-quality, SEO-friendly content. It integrates multiple tools and AI models to deliver a seamless content creation experience.

Below is a breakdown of the workflow:

---

1. How It Works The workflow is designed to streamline the creation of SEO-friendly blog posts. Here's how it works:

1. Trigger: The workflow starts with a Manual Trigger node, which initiates the process when the user clicks "Test workflow." 2. Fetch Context: The Google Sheets node retrieves the blog post context (e.g., topic, keywords) from a predefined Google Sheet. 3. Generate Content: - The Generate Article node uses an AI model (DeepSeek) to create an SEO-friendly blog post based on the fetched context. - The Generate Title node creates a compelling, keyword-rich title for the blog post. 4. Publish to WordPress: - The Add Draft to WP node creates a draft post in WordPress with the generated content and title. 5. Generate and Upload Image: - The Generate Image node uses OpenAI to create a realistic, blog-appropriate image. - The Upload Image node uploads the image to WordPress media. - The Set Image node associates the uploaded image as the featured image for the blog post. 6. SEO Optimization: - The SEO Expert node analyzes the blog post and generates optimized meta titles and descriptions using an AI model (OpenRouter). - The Set Metatag node updates the WordPress post with the generated meta tags. 7. Update Google Sheets: - The Update Sheet and Finish Work nodes update the Google Sheet with the post's details, including the URL, title, and metadata.

---

2. Set Up Steps To set up and use this workflow in n8n, follow these steps: