Generate & Schedule SEO Blog Posts for Multiple Clients with Gemini AI & Elementor

Created by

Zain Khan

Last update

Last update a day ago

This is not a simple HTML blog post generator like others

Unlike simple HTML blog post generators, this workflow doesn't just create an article—it builds a fully structured, Elementor-ready post that inherits your client's theme styling and responsiveness. This eliminates the need for any manual design work, saving you countless hours.

Key Workflow Features & How It Works

1. Flexible Triggers: On-Demand & Scheduled Posting

This workflow provides two powerful ways to initiate blog post generation, giving you complete control and flexibility:

Manual Trigger (Form Submission): Instantly generate a blog post by filling out a simple n8n form. This is perfect for one-off requests or urgent content needs. The form includes fields for:
- Client Selection: A dynamic dropdown list that automatically pulls client names from your Google Sheet.
- Main & Secondary Keywords: The core SEO terms for the article.
- Content Tone: Choose from options like Casual, Professional, or Formal to match the client's brand voice.
- Competitor URLs: Provide links for the AI to research and analyze.
- FAQs & Content Guidelines: Add specific questions and instructions to ensure the content meets your exact requirements.
Automated Trigger (Scheduler): For long-term content strategies, the workflow includes a schedule-based trigger. Simply add your blog post ideas, the target client, and the desired date and time to a Google Sheet. The workflow checks this sheet hourly and automatically generates and publishes any posts that are due, ensuring a consistent content pipeline.

2. Centralized Client & Content Management (Google Sheets)

At the heart of this workflow is a three-sheet Google Sheets system that keeps everything organized:

Clients Sheet: This is your client database. It holds essential information like Name, Company, and WordPress app credentials for seamless API authentication.
Blog Ideas/Schedule Sheet: This is your content calendar. Here, you can plan upcoming posts by specifying the client, main keyword, secondary keywords, and the schedule date and time. This sheet also tracks the publishing status of each post.
History Sheet: Every time a blog post is successfully generated and published, a record is added to this sheet, providing a comprehensive log of all your content activities.

3. Intelligent AI Content Generation

The workflow leverages an AI Agent powered by Google Gemini to create unique, high-quality content. The agent is given a detailed, customizable prompt that includes:

Strict Guidelines: The AI is instructed to follow specific SEO and formatting rules, such as placing the main keyword in the first paragraph, maintaining a specific reading level, and avoiding generic phrases.
Structured Headings: The prompt mandates a clear heading structure (H1, H2, H3, etc.) to ensure the article is well-organized and easy to read.
Competitive Analysis: By providing competitor URLs, the AI can analyze their strategies and create more comprehensive and relevant content.
Word Count & Tone: The agent is given a target word count and instructed to write in the specified tone, ensuring the content is always on-brand.

Image Generation: The workflow automatically creates a unique featured image for the blog post. It uses the blog post's main keyword and topic to generate a compelling visual that perfectly matches the article's subject matter.

4. The Magic: Converting to Elementor-Ready JSON

This is the most unique and powerful feature of this workflow. A custom JavaScript function parses the raw HTML output from the AI and transforms it into a structured Elementor JSON format.

Why is this crucial? Standard HTML is just text. Elementor, on the other hand, relies on a specific JSON structure to build pages using its drag-and-drop editor. Simply pasting HTML would strip the post of its theme-specific styling, blocks, and mobile responsiveness.
The Conversion Process: The function intelligently identifies headings, paragraphs, and lists, and converts them into the correct Elementor Container, Heading, and Text-Editor widget objects. It even handles complex structures like FAQs, converting them into a native Elementor Accordion Widget.

5. Seamless WordPress Integration

Once the content is in the perfect Elementor format, the workflow uses a WordPress node to authenticate and publish the post. It sends the title and the Elementor JSON data to the client's WordPress site via the API, creating a new blog post that looks and feels like it was manually built using the Elementor editor.

This end-to-end automation allows your agency to scale content production, maintain quality and consistency across all clients, and free up valuable time for strategic tasks.

How to Use This Workflow

Set Up Your Google Sheets:

Use the provided template to create three Google Sheets: Clients, Schedule, and History.
Populate the Clients sheet with your clients' details, including their WordPress credentials.
Begin adding your content ideas and schedules to the Schedule sheet.

Connect Your n8n Account:

Connect the Google Sheets nodes to your Google account.
Connect the Google Gemini node to your API key.
Connect the n8n nodes to your n8n account to allow the workflow to update the form dropdown.

Run the Workflow:

For scheduled posts, the workflow will run automatically at the specified intervals.
For on-demand posts, simply access the n8n form and submit your content details.

Requirements

n8n Instance: This workflow requires a self-hosted or cloud n8n instance. Signup using https://n8n.partnerlinks.io/pe6gzwqi3rqw
Google Account: You need a Google account to use Google Sheets. Copy the template which is present in the workflow.
Google Gemini API Key: A valid Google Gemini API key is required for content generation.
WordPress App Passwords: Go in Wordpress Users section, generate a new app password and put in the

Note: This workflow is specifically designed for WordPress sites using the Elementor page builder.