Back to Catalog

Automate SEO-Optimized blog creation with GPT-4o, Perplexity AI & multi-language support

Daniel NgDaniel Ng
106 views
2/3/2026
Official Page

WordPress Blog Automation Pro v2.1 – with DEEPER RESEARCH – Advanced Content Automation

This advanced, dual-workflow system automates the entire lifecycle of creating in-depth, SEO-optimized blog posts. It transforms a simple topic from a Google Sheet into a fully researched, well-structured, and image-rich article published directly on your WordPress site, with all assets securely backed up to Google Drive. It leverages AI for multi-layered research, content generation, and image creation, streamlining your content pipeline.

This version 2.1 is an upgrade from the WordPress Auto-Blogging Pro v2 - with DEEPER RESEARCH - Advanced Content Automation.

For more powerful n8n templates, visit our website at aiautomationpro.org.

AIAutomationProWordPressBlogAutomationDeeperResearchv2.11.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.12.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.13.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.14.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.15.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.16.jpegAIAutomationProWordPressBlogAutomationDeeperResearchv2.17.jpeg

What's new in version 2.1

Version 2.1 introduces several upgrades for efficiency and simplicity:

  1. Re-architecture of the core AI logic: The initial AI research agent is now more powerful. It not only provides a general overview but also proactively defines and returns the complete chapter structure for the article in a single step. This integration results in a more coherent and logically structured article from the very beginning.
  2. Multi-Language Support: The workflow is now designed to support content creation in multiple languages, allowing you to scale your content strategy globally.
  3. Simplified Architecture with Native Perplexity Node: Thanks to updates in n8n's Perplexity node, the separate "Research Tool" sub-workflow has been eliminated. All research calls are now made directly within the Main Flow. This simplifies the template's structure from three workflows down to two, making it easier to set up, manage, and debug.
  4. Enhanced AI Reliability: The new version uses Structured Output Parsers within the LangChain framework. This ensures the AI's responses are always in a clean, predictable JSON format, drastically reducing errors and making the entire automation more resilient.

What problem is this workflow solving? / Use cases

Standard content automation often struggles with producing truly in-depth, comprehensive content. This workflow addresses that challenge by:

  • Automating Multi-Level Research: Optionally eliminates the manual effort required to deeply research topics, ensuring content is thorough and well-supported.
  • Generating Long-Form Content: Enables the creation of detailed articles, comprehensive reports, or even initial e-book drafts automatically.
  • Scaling Content Production: Efficiently handles lists of topics from Google Sheets, processing them sequentially for reliable, automated content creation over time.
  • Enhancing SEO Automatically: Integrates best practices like sitemap-based internal linking, external source linking, automatic categorization, and tag generation.
  • Streamlining Complex Tasks: Combines research, writing, image generation, SEO optimization, publishing, and comprehensive backups into a single, automated system.

Who is this for?

This advanced workflow is designed for demanding users who require robust, comprehensive content automation:

  • Content Marketers & Strategists
  • SEO Professionals
  • Niche Site Builders & Affiliates
  • Agencies
  • Researchers & Analysts
  • Power Users of previous versions ready to upgrade to a more powerful and streamlined architecture.

Unique Features

  • Conditional Deeper Research: Choose per-topic whether to activate multi-level research for maximum depth or use standard chapter-level research.
  • Multi-Language Content Generation: Define your desired output language in the Airtable settings to create content for different global audiences.
  • Centralized Control Interface: Google Sheets acts as the primary interface for bulk input, parameter setting, and status monitoring.
  • Dual Trigger Options: Use Google Sheets for batch processing lists of topics or n8n’s Native Form for single, ad-hoc topic submission.
  • Latest AI Image Models: Optimized for high-quality images using OpenAI’s latest models, with easy node setup to switch to alternatives.
  • Multiple-Image Generation: Generates and adds unique AI images for each chapter, as well as a featured image for the article.
  • Automatic Categorization: The AI intelligently assigns your post to the most relevant existing categories on your WordPress site.
  • AI-Powered Tag Generation: The workflow automatically generates a list of relevant SEO tags for your article to improve discoverability.
  • Batch Topic Processing: Handles multiple topic inputs efficiently via the Trigger Flow loop, processing them sequentially with status tracking.
  • Advanced External & Internal Linking: Automatically inserts relevant internal links by analyzing your sitemap and includes external source links from its research.
  • Direct WordPress Integration: Streamlines publication by automatically sending finalized content, metadata, tags, images, and categories to your WordPress site.
  • Comprehensive Backup System: Saves final content in multiple formats and locations: Markdown to Google Docs, Images to Google Drive, Final URLs and details to Google Sheets.
  • Rate-Limit Aware: Includes configurable Wait nodes to prevent API errors during intensive processing.
  • Native Perplexity Integration: Simplifies online research with n8n's built-in Perplexity node.

