n8n Workflow: Automated SEO Blog Content Generation and WordPress Publishing

This n8n workflow automates the process of generating SEO-optimized blog content using AI and publishing it directly to WordPress. It streamlines content creation by leveraging Google Sheets for input, OpenAI for content generation, and Perplexity for research, significantly reducing manual effort and speeding up your content pipeline.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated by a manual trigger, allowing you to control when the content generation process begins.
2. Reads Input from Google Sheets: It fetches blog post ideas or topics from a specified Google Sheet. Each row in the sheet is treated as a separate content request.
3. Prepares Data: A "Set" node (named "Edit Fields") is used to prepare and format the data from Google Sheets for subsequent AI processing. This might involve selecting specific columns or renaming fields.
4. Generates Blog Content with OpenAI: For each input item, it uses the OpenAI node to generate blog post content. This likely involves prompts for titles, outlines, introductions, body paragraphs, and conclusions.
5. Enhances Content with Perplexity (Research): The Perplexity node is used to perform additional research or gather information related to the generated content, potentially to enrich the blog post with facts, statistics, or external references.
6. Publishes to WordPress: Finally, the generated and enhanced content is automatically published as a new post on a configured WordPress site.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Google Sheets Account: A Google Sheets spreadsheet containing your blog post ideas/topics.
• OpenAI API Key: An API key for OpenAI to generate content.
• Perplexity API Key: An API key for Perplexity for research and content enhancement.
• WordPress Site: Access to a WordPress site with appropriate user credentials for publishing posts.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential. You'll need to authenticate with your Google account and grant n8n access to your spreadsheets.
   • OpenAI: Set up an OpenAI credential using your API key.
   • Perplexity: Set up a Perplexity credential using your API key.
   • WordPress: Set up a WordPress credential. This typically involves your WordPress site URL, username, and application password.
3. Customize Nodes:
   • Google Sheets (Node ID: 18): Configure this node to point to your specific Google Sheet and the relevant sheet name where your blog post topics are listed.
   • Edit Fields (Set - Node ID: 38): Adjust the fields being set or transformed to match the structure of your Google Sheet and the expected input for the AI nodes.
   • OpenAI (Node ID: 1250): Customize the prompts used to generate blog content. You might want to specify the desired length, tone, keywords, and sections for the blog posts.
   • Perplexity (Node ID: 1304): Configure the search queries for Perplexity to ensure it fetches relevant information for your blog topics.
   • WordPress (Node ID: 118): Configure the post type (e.g., "Post"), status (e.g., "Publish"), and map the generated content (title, body, etc.) from the previous nodes to the corresponding WordPress fields.
4. Execute the Workflow:
   • Once configured, click "Execute Workflow" on the "Manual Trigger" node to run the workflow. It will process items from your Google Sheet sequentially.

This workflow provides a powerful foundation for automating your blog content strategy, allowing you to scale your content production efficiently.