Automated Social Media Content Creation with OpenAI, LinkedIn & X (Twitter) Approval

This n8n workflow automates the generation and publishing of social media content using OpenAI, with a human approval step via Slack or Gmail before posting to LinkedIn and X (formerly Twitter). It streamlines the content creation process, ensuring quality and brand alignment through an integrated approval system.

What it does

This workflow simplifies and accelerates the social media content creation process by:

1. Triggering Content Generation: Initiating the workflow via a manual form submission or by reading existing content from a Google Sheet.
2. Generating Social Media Posts: Utilizing OpenAI to create engaging social media content based on provided input.
3. Parsing AI Output: Structuring the AI-generated content into a usable format.
4. Seeking Human Approval: Sending the generated content to a designated Slack channel or email address for review and approval.
5. Conditional Publishing: Based on the approval status, publishing the content to LinkedIn and/or X (formerly Twitter).

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• OpenAI API Key: For the "OpenAI Chat Model" and "OpenAI" nodes to generate content.
• Google Sheets Account: (Optional) If you plan to trigger the workflow by reading data from a Google Sheet.
• Slack Account: (Optional) If you wish to use Slack for the human approval step.
• Gmail Account: (Optional) If you wish to use Gmail for the human approval step.
• LinkedIn Account: To publish content to LinkedIn.
• X (formerly Twitter) Account: To publish content to X.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • 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:
   • Locate the nodes that require credentials (e.g., "OpenAI Chat Model", "Google Sheets", "Slack", "Gmail", "LinkedIn", "X").
   • Click on each node and then click "Create New Credential" or select an existing one.
   • Follow the prompts to connect your accounts (e.g., enter your OpenAI API Key, authenticate with Google, Slack, LinkedIn, and X).
3. Customize the Workflow:
   • Trigger:
     • If using the n8n Form Trigger: Customize the form fields as needed for your content input.
     • If using Google Sheets: Configure the "Google Sheets" node to read from your desired spreadsheet and sheet.
   • AI Agent / OpenAI Chat Model: Adjust the prompts and settings within these nodes to guide the AI in generating content specific to your needs.
   • Structured Output Parser: Ensure the parser is correctly configured to extract the desired fields from the AI's output.
   • Approval (Slack/Gmail):
     • Configure the "Slack" or "Gmail" node to send approval requests to the correct channel/email address.
     • Customize the message content for the approval request.
   • If Node: Review the conditions in the "If" node to ensure it correctly evaluates the approval status.
   • LinkedIn / X (Twitter): Customize the message format and any additional parameters for posting to these platforms.
4. Activate the Workflow:
   • Once configured, save the workflow and activate it by toggling the "Active" switch in the top right corner of the workflow editor.

Now, when the workflow is triggered (either by form submission or Google Sheet update), it will generate social media content, await your approval, and then publish it to the selected platforms.