n8n Multi-Platform Social Media Publisher with Blotato GPT-4 Mini & Airtable

This n8n workflow automates the process of generating and publishing social media content across multiple platforms using Airtable as a content source and OpenAI (GPT-4 Mini) for content generation. It streamlines your social media management by handling content creation, editing, and scheduling.

Description

This workflow acts as a sophisticated social media content factory. It listens for new content ideas in Airtable, generates enhanced post copy using OpenAI's GPT-4 Mini, allows for manual review and editing via an n8n form, and then publishes the finalized content.

What it does

1. Triggers on Manual Execution or Form Submission: The workflow can be initiated manually or by submitting data through an n8n form.
2. Fetches Content from Airtable: It retrieves social media post ideas and associated data from a specified Airtable base.
3. Generates Social Media Copy with OpenAI (GPT-4 Mini): For each Airtable record, it sends the content idea to OpenAI to generate engaging social media post copy, leveraging the GPT-4 Mini model.
4. Edits and Formats Content: A "Set" node is used to structure and format the data, preparing it for further processing or review.
5. Allows for Human Review and Editing: An n8n Form Trigger is included, suggesting a step where the generated content can be presented for human review, editing, and approval before final publication. (Note: The exact implementation of the form for editing and re-triggering is not fully detailed in the JSON but implied by the presence of the Form Trigger node).
6. Publishes Content (Placeholder): An HTTP Request node is present, indicating a step where the finalized content would be published to various social media platforms via their respective APIs. This node would need to be configured for each desired platform (e.g., Twitter, LinkedIn, Facebook, Instagram, etc.).

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Airtable Account: An Airtable account with a base and table containing your social media content ideas. You will need an Airtable API Key and the Base ID/Table Name.
• OpenAI API Key: An OpenAI account with access to the GPT-4 Mini model (or a similar model if configured differently).
• Social Media Platform Accounts: Accounts on the social media platforms you intend to publish to (e.g., Twitter, LinkedIn, Facebook). You will need API access credentials for each.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON content.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Airtable Node (ID: 2):
     • Click on the "Airtable" node.
     • Select or create a new Airtable credential. You'll need your Airtable API Key.
     • Enter your Base ID and Table Name where your social media content ideas are stored.
   • OpenAI Node (ID: 1250):
     • Click on the "OpenAI" node.
     • Select or create a new OpenAI credential. You'll need your OpenAI API Key.
     • Ensure the model is set to gpt-4-mini or your preferred model.
   • HTTP Request Node (ID: 19):
     • This node is currently a placeholder for publishing. You will need to configure it for each social media platform you want to publish to.
     • For each platform, you'll likely need to:
       • Set the URL to the platform's API endpoint.
       • Set the Method (e.g., POST).
       • Add Headers for authentication (e.g., Bearer Token).
       • Configure the Body with the content from previous nodes (e.g., the generated social media copy).
3. Configure "Edit Fields" (Set) Node (ID: 38):
   • Adjust the fields being set and their values to match your specific data structure and desired output for social media posts.
4. Configure "On form submission" (Form Trigger) Node (ID: 1225):
   • If you intend to use the form for human review, you will need to design the form fields to capture the necessary inputs for editing and approval.
   • You might need additional logic to process the form submission and conditionally proceed with publishing based on approval.
5. Activate the Workflow:
   • Once all credentials and nodes are configured, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.
6. Execute the Workflow:
   • You can manually execute the workflow by clicking "Execute Workflow" on the "Manual Trigger" node.
   • If the "On form submission" node is used as the primary trigger, submit data to its webhook URL to initiate the workflow.

This workflow provides a robust foundation for automating your social media content pipeline, integrating AI-powered content generation with human oversight.