Google Docs and Wordpress integration

WordPress Auto-Blogging Pro v2 \- with DEEPER RESEARCH \- Advanced Content Automation (This version is an upgrade from v1: WordPress Auto-Blogging Pro \- with DEEP RESEARCH \- Content Automation Machine v1) Take your content automation to unprecedented depths\! This v2 template enhances the acclaimed "WordPress Auto-Blogging Pro \- with DEEP RESEARCH" by introducing Deeper Research, a multi-level research capability designed to generate exceptionally comprehensive, long-form content like detailed articles, reports, and even e-books. If you need more than just standard blog posts and crave truly authoritative, data-driven content generated automatically, this workflow is built for you. It optionally goes beyond simple topic research by breaking down subjects into sub-topics, and then further into sub-sub-topics, conducting real-time online research (powered by the Research Tool Sub-Flow using PerplexityAI) at each stage. This ensures unparalleled depth and coverage, perfect for tackling complex subjects. Combined with enhanced automation features for batch processing, categorization, tagging, linking, and image generation (using OpenAI's latest image model gpt-image-1 accessed via API), this is the ultimate engine for serious content automation on WordPress. It operates using a three-flow system: a Trigger Flow acts as a scheduler and dispatcher, a powerful Main Flow executes the complex content generation process, and a dedicated Research Tool Sub-Flow handles interactions with PerplexityAI. Visit AI Automation Pro’s website for more powerful n8n templates. What problem is this workflow solving? / Use cases Standard content automation often struggles with producing truly in-depth, comprehensive content on complex or rapidly evolving topics. This workflow addresses that challenge by: Automating Multi-Level Research:** Optionally eliminates the manual effort required to deeply research topics, sub-topics, and sub-sub-topics, ensuring content is thorough and well-supported when needed. 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, tag generation/management, and Table of Contents generation (with “Deeper Research” articles). Streamlining Complex Tasks:** Combines research (basic or deep), writing, image generation, SEO optimization, publishing, and comprehensive backup (Google Docs, Drive, Sheets) into a single, automated system. Ideal use cases include creating cornerstone content, detailed guides, industry reports, niche site authority building, and automating the production of deeply researched articles where maximum depth is required. Who is this for? This advanced workflow is designed for demanding users who require robust, comprehensive content automation: Content Marketers & Strategists:** Needing to produce authoritative, long-form content at scale, with options for varying research depth. SEO Professionals:** Aiming to build topical authority with well-researched, structured, and highly optimized content featuring strong internal/external linking. Niche Site Builders & Affiliates:** Seeking to dominate specific topics with comprehensive guides and articles. Agencies:** Managing large-scale content production for clients requiring in-depth material. Researchers & Analysts:** Looking to automate the drafting of reports or summaries based on online data. Power Users of v1:** Ready to upgrade to the next level of research depth, flexibility, and automation features. Unique Features This v2 workflow introduces significant upgrades and retains the best features of v1: Conditional Deeper Research:** Choose per-topic whether to activate multi-level research (topic \-\> sub-topic \-\> sub-sub-topic) for maximum depth or use standard chapter-level research. Modular Three-Flow Architecture:** Robust system with a Trigger Flow for scheduling, a Main Flow for generation, and a dedicated Research Tool Sub-Flow. Table of Contents Generation:** Automatically creates a ToC for improved readability and SEO on long articles. Latest AI Image Models:** Optimized for high-quality images using OpenAI's latest model (gpt-image-1 via API), with easy node setup to switch to alternatives. Automatic Categorization & Tag Management:** AI assigns posts to the most relevant existing WordPress category and creates/assigns relevant tags. Dual Trigger Options:** Use Google Sheets for batch processing lists of topics or n8n's Native Form for single, ad-hoc topic submission. 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 (from sitemap) and external source links (from research). 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. Centralized Control Interface:** Google Sheets acts as the primary interface for bulk input, parameter setting (like Have Deeper Research), and status monitoring. Direct WordPress Integration:** Seamlessly publishes content, metadata, tags, categories, and images. Rate-Limit Aware:** Includes configurable Wait nodes to prevent API errors during intensive processing. Robust Error Catching:** Uses 'If' nodes to validate AI outputs and ensure smooth data flow. How this workflow works This template utilizes three interconnected n8n flows: a Trigger Flow, a Main Flow, and a Research Tool Sub-Flow, orchestrated primarily via Google Sheets. 1\. Trigger Flow (Scheduler & Dispatcher): Trigger:** Activates via a Schedule (e.g., every 10 minutes) to check for new tasks OR via a direct n8n Form submission. Select Topics:** Reads rows from a specific Google Sheet (e.g., Deeper Research - Create Topics \-\> Create Topic sheet) where the Status column is 'To Do'. Loop & Dispatch:* Processes each 'To Do' topic one by one. For each topic, it executes the Main Flow*, passing the topic details and parameters. Wait:** Pauses for a configurable duration (default: 1 hour) after each topic's processing is initiated by the Sub-Workflow, helping manage API limits and pacing. 2\. Main Flow (Content Generation Engine): Trigger:** Starts when called by the Trigger Flow. Setup:** Receives topic parameters (Topic, Audience, Style, Word Count, Have Deeper Research flag, etc.) from the Trigger Flow. Updates the topic's Status to 'In Progress' in the Google Sheet. Internal Link Gathering:** Fetches your website's sitemap XML, parses it, and extracts a set number (e.g., up to 50\) of internal URLs for later use. Initial Research & Planning:* Executes the Research Tool Sub-Flow* to perform initial online research on the main topic. An AI Agent ("Blog Planner") then uses this research to outline the entire article: Title, Subtitle, Introduction, Slug, Meta Description, Tags, Chapter outlines, and prompts for chapter/featured images. Conditional Content Creation (Based on Have Deeper Research flag):** If YES: Executes the Deeper Research path: Loops through planned chapters \-\> Executes Research Tool Sub-Flow for Chapter Research \-\> AI splits chapter into subchapters \-\> Loops through subchapters \-\> Executes Research Tool Sub-Flow for Subchapter Research \-\> AI ("Subchapter Copywriter") writes detailed content for each subchapter \-\> Aggregates subchapters back into the main chapter content. If NO: Executes the Standard Research path: Loops through planned chapters \-\> Executes Research Tool Sub-Flow for Main Chapter Research \-\> AI ("Chapter Copywriter") writes content for each chapter. Image Generation & Upload:** Generates images (using OpenAI's gpt-image-1 or equivalent via HTTP Request) for each main chapter and a featured image. Resizes images and uploads them to both your WordPress Media Library and a specified Google Drive folder. Tag Management:** Checks if the AI-generated tags exist in WordPress. Creates new tags if necessary and retrieves the IDs for all relevant tags. Article Assembly:** Combines Introduction, finalized chapter content (from either research path), Conclusion, CTA, etc., into a complete article structured in Markdown format (using a Code node). HTML Conversion:** Converts the final Markdown content to HTML suitable for WordPress. Backup \- Google Docs:* Saves the final Markdown version of the article as a new document in a specified Google Drive folder. Note:* saving to Google Docs only works on "My Drive" and will NOT work on a Shared Drive due to Google Drive API restrictions. Publish to WordPress:** Creates a new post on your WordPress site with the Title, HTML content, Slug, assigned Category (auto-detected or default), Tag IDs, and sets the generated Featured Image. Also sets the Meta Description and Post Excerpt. Backup \- Google Sheets:** Saves the final details (Published URL, Markdown, HTML, Tags, Meta info, Slug, Excerpt, etc.) to a dedicated sheet (e.g., Final Blogs) within your main Google Sheet workbook. Final Status Update:** Updates the topic's Status to 'Done' in the original Create Topic sheet. 3\. Research Tool Sub-Flow (PerplexityAI Interaction): Trigger:** Starts when called by the Main Flow. Setup:** Receives parameters like the research query, model (sonar or sonar-deep-research), system message, and max tokens. API Call:** Makes a POST request to the PerplexityAI API with the provided parameters and authentication. Response Handling:** Extracts the content from the API response. Output:** Returns the research content back to the calling Main Flow. Requirements n8n Instance**. OpenAI API Key:** Or equivalent credentials for a powerful text generation model (default to GPT-4o) and an image generation model (like gpt-image-1, compatible with OpenAI node or direct HTTP Request). Perplexity API Key:** Or equivalent for an online research tool API (used via HTTP Request node in the Research Tool Sub-Flow). WordPress Website:** REST API enabled, with an Application Password granting permissions to create/edit posts, upload media, manage categories, and manage tags. Needs an accessible post-sitemap.xml. Google Account:** For Google Sheets (trigger, control parameters, status tracking, backup), Google Drive (image/text backup), and Google Docs (Markdown backup). Setup Step-by-Step Import Workflows: Download the three .json files (Trigger Flow, Main Flow, Research Tool Sub-Flow) and import them into your n8n instance. Name them clearly (e.g., "WP Deeper Research \- Trigger Flow", "WP Deeper Research \- Main Flow", "WP Deeper Research \- Research Tool Sub-Flow"). Configure Google Sheet: Clone or create a Google Sheet workbook (e.g., Deeper Research - Create Topics). Ensure two sheets within it: Create Topic and Final Blogs. Set up required columns in Create Topic (e.g., Topic, Status, Have Deeper Research, Audience, Style, etc. \- match these exactly to the names used in the workflow nodes). Set up columns in Final Blogs for backup (e.g., Topic Name, Final URL, Markdown, HTML, etc. \- match workflow nodes). Update all Google Sheets nodes in the Trigger Flow and Main Flow to point to the correct Workbook Name, Sheet Name, and ensure column names match. Link Flows: In the Trigger Flow, locate the "Execute Workflow" node (e.g., "Execute Workflow \- Create A Topic"). Edit this node and select the imported Main Flow from the dropdown. In the Main Flow, locate all "Execute Workflow" nodes that perform research. Edit these nodes and select the imported Research Tool Sub-Flow from the dropdown. Configure Credentials: In n8n, add credentials for: OpenAI, PerplexityAI, WordPress (using Application Password), Google (ensure Sheets, Drive, Docs permissions). Connect Workflow Nodes: Open all three workflows. Go through each node requiring authentication (OpenAI, Perplexity HTTP Request, WordPress, Google Sheets, Google Drive, Google Docs) and assign the correct credential. Pay close attention to HTTP Request nodes, ensuring API keys are correctly placed. Configure Triggers: In the Trigger Flow, configure the Schedule Trigger interval (default 10 mins) or the n8n Form Trigger fields as needed. Ensure only one trigger is active unless you intend both. Customize Inputs & Parameters: Review key nodes: Trigger Flow: Adjust Wait time if needed. Main Flow: Verify Website URL (for sitemap), AI prompts (Planner, Copywriters), default Category ID, internal link limit, image sizes. Research Tool Sub-Flow: Review default model (sonar), system message, max tokens if needed. Test Connections: Perform test runs on individual nodes within each workflow (e.g., read Google Sheet, call Perplexity via Research Tool Sub-Flow, connect to WordPress) to verify credentials and configurations. Initial Test Run: Add one test topic to your Create Topic sheet (set Status to 'To Do', specify 'Yes' or 'No' for Have Deeper Research). Manually trigger the Trigger Flow once (or wait for the schedule). Verify the process completes and check outputs (WordPress post, Google Drive folder, Google Doc, Final Blogs sheet, Create Topic status update). Activate Workflows: Toggle the "Active" switch ON for the Trigger Flow in your n8n instance. The Sub-Workflows should remain inactive as they are triggered by other flows. Start Automating: Add content topics to the Create Topic sheet (set Status='To Do'), and the scheduled Trigger Flow will pick them up. Tips for Pros Control Research Depth:** Use the Have Deeper Research column ('Yes'/'No') in your Google Sheet to control the level of research per topic, optimizing for cost and complexity where needed. AI Model Selection:** Experiment with different models in the AI/Image nodes. An alternative to OpenAI’s image model is Flux.1, which can yield superior images. For research, test Perplexity's sonar-deep-research model (by passing it as a parameter to the Research Tool Sub-Flow if needed) if the standard sonar isn't deep enough. Wait Times:** Adjust the Trigger Flow's "Wait" node duration based on your API plan limits, the typical runtime of the Main Flow, and desired posting frequency. Prompt Engineering:** Refine the prompts within the Main Flow's AI nodes (Blog Planner, Chapter/Subchapter Copywriters, Image Prompts) and the Research Tool Sub-Flow's system message to fine-tune the output style, tone, structure, and image relevance. Sitemap Accessibility:** Ensure your post-sitemap.xml is publicly accessible and correctly formatted for the parsing node to work reliably for internal linking. Important Considerations API Costs:** Deep research (especially the sub-sub-topic level) and generating multiple high-quality images per post can consume significant API credits. Monitor your costs closely. Use the Have Deeper Research flag wisely. API Rate Limits:** Even with Wait nodes, high volume can hit API rate limits. Be aware of your plan limits (OpenAI, Perplexity) and adjust workflow timing (schedule interval, wait time) accordingly. Sub-Workflow Runtime:** The Main Flow can take a considerable amount of time to run, especially with Deeper Research enabled. Factor this into scheduling and expectations. Tool Dependencies:** The workflow relies heavily on the specific functionalities and APIs of OpenAI, Perplexity, Google Workspace, and WordPress. Changes in these platforms might require workflow adjustments. Initial Setup Complexity:** Due to the advanced features, three-flow structure, and multiple integrations, the initial setup requires careful configuration of credentials, node settings (especially Google Sheets names/columns), and workflow linking. Test thoroughly. For inquiries about this template, please contact AI Automation Pro.

The best content automation template in the market is now even better—with “deep research” on time-sensitive topics\! Unlike most n8n content automation templates that are mainly for “demo purposes,” this advanced n8n workflow is for the real PROs. It conducts in-depth research on the latest information about a topic, then automatically creates and publishes SEO-optimized blog posts to your WordPress website. In addition, it generates a unique image for each chapter and a featured image for the overall article, and it collects internal website links—seamlessly inserting links throughout each chapter and the entire article. Furthermore, it backs up all content and images to a designated folder in your Google Drive. This integrated approach not only creates high-quality, comprehensive content for readers but also enhances on-page SEO, improves navigation, and streamlines your content creation process—saving you time while ensuring your work is securely stored. This is a complimentary variation of the n8n WordPress Auto-Blogging Pro for SEO topics. That one specializes in auto-blogging content about established topics that do not need up-to-date information while this one takes it further by incorporating online research into the workflow. Both make up the perfect combo to run your blog on autopilot\! How It Works Trigger: It activates upon adding a new row to a Google Sheet. Users can control many customizable parameters, such as key topic, number of subtopics, target audience, length, and style. Initial Research: The workflow initiates preliminary research on the topic to gather insights for the content planning phase. Structure Planning: Based on the initial research, it plans a detailed structure for the entire article and breaks the article into subtopics strongly tied to the main topic. In-Depth Research & Writing: For each subtopic, it conducts further research to gather the most up-to-date, relevant information, then uses that research to write each chapter in depth. Image Generation: It generates and adds images for each chapter, as well as a featured image for the article. Internal Linking: The system gathers internal website links and strategically embeds them within each chapter and throughout the article, boosting SEO and enhancing user navigation. Final Assembly & Publishing: All texts, images, and links are combined into one comprehensive article, which is then published directly to your WordPress website. You can also choose to post it as a draft for final review. Auto Backup to Drive: Get peace of mind knowing all content (blog post and images) is automatically saved to Google Drive, organized in a folder named after the blog post title. Unique Features Deep Research: The workflow leverages advanced, real-time research to gather the latest information about a topic. It breaks down the key topic into subtopics and conducts in-depth research on each one, ensuring the most comprehensive and current knowledge. Full Automation: Designed to be 100% automated, the workflow runs without manual intervention once imported and configured. Simple Activation: It is easily triggered through the Google Sheets interface—simply add a new row to a Google Sheet. Customization Options: Offers a wide array of options, including topic, category, target audience, word count, number of chapters, length of introduction and conclusion, and writing style. It also allows for the inclusion of calls-to-action (CTAs) and company/product introductions. Advanced Loop in Loop: Clever looping is used to write each chapter and generate images, ensuring optimal results. “Wait” nodes are added where appropriate to avoid API call rate limits. Automatic Content Saving: After the blog post is created, all content and images are automatically saved to Google Drive, preventing data loss. The folder is named after the blog post title. SEO-Optimized Content: It is designed to create SEO-optimized content using seed keywords. Internal Link Limit: The workflow limits the number of internal links to 20 by default. Error Catch: “If” nodes are strategically used to ensure that the output from AI nodes strictly meets the JSON schema, ensuring a smooth flow of data without interruption. And many more big and small improvements. Requirements Please make sure you have these requirements ready to ensure smooth deployment of this n8n workflow template: OpenAI API or equivalent for text and image generation PerplexityAI API or equivalent for online research A WordPress website (other website platforms will not work\!) Google Sheets for triggering the workflow, or a trigger of your choice Google Drive and Google Docs for auto backup Set Up Steps Install the Workflow Template: Import the JSON files into your n8n instance. There are 2 files: one for the main workflow and one for the research tool (PerplexityAI). Connect the Workflow with Your Accounts: Link your accounts for OpenAI API, PerplexityAI API, Google Drive, Google Sheets, Google Docs, and WordPress website. Configure the Google Sheet: Ensure your Google Sheet is set up to trigger the workflow upon adding a new row and that the input data is correctly formatted. Customize the Inputs: Adjust parameters like topic, target audience, and writing style to match your specific content needs. Optimize prompts for the best results. Test the Workflow: Use low-cost AI models and image settings initially to ensure everything runs smoothly. Tailor Further as Needed: Modify workflow elements to perfectly align with your needs and content strategy. Tips for PROs Image Generation: The default AI model for image generation is OpenAI’s Dall-E. However, the outputs of this model are not impressive. Consider using FLUX.1 for better image quality. Research: PerplexityAI is the tool of choice for research. The default model used in this workflow is “sonar” due to its fast speed and low cost. Feel free to experiment with its other models, including the “sonar-deep-research” model, which is dedicated to deep research. Triggering: Triggering with a new row on Google Sheets is limited and unreliable. Consider setting an auto trigger with a daily schedule at a specific time. You can even put the whole workflow in a loop to process multiple rows one-by-one from Google Sheets. Human in the Loop: It is possible to incorporate a human review process. For example, after the article is posted to WordPress as a draft, a human can review the draft. Only after approval will the post be published, and a final copy of the post will be saved to the shared Drive folder.

The best content automation in the market! This advanced workflow not only creates and publishes SEO-optimized blog posts to your WordPress website but also backs up all content and images to a designated folder in your Google Drive. In addition, It generates a unique image for each chapter and a featured image for the overall article, and it automatically collects internal website links—seamlessly inserting them throughout each chapter and the entire article. This integrated approach enhances on-page SEO, improves navigation, and streamlines your content creation process, saving you time while ensuring your work is securely stored. How it works Triggers upon adding a new row to a Google Sheets. Generates a full blog post by writing content based on customizable parameters such as topic, target audience, length, style, and seed keyword. Generates and adds images for each chapter as well as a featured image for the article. Gathers internal website links and strategically embeds them within each chapter and throughout the article, boosting SEO and enhancing user navigation. Publishes the blog post directly to your WordPress website. Saves all content (blog post and images) to Google Drive, organizing them in a folder named after the blog post title. Unique features Full Automation: The workflow is designed to be 100% automated. Once imported and configured, it can run without manual intervention. Simple Activation: It can be easily triggered through the Google Spreadsheets interface. You simply add a new row to a Google Sheet. Customization Options: Offers a wide array of customization options, including topic, category, target audience, word count, number of chapters, length of introduction and conclusion, and writing style. It also allows for the inclusion of calls-to-action (CTAs) and company/product introductions. Automatic Content Saving: After writing a blog post, all content and images are automatically saved to Google Drive, preventing data loss. The folder is even named after the title of the blog post. SEO-Optimized Content: It's designed to create content optimized for SEO using seed keywords. AI Model Flexibility: It’s super easy to switch between different AI models through the Open Router node. Rate Limit Handling: Includes "Wait" nodes to avoid rate limits. Internal Link Limit: Limits the number of internal links to 20 by default. Set up steps Install the workflow template: Import the JSON file into your n8n instance. Connect the workflow to your accounts: This includes linking your WordPress website, Google Drive, and AI models (such as OpenAI GPT-4o). Configure the Google Sheet: Ensure your Google Sheet is set up to trigger the workflow upon adding a new row and that the input data is correctly formatted. Customize the workflow: Adjust parameters like topic, target audience, and writing style to match your specific content needs. Optimize prompts for best results. Test the workflow: Use low-cost AI models and image settings initially to ensure everything runs smoothly. Tailor Further as Needed: Modify workflow elements to align perfectly with your needs and content strategy.

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. What's new in version 2.1 Version 2.1 introduces several upgrades for efficiency and simplicity: 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. Multi-Language Support: The workflow is now designed to support content creation in multiple languages, allowing you to scale your content strategy globally. 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. 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. 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. 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 Import Workflows: Download and import the two .json files (Trigger Flow and Main Flow). 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. 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). Link Flows: In the Trigger Flow, open the "Execute Workflow" node and select your imported Main Flow from the dropdown menu. Configure Credentials: In n8n, add credentials for OpenAI, Perplexity, WordPress, and Google. 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\. Initial Test Run: Add a test topic to your sheet, manually trigger the workflow, and verify the process completes successfully. 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. 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.

Workflow: Auto-Translate WordPress Posts Using AI Translate Pro This n8n workflow automates the translation of WordPress blog content into any language using the AI Translate Pro API, and inserts the translated text into a Google Doc. 📌 Workflow Steps Manual Trigger Initiates the workflow manually (can be replaced with a webhook or schedule trigger). WordPress Node Retrieves a specific blog post (by ID) from your WordPress site using the REST API. HTTP Request Node Sends the blog content to AI Translate Pro via multipart/form-data. Google Docs Node Appends the translated text into a specified Google Document using Google Docs API. 🌍 API Usage: AI Translate Pro Endpoint: POST https://ai-translate-pro.p.rapidapi.com/translate.php Content-Type: multipart/form-data Required Parameters: | Field | Type | Description | |-----------|--------|-----------------------------------------| | text | string | The text or HTML content to translate | | language| string | Target language (e.g., Hindi, French) | Headers: | Header Name | Value | |---------------------|---------------------------------------| | x-rapidapi-host | ai-translate-pro.p.rapidapi.com | | x-rapidapi-key | Your RapidAPI key | ✅ Benefits of Using AI Translate Pro ⚡ Fast AI-Powered Translation – Instantly translate content with no need for manual input. 🌎 Supports Multiple Languages – Easily switch languages to serve global audiences. 🧠 Context-Aware – More accurate than basic dictionary translation tools. 🛠 Easy Integration with n8n – No-code/low-code implementation. 🗃 Content Reuse – Save translations directly into Google Docs for future use or edits. 💼 Cost-Effective – Efficient alternative to expensive manual translation services. 🛠️ Problems Solved ❌ Manual copy-pasting into Google Translate ❌ Limited or slow in-house translation ❌ Difficulty managing multilingual content ❌ Inconsistent formatting or storage ✅ With AI Translate Pro, translations are fast, automated, and saved where your team can access them instantly. ✅ Example Use Case Translate WordPress blog posts from English to Hindi. Store translated content in Google Docs for editing or reuse. Expand to multilingual sites with a simple language switch. Use AI Translate Pro in any low-code or no-code platform like n8n. 📎 Requirements WordPress REST API credentials RapidAPI access to AI Translate Pro Google Docs API service account 🔗 More Info Explore full documentation and pricing on the AI Translate Pro RapidAPI listing page. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!