Ultimate Content Generator for WordPress

This n8n workflow automates the process of generating and publishing content to WordPress, leveraging AI for content creation and Airtable for content management. It allows for a streamlined content pipeline, from idea to publication, with human oversight.

What it does

This workflow automates the following steps:

1. Monitors Airtable for new content requests: It triggers when a new record is created or updated in a specified Airtable base and table, specifically looking for content marked as "Ready to Generate".
2. Generates content using OpenAI: For each "Ready to Generate" item, it uses OpenAI to generate content based on the provided topic and keywords.
3. Enriches content with Wikipedia (optional): If the OpenAI generation is insufficient or needs more factual depth, it can use a Wikipedia tool to fetch additional information.
4. Performs HTTP Requests (optional): It includes an HTTP Request tool, likely for fetching data from other APIs or services to further enrich the content.
5. Processes and structures content: The generated content is then processed and structured using a Code node and a Set node to ensure it's in the correct format for WordPress.
6. Splits content into batches: The content is split into manageable batches for further processing or review.
7. Sends content for human review via Slack: The generated content is posted to a designated Slack channel for review and approval.
8. Waits for human approval: The workflow pauses, awaiting a response from the Slack channel to determine if the content is approved for publishing or needs revisions.
9. Updates Airtable with content status: Based on the approval, it updates the Airtable record with the content's new status (e.g., "Approved," "Rejected," "Published").
10. Publishes to WordPress: If approved, the content is automatically published as a new post on WordPress.
11. Responds to Webhook (if triggered by a form): If the workflow is initiated by a form submission, it can respond back to the webhook.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Airtable Account: A base and table configured to manage your content ideas and their status.
• OpenAI API Key: For generating content using AI.
• WordPress Account: Access to a WordPress site for publishing posts.
• Slack Account: A Slack workspace and channel for content review and approval.

Setup/Usage

1. Import the workflow: Download the JSON provided and import it into your n8n instance.
2. Configure Credentials:
   • Airtable: Set up your Airtable credentials, specifying the Base ID and Table Name where your content ideas are stored.
   • OpenAI: Provide your OpenAI API Key.
   • WordPress: Configure your WordPress credentials (e.g., API Key or username/password).
   • Slack: Set up your Slack credentials and specify the channel for notifications.
3. Review Node Configurations:
   • Airtable Trigger: Ensure it's configured to monitor the correct base, table, and view for new content marked "Ready to Generate."
   • OpenAI Node: Adjust the prompt and model parameters to suit your content generation needs.
   • Wikipedia / HTTP Request Tools: Configure these if you intend to use them for content enrichment.
   • Code / Set Nodes: Review and modify the JavaScript code and field settings as needed to format your content for WordPress.
   • Slack Node: Customize the message sent to Slack for content review.
   • WordPress Node: Configure the post type, status, and mapping of content fields to WordPress post fields (e.g., title, content, categories).
4. Activate the Workflow: Once all credentials and configurations are set, activate the workflow.

The workflow will now automatically generate and manage your WordPress content based on updates in Airtable, with a human-in-the-loop approval step via Slack.