How this workflow works

This template utilizes two interconnected n8n flows, orchestrated primarily via Google Sheets.

  1. Trigger Flow (Scheduler & Dispatcher): Activates on a schedule or via a form. It reads rows from a Google Sheet where the Status is 'To Do' and executes the Main Flow for each topic, one by one.
  2. Main Flow (Content Generation Engine):
    • Setup: Receives parameters from the Trigger Flow and updates the topic's status to 'In Progress'.
    • Research & Planning: Gathers internal links from your sitemap and performs initial online research using the native Perplexity node. A LangChain-based AI agent then outlines the entire article.
    • Conditional Content Creation: Based on the Have Deeper Research flag, it either performs multi-level research or standard chapter-level research.
    • Image Generation & Upload: Generates and uploads a featured image and images for each chapter to WordPress and Google Drive.
    • Publishing & Backup: Assembles the final article, converts it to HTML, publishes it to WordPress with all SEO metadata, and saves comprehensive backups to Google Sheets and Google Docs.
    • Finalize: Updates the topic's Status to 'Done' in the Google Sheet.

Requirements

  • n8n Instance
  • OpenAI API Key
  • Perplexity API Key
  • WordPress Website (REST API enabled, with an Application Password)
  • Google Account (for Sheets, Drive, and Docs)

Setup Step-by-Step

  1. Import Workflows: Download and import the two .json files (Trigger Flow and Main Flow).
  2. Configure Google Sheet: Find the link to the Google Sheet template in the automated email you received after your order confirmation. You must make your own copy of this sheet. Do not request access to the original link. The sheet has two tabs: Create Topic and Final Blogs. Ensure the column headers in your copy match those used in the workflow nodes.
  3. Create Google Drive Folder: In your Google Drive, create a new folder where all your content backups (documents and images) will be stored. Copy the Folder ID from the URL (it's the string of letters and numbers at the end).
  4. Link Flows: In the Trigger Flow, open the "Execute Workflow" node and select your imported Main Flow from the dropdown menu.
  5. Configure Credentials: In n8n, add credentials for OpenAI, Perplexity, WordPress, and Google.
  6. Connect Workflow Nodes: Open both workflows and assign the correct credential to each relevant node. Update the "Google Sheets" nodes with your Sheet ID and the "Google Drive" nodes with the Folder ID you created in step 3.
  7. Initial Test Run: Add a test topic to your sheet, manually trigger the workflow, and verify the process completes successfully.
  8. Activate Workflow: Toggle the "Active" switch ON for the Trigger Flow. The Main Flow should remain inactive as it is triggered by the other flow.
  9. Finalize SEO in WordPress: The workflow saves the generated SEO meta title and meta description to the Final Blogs tab in your Google Sheet. After the post is created in WordPress (as a draft), you must manually copy these values from the sheet and paste them into your SEO plugin's fields (e.g., Yoast, Rank Math) on the WordPress post editor.

How to customize the workflow

  • Adjust the Schedule: Change the interval in the "Schedule Trigger" node of the Trigger Flow to control how often it checks for new topics.
  • Change Language: To generate content in a different language, open the Main Flow, go to the Global Configuration node, and update the language field to your desired language (e.g., "Spanish", "French", "German").
  • Refine AI Prompts: Modify the prompts in the OpenAI nodes within the "Main Flow" to fine-tune the writing style, tone, and structure of your articles.
  • Change Image Style: Edit the prompts in the "Generate Image" section to alter the style of the generated images to match your brand.
  • Customize Post Status: Change the default publishing status in the "WordPress" node from "draft" to "publish" if you want to post directly without a final review.

Automate SEO-Optimized Blog Creation with GPT-4o, Perplexity AI, and Multi-Language Support

This n8n workflow automates the entire process of generating and publishing SEO-optimized blog posts, complete with images and multi-language support. It leverages AI models like GPT-4o and Perplexity AI to create high-quality content, and integrates with Google Sheets, Google Drive, and WordPress for a seamless content publishing pipeline.

What it does

This workflow orchestrates a sophisticated content generation and publishing process:

  1. Triggers Manually or on Schedule: The workflow can be initiated manually or on a predefined schedule.
  2. Fetches Blog Post Ideas: It retrieves blog post ideas and their target languages from a Google Sheet.
  3. Generates Blog Content (Multi-language):
    • For each blog idea, it generates a detailed, SEO-optimized blog post using an AI Agent (likely GPT-4o or a similar large language model).
    • It includes steps for generating a compelling blog title, meta description, and the main body content.
    • It supports content generation in multiple languages as specified in the Google Sheet.
  4. Generates Blog Images: It creates a relevant image for each blog post using an AI image generation tool (implied by "Edit Image" node, likely via an HTTP Request to an API).
  5. Stores Content in Google Drive: The generated blog content (text and image) is saved to Google Drive.
  6. Publishes to WordPress:
    • The workflow publishes the generated blog post to WordPress, including the title, content, and featured image.
    • It handles potential delays using a "Wait" node before publishing.
  7. Updates Google Sheet Status: It updates the Google Sheet with the status of each blog post (e.g., "Published", "Error").
  8. Handles Errors and Retries: Includes logic for error handling and retries for robust operation.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Google Sheets Account: To manage blog post ideas and track publishing status.
  • Google Drive Account: To store generated blog content and images.
  • WordPress Account: To publish the blog posts.
  • OpenAI API Key: For the "OpenAI Chat Model" (likely GPT-4o) used by the AI Agent for content generation.
  • Perplexity AI API Key (or similar): Implied by the workflow name, likely used for research or content generation via HTTP Request.
  • AI Image Generation API Key: An API key for an image generation service (e.g., DALL-E, Midjourney, Stable Diffusion) to be used with the "HTTP Request" and "Edit Image" nodes.
  • Google OAuth2 Credentials: For Google Sheets, Google Drive, and Google Docs integrations.
  • WordPress Credentials: For publishing posts.

Setup/Usage

  1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Set up your Google OAuth2 credentials for Google Sheets, Google Drive, and Google Docs.
    • Configure your WordPress credentials.
    • Add your OpenAI API Key to the "OpenAI Chat Model" node's credentials.
    • Configure any other API keys (e.g., Perplexity AI, Image Generation API) in the relevant "HTTP Request" nodes.
  3. Update Google Sheet Node:
    • Specify the Spreadsheet ID and Sheet Name where your blog post ideas are listed.
    • Ensure your sheet has columns for at least "Blog Idea", "Language", and a column for status updates (e.g., "Published Status").
  4. Customize AI Agent Prompts:
    • Review and adjust the prompts within the "AI Agent" and "Basic LLM Chain" nodes to fine-tune the content generation for your specific needs (tone, style, SEO keywords).
    • Ensure the "Structured Output Parser" is configured to correctly parse the AI's output into the desired format.
  5. Configure Image Generation:
    • Adjust the "HTTP Request" node that calls the image generation API, including the endpoint, headers, and body to generate images based on the blog post content.
    • Configure the "Edit Image" node for any post-processing of the generated images.
  6. Configure Google Drive Node:
    • Specify the target folder in Google Drive where the generated content and images should be saved.
  7. Configure WordPress Node:
    • Set the correct WordPress site URL and ensure the "Post" operation is configured to create new posts with the generated title, content, and featured image.
  8. Activate the Workflow: Once all configurations are complete, activate the workflow. You can run it manually for testing or enable the "Schedule Trigger" for automated execution.

Related Templates

AI multi-agent executive team for entrepreneurs with Gemini, Perplexity and WhatsApp

This workflow is an AI-powered multi-agent system built for startup founders and small business owners who want to automate decision-making, accountability, research, and communication, all through WhatsApp. The “virtual executive team,” is designed to help small teams to work smarter. This workflow sends you market analysis, market and sales tips, It can also monitor what your competitors are doing using perplexity (Research agent) and help you stay a head, or make better decisions. And when you feeling stuck with your start-up accountability director is creative enough to break the barrier 🎯 Core Features 🧑‍💼 1. President (Super Agent) Acts as the main controller that coordinates all sub-agents. Routes messages, assigns tasks, and ensures workflow synchronization between the AI Directors. 📊 2. Sales & Marketing Director Uses SerpAPI to search for market opportunities, leads, and trends. Suggests marketing campaigns, keywords, or outreach ideas. Can analyze current engagement metrics to adjust content strategy. 🕵️‍♀️ 3. Business Research Director Powered by Perplexity AI for competitive and market analysis. Monitors competitor moves, social media engagement, and product changes. Provides concise insights to help the founder adapt and stay ahead. ⏰ 4. Accountability Director Keeps the founder and executive team on track. Sends motivational nudges, task reminders, and progress reports. Promotes consistency and discipline — key traits for early-stage success. 🗓️ 5. Executive Secretary Handles scheduling, email drafting, and reminders. Connects with Google Calendar, Gmail, and Sheets through OAuth. Automates follow-ups, meeting summaries, and notifications directly via WhatsApp. 💬 WhatsApp as the Main Interface Interact naturally with your AI team through WhatsApp Business API. All responses, updates, and summaries are delivered to your chat. Ideal for founders who want to manage operations on the go. ⚙️ How It Works Trigger: The workflow starts from a WhatsApp Trigger node (via Meta Developer Account). Routing: The President agent analyzes the incoming message and determines which Director should handle it. Processing: Marketing or sales queries go to the Sales & Marketing Director. Research questions are handled by the Business Research Director. Accountability tasks are assigned to the Accountability Director. Scheduling or communication requests are managed by the Secretary. Collaboration: Each sub-agent returns results to the President, who summarizes and sends the reply back via WhatsApp. Memory: Context is maintained between sessions, ensuring personalized and coherent communication. 🧩 Integrations Required Gemini API – for general intelligence and task reasoning Supabase- for RAG and postgres persistent memory Perplexity API – for business and competitor analysis SerpAPI – for market research and opportunity scouting Google OAuth – to connect Sheets, Calendar, and Gmail WhatsApp Business API – for message triggers and responses 🚀 Benefits Acts like a team of tireless employees available 24/7. Saves time by automating research, reminders, and communication. Enhances accountability and strategy consistency for founders. Keeps operations centralized in a simple WhatsApp interface. 🧰 Setup Steps Create API credentials for: WhatsApp (via Meta Developer Account) Gemini, Perplexity, and SerpAPI Google OAuth (Sheets, Calendar, Gmail) Create a supabase account at supabase Add the credentials in the corresponding n8n nodes. Customize the system prompts for each Director based on your startup’s needs. Activate and start interacting with your virtual executive team on WhatsApp. Use Case You are a small organisation or start-up that can not afford hiring; marketing department, research department and secretar office, then this workflow is for you 💡 Need Customization? Want to tailor it for your startup or integrate with CRM tools like Notion or HubSpot? You can easily extend the workflow or contact the creator for personalized support. Consider adjusting the system prompt to suite your business

ShadrackBy Shadrack
331

🎓 How to transform unstructured email data into structured format with AI agent

This workflow automates the process of extracting structured, usable information from unstructured email messages across multiple platforms. It connects directly to Gmail, Outlook, and IMAP accounts, retrieves incoming emails, and sends their content to an AI-powered parsing agent built on OpenAI GPT models. The AI agent analyzes each email, identifies relevant details, and returns a clean JSON structure containing key fields: From – sender’s email address To – recipient’s email address Subject – email subject line Summary – short AI-generated summary of the email body The extracted information is then automatically inserted into an n8n Data Table, creating a structured database of email metadata and summaries ready for indexing, reporting, or integration with other tools. --- Key Benefits ✅ Full Automation: Eliminates manual reading and data entry from incoming emails. ✅ Multi-Source Integration: Handles data from different email providers seamlessly. ✅ AI-Driven Accuracy: Uses advanced language models to interpret complex or unformatted content. ✅ Structured Storage: Creates a standardized, query-ready dataset from previously unstructured text. ✅ Time Efficiency: Processes emails in real time, improving productivity and response speed. *✅ Scalability: Easily extendable to handle additional sources or extract more data fields. --- How it works This workflow automates the transformation of unstructured email data into a structured, queryable format. It operates through a series of connected steps: Email Triggering: The workflow is initiated by one of three different email triggers (Gmail, Microsoft Outlook, or a generic IMAP account), which constantly monitor for new incoming emails. AI-Powered Parsing & Structuring: When a new email is detected, its raw, unstructured content is passed to a central "Parsing Agent." This agent uses a specified OpenAI language model to intelligently analyze the email text. Data Extraction & Standardization: Following a predefined system prompt, the AI agent extracts key information from the email, such as the sender, recipient, subject, and a generated summary. It then forces the output into a strict JSON structure using a "Structured Output Parser" node, ensuring data consistency. Data Storage: Finally, the clean, structured data (the from, to, subject, and summarize fields) is inserted as a new row into a specified n8n Data Table, creating a searchable and reportable database of email information. --- Set up steps To implement this workflow, follow these configuration steps: Prepare the Data Table: Create a new Data Table within n8n. Define the columns with the following names and string type: From, To, Subject, and Summary. Configure Email Credentials: Set up the credential connections for the email services you wish to use (Gmail OAuth2, Microsoft Outlook OAuth2, and/or IMAP). Ensure the accounts have the necessary permissions to read emails. Configure AI Model Credentials: Set up the OpenAI API credential with a valid API key. The workflow is configured to use the model, but this can be changed in the respective nodes if needed. Connect the Nodes: The workflow canvas is already correctly wired. Visually confirm that the email triggers are connected to the "Parsing Agent," which is connected to the "Insert row" (Data Table) node. Also, ensure the "OpenAI Chat Model" and "Structured Output Parser" are connected to the "Parsing Agent" as its AI model and output parser, respectively. Activate the Workflow: Save the workflow and toggle the "Active" switch to ON. The triggers will begin polling for new emails according to their schedule (e.g., every minute), and the automation will start processing incoming messages. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.

DavideBy Davide
1616

Send WooCommerce discount coupons to customers via WhatsApp using Rapiwa API

Who is this for? This workflow is ideal for WooCommerce store owners who want to automatically send promotional WhatsApp messages to their customers when new coupons are created. It’s designed for marketers and eCommerce managers looking to boost engagement, streamline coupon sharing, and track campaign performance effortlessly through Google Sheets. Overview This workflow listens for WooCommerce coupon creation events (coupon.created) and uses customer billing data to send promotional WhatsApp messages via the Rapiwa API. The flow formats the coupon data, cleans phone numbers, verifies WhatsApp registration with Rapiwa, sends the promotional message when verified, and logs each attempt to Google Sheets (separate sheets for verified/sent and unverified/not sent). What this Workflow Does Listens for new coupon creation events in WooCommerce via the WooCommerce Trigger node Retrieves all customer data from the WooCommerce store Processes customers in batches to control throughput Cleans and formats customer phone numbers for WhatsApp Verifies if phone numbers are valid WhatsApp accounts using Rapiwa API Sends personalized WhatsApp messages with coupon details to verified numbers Logs all activities to Google Sheets for tracking and analysis Handles both verified and unverified numbers appropriately Key Features Automated coupon distribution: Triggers when new coupons are created in WooCommerce Customer data retrieval: Fetches all customer information from WooCommerce Phone number validation: Verifies WhatsApp numbers before sending messages Personalized messaging: Includes customer name and coupon details in messages Dual logging system: Tracks both successful and failed message attempts Rate limiting: Uses batching and wait nodes to prevent API overload Data formatting: Structures coupon information for consistent messaging Google Sheet Column Structure A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: | name | number | email | address1 | couponCode | couponTitle | couponType | couponAmount | createDate | expireDate | validity | status | | ----------- | ------------- | --------------------------------------------------- | --------- | ---------- | -------------- | ---------- | ------------ | ------------------- | ------------------- | ---------- | -------- | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur-DOHS | 62dhryst | eid offer 2025 | percent | 20.00 | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | verified | sent | Requirements n8n instance with the following nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait WooCommerce store with API access Rapiwa account with API access for WhatsApp verification and messaging Google account with Sheets access Customer phone numbers in WooCommerce (stored in billing.phone field) Important Notes Phone Number Format: The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format. API Rate Limits: Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly. Data Privacy: Ensure compliance with data protection regulations when sending marketing messages. Error Handling: The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls. Message Content: The current message template references the first coupon only (coupons[0]). Adjust if you need to handle multiple coupons. Useful Links Dashboard: https://app.rapiwa.com Official Website: https://rapiwa.com Documentation: https://docs.rapiwa.com Support & Help WhatsApp: Chat on WhatsApp Discord: SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen

RapiwaBy Rapiwa
110