Get Started
Back to Templates

Automate Blog Creation & Publishing with Gemini, Ideogram AI and WordPress

Created by

Created by: Incrementors || incrementors

Incrementors

Last update

Last update 4 days ago

Categories

Share

Overview:

This n8n workflow automates the complete blog publishing process from topic research to WordPress publication. It researches topics, writes SEO-optimized content, generates images, publishes posts, and notifies teams—all automatically from Google Sheets input.

How It Works:

Step 1: Client Management & Scheduling

  • Client Data Retrieval: Scans master Google Sheet for clients with "Active" project status and "Automation" blog publishing setting
  • Publishing Schedule Validation: Checks if current day matches client's weekly frequency (Mon, Tue, Wed, Thu, Fri, Sat, Sun) or if set to "Daily"
  • Content Source Access: Connects to client-specific Google Sheet using stored document ID and sheet name

Step 2: Content Planning & Selection

  • Topic Filtering: Retrieves rows where "Status for Approval" = "Approved" and "Live Link" = "Pending"
  • Content Validation: Ensures Focus Keyword field is populated before proceeding
  • Single Topic Processing: Selects first available topic to maintain quality and prevent API rate limits

Step 3: AI-Powered Research & Writing

  • Comprehensive Research: Google Gemini analyzes search intent, competitor content, audience needs, trending subtopics, and LSI keywords
  • Content Generation: Creates 800-1000 word articles with natural keyword integration, internal linking, and conversational tone optimized for Indian investors
  • Quality Assessment: Evaluates content for human-like writing, conversational tone, readability, and engagement factors
  • Content Optimization: Automatically fixes grammar, punctuation, sentence flow, and readability issues while maintaining HTML structure

Step 4: Visual Content Creation

  • Image Prompt Generation: OpenAI creates detailed prompts based on blog title and content for professional visuals
  • Image Generation: Ideogram AI produces 1248x832 resolution images with realistic styling and professional appearance
  • Binary Processing: Downloads and converts generated images to binary format for WordPress upload

Step 5: WordPress Publication

  • Media Upload: Uploads generated image to WordPress media library with proper filename and headers
  • Content Publishing: Creates new WordPress post with title, optimized content, and embedded image
  • Featured Image Assignment: Sets uploaded image as post's featured thumbnail for proper display
  • Category Assignment: Automatically assigns posts to predefined category

Step 6: Tracking & Communication

  • Status Updates: Updates Google Sheet with live blog URL in "Live Link" column using S.No. as identifier
  • Team Notification: Sends Discord message to designated channel with published blog link and review request
  • Process Completion: Triggers next iteration or workflow conclusion based on remaining topics

Setup Steps:

Estimated Setup Time: 45-60 minutes

Required API Credentials:

1. Google Sheets API

  • Service account with sheets access
  • OAuth2 credentials for client-specific sheets
  • Proper sharing permissions for all target sheets

2. Google Gemini API

  • Active API key with sufficient quota
  • Access to Gemini Pro model for content generation
  • Rate limiting considerations for bulk processing

3. OpenAI API

  • GPT-4 access for creative prompt generation
  • Sufficient token allocation for daily operations
  • Fallback handling for API unavailability

4. Ideogram AI API

  • Premium account for quality image generation
  • API key with generation permissions
  • Understanding of rate limits and pricing

5. WordPress REST API

  • Application passwords for each client site
  • Basic authentication setup with proper encoding
  • REST API enabled in WordPress settings
  • User permissions for post creation and media upload

6. Discord Bot API

  • Bot token with message sending permissions
  • Channel ID for notifications
  • Guild access and proper bot roles

Master Sheet Configuration:

Document Structure: Create primary tracking sheet with columns

  • Client Name: Business identifier
  • Project Status: Active/Inactive/Paused
  • Blog Publishing: Automation/Manual/Disabled
  • Website URL: Full WordPress site URL with trailing slash
  • Blog Posting Auth Code: Base64 encoded username: password
  • On Page Sheet: Google Sheets document ID for content planning
  • WeeklyFrequency: Daily/Mon/Tue/Wed/Thu/Fri/Sat/Sun
  • Discord Channel: Channel ID for notifications

Content Planning Sheet Structure:

Required Columns (exact naming required):

  • S.No.: Unique identifier for tracking
  • Focus Keyword: Primary SEO keyword
  • Content Topic Article title/subject
  • Target Page: Internal linking target
  • Words: Target word count
  • Brief URL: Content brief reference
  • Content URL: Draft content location
  • Status for Approval: Pending/Approved/Rejected
  • Live Link: Published URL (auto-populated)

WordPress Configuration:

  • REST API Activation: Ensure wp-json endpoint accessibility
  • User Permissions: Create dedicated user with Editor or Administrator role
  • Application Passwords: Generate secure passwords for API authentication
  • Category Setup: Create or identify category ID for automated posts
  • Media Settings: Configure upload permissions and file size limits
  • Security: Whitelist IP addresses if using security plugins

Discord Integration Setup:

  • Bot Creation: Create application and bot in Discord Developer Portal
  • Permissions: Grant Send Messages, Embed Links, and Read Message History
  • Channel Configuration: Set up dedicated channel for blog notifications
  • User Mentions: Configure user ID for targeted notifications
  • Message Templates: Customize notification format and content

Workflow Features & Capabilities:

Content Quality Standards:

  • SEO Optimization: Natural keyword integration with LSI keywords and related terms
  • Readability: Conversational tone with short sentences and clear explanations
  • Structure: Proper HTML formatting with headings, lists, and internal links
  • Length: Consistent 800-1000 word count for optimal engagement
  • Audience Targeting: Content tailored for Indian investor audience with relevant examples

Image Generation Specifications:

  • Resolution: 1248x832 pixels optimized for blog headers
  • Style: Realistic professional imagery with human subjects
  • Design: Clean layout with heading text placement (bottom or left side)
  • Quality: High-resolution output suitable for web publishing
  • Branding: Light beige to gradient backgrounds with golden overlay effects

Error Handling & Reliability:

  • Graceful Failures: Workflow continues even if individual steps encounter errors
  • API Rate Limits: Built-in delays and retry mechanisms for external services
  • Data Validation: Checks for required fields before processing
  • Backup Processes: Alternative paths for critical failure points
  • Logging: Comprehensive tracking of successes and failures

Security & Access Control:

  • Credential Encryption: All API keys stored securely in n8n vault
  • Limited Permissions: Service accounts with minimum required access
  • Authentication: Basic auth for WordPress with encoded credentials
  • Data Privacy: No sensitive information exposed in logs or outputs
  • Access Logging: Track all sheet modifications and blog publications

Troubleshooting:

Common Issues:

  • API Rate Limits: Check your API quotas and usage limits
  • WordPress Authentication: Verify your basic auth credentials are correct
  • Sheet Access: Ensure Google Sheets API has proper permissions
  • Image Generation Fails: Check Ideogram API key and quotas

Need Help?:

For technical support or questions:
Email: [email protected]
Contact Form: https://www.incrementors.com/contact-us/