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 Output - Live published blog post URL - Updated Google Sheet with publishing details - Notification alerts if any step fails Setup Instructions Prerequisites - n8n instance (cloud or self-hosted) - WordPress site with REST API access - Google Sheets access - AI model credentials (Google Gemini, OpenAI, or DeepSeek) - Ideogram API access - Notification service (Discord or Slack) Step 1: Import the Workflow 1. Download or copy the workflow JSON 2. In n8n, go to Workflows → Import from file / JSON 3. Import the workflow Step 2: Configure Credentials Set up the required credentials inside n8n's credential manager: - Google Sheets OAuth: For reading posting data and saving URLs - WordPress API: For publishing posts and uploading media - AI Model: Connect Google Gemini, OpenAI, or DeepSeek - Ideogram API: For AI image generation - Discord/Slack Webhook: For error notifications Important: No credentials are hardcoded. All must be connected via n8n's credential manager. Step 3: Configure Google Sheets Prepare a Google Sheet containing: - Blog topic or keyword - Target website or domain - Publishing status fields - Domain ID for tracking Update the Sheet ID inside the GetPostData node after import. Step 4: Configure Website Access Update the PBNWebsiteAccess node with your WordPress site access endpoint or API. This node should return: - Complete WordPress URL - Basic authentication token - Sitemap post URL Step 5: Configure Publishing & Schedule - Adjust the Schedule Trigger if auto-publishing is required - Modify publishing frequency or time zone - Review WordPress post status (draft or publish) Step 6: Test & Activate 1. Add one test row in Google Sheets 2. Run the workflow manually 3. Verify: - Content creation - Image generation - WordPress publishing - Sheet updates 4. Activate the workflow Usage Guide Adding New Blog Posts Add a new row in the connected Google Sheet with the required blog topic and website details. The workflow will automatically process and publish the post on the next execution. Understanding the Output After execution, the workflow: - Publishes a complete blog post on WordPress - Attaches featured and in-content images - Assigns the correct category - Logs the live URL back to Google Sheets Workflow Node Breakdown GetPostData Fetches blog posting details from Google Sheets based on the current day. It pulls keywords, landing pages, domain IDs, and posting websites. getclientstatus Checks the client's project status from the project sheet. It verifies whether the client is active or inactive before proceeding further. This prevents publishing content for paused or stopped clients. PBNWebsiteAccess Fetches WordPress website access details such as site URL, authentication token, and sitemap URL. These details are required for publishing posts, uploading images, and managing categories. Do the Research on the Topic Performs deep SEO research on the target keyword. It analyzes search intent, content gaps, and audience needs. This ensures the generated content is informative, relevant, and SEO-optimized. sitemapcrawl (internallinking) Crawls the website sitemap to collect internal URLs. These URLs are later used for internal linking inside the blog content. Internal links help improve SEO and site structure. writecontent Uses AI to write an 800-1000 word SEO-optimized blog article based on research data. The content includes proper HTML formatting, internal links, and anchor keyword placement. extracttitlebody Separates the H1 title from the blog body content for proper WordPress publishing format. classifycategory Automatically determines the most suitable category for the blog post by analyzing the blog title and content context. This keeps the website's category structure clean and relevant. getcategory & createcategory Checks if the determined category exists in WordPress. If not, it creates a new category automatically. generateimageprompt Analyzes the blog content and generates AI prompts for creating relevant images including thumbnail and in-content images. Thumbnail Image Generator & Blog Image Generator Generate high-quality images using Ideogram API based on AI-generated prompts. Images are created with proper resolution and rendering settings. Thumbnail Uploading & Blog Image Uploading Upload generated images to WordPress media library and retrieve media IDs for post attachment. Add Alt Text in Images Adds SEO-friendly alt text to uploaded images to improve accessibility and search engine optimization. Blog and Photo Merge Merges the generated images into the blog content at appropriate positions within the article. publishblog Publishes the complete blog post to WordPress with title, content, category, featured image, and publish status. saveliveurl Saves the live published blog URL back into Google Sheets along with keyword, website URL, and timestamp for tracking and reporting. If Error Existed Then Get Notified Sends instant Discord or Slack notifications when any error occurs during workflow execution, ensuring no failure goes unnoticed. Customization Options - Change blog length or tone in the content generation node - Modify image style or resolution in Ideogram nodes - Add multi-site publishing using Switch nodes - Replace notification channel (Discord to Slack or Email) - Extend workflow to social media posting Troubleshooting Blog not published Check WordPress credentials and REST API permissions. Images not generated Verify Ideogram API credentials and prompt formatting. Sheet not updating Ensure correct Sheet ID and OAuth permissions. Workflow stopped Review execution logs and error notification messages. Use Cases - SEO blog automation for agencies - Content publishing for niche websites - Scalable blog management - AI-assisted content operations - Hands-free WordPress publishing Final Notes This workflow is designed to be reusable, scalable, and creator-friendly. It follows n8n best practices, avoids hardcoded credentials, and is suitable for public sharing as a workflow template. For any questions or support, please contact: info@incrementors.com or fill out this form: