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

## **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 the current day matches clients' 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 the Focus Keyword field is populated before proceeding. - **Single Topic Processing:** Selects the 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 a new WordPress post with title, optimized content, and embedded image. - **Featured Image Assignment:** Sets uploaded image as the post's featured thumbnail for proper display. - **Category Assignment:** Automatically assigns posts to a predefined category. **Step 6: Tracking & Communication** - **Status Updates:** Updates Google Sheet with live blog URL in the Live Link column using S.No. as an identifier. - **Team Notification:** Sends a Discord message to the designated channel with the published blog link and review request. - **Process Completion:** Triggers the 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 a 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. - **Weekly Frequency:** 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 Config**