The ULTIMATE AI Social Media Automation System (NO CODE!)

Key Concepts

• N8N Workflow: An automation platform used to connect different services and automate tasks.
• Blotato API: A service that allows posting to multiple social media accounts through a single API.
• HTTP Request Node: A node in N8N used to make API calls.
• JSON (JavaScript Object Notation): A lightweight data-interchange format used for transmitting data in API requests.
• API Key: A code used to authenticate and authorize access to an API.
• Account ID: A unique identifier for a social media account within the Blotato platform.
• Google Sheets Integration: Using Google Sheets to manage media content and status for posting.

Step-by-Step Guide to Posting to Multiple Social Media Accounts Using Blotato API and N8N

1. Setting up the N8N Workflow

• Trigger: Start with a manual trigger in N8N for testing purposes. This can be changed to a scheduled trigger or other automated triggers later.
• Google Sheets Integration:
  • Use the "Google Sheets" node to "Get Rows" from a Google Sheet containing media information (title, video link, status).
  • Configure credentials to access the Google Sheet.
  • Filter rows based on a "status" column (e.g., "ready to post") to select media for posting.
  • Limit the results to the first matching row to process one item at a time.
• Set Node:
  • Add a "Set" node to store social media account IDs.
  • Use JSON format to define key-value pairs for each social media platform (e.g., Instagram: "account_id", YouTube: "account_id").
  • Obtain account IDs from the Blotato settings page after connecting social media accounts.

2. Uploading Media to Blotato

• HTTP Request Node (Media Upload):
  • Add an "HTTP Request" node to upload media to Blotato's backend.
  • Set the method to "POST" and the URL to https://backend.blotato.com/v2/media.
  • Add a header with the name blot-api-key and the value as your Blotato API key (found in Blotato settings).
  • Set the request body to "Send Body" with the name "URL" and the value as the video link from the Google Sheets node.
  • Test the step to ensure the media is successfully uploaded to Blotato. The response should include a URL to the uploaded media.

3. Posting to Social Media Accounts

• HTTP Request Node (Social Media Post):
  • Add an "HTTP Request" node for each social media account you want to post to.
  • Set the method to "POST" and the URL to https://backend.blotato.com/v2/post.
  • Add the same header as before (blot-api-key with your Blotato API key).
  • Set the request body to "Using JSON" and provide the appropriate JSON payload for each social media platform.
  • The JSON payload should include:
    • target: The social media platform (e.g., "instagram").
    • content:
      • text: The title or description of the post (from Google Sheets).
      • platform: The social media platform.
      • media_url: The URL of the uploaded media from the Blotato media upload node.
    • account_id: The account ID for the specific social media platform (from the "Set" node).
  • Test each step to ensure the post is successfully submitted to each social media account. The response should include a "post submission ID".

4. JSON Payloads for Different Platforms

• Instagram:

  {
    "target": "instagram",
    "content": {
      "text": "{{$node[\"Google Sheets\"].json[\"title\"]}}",
      "platform": "instagram",
      "media_url": "{{$node[\"Media Upload\"].json[\"url\"]}}"
    },
    "account_id": "{{$node[\"Set Social Media Account ID\"].json[\"Instagram\"]}}"
  }
  

• LinkedIn:

  {
    "target": "linkedin",
    "content": {
      "text": "{{$node[\"Google Sheets\"].json[\"title\"]}}",
      "platform": "linkedin",
      "media_url": "{{$node[\"Media Upload\"].json[\"url\"]}}"
    },
    "account_id": "{{$node[\"Set Social Media Account ID\"].json[\"LinkedIn\"]}}"
  }
  

• TikTok:

  {
    "target": {
      "type": "tiktok",
      "privacy_level": "public",
      "is_brand_content": false,
      "is_ai_generated": true
    },
    "content": {
      "text": "{{$node[\"Google Sheets\"].json[\"title\"]}}",
      "platform": "tiktok",
      "media_url": "{{$node[\"Media Upload\"].json[\"url\"]}}"
    },
    "account_id": "{{$node[\"Set Social Media Account ID\"].json[\"TikTok\"]}}"
  }
  

• Facebook & Pinterest: Require additional parameters like page_id (Facebook) and board_id (Pinterest).

5. Automation and Execution

• Once all nodes are configured and tested, you can run the entire workflow by clicking "Test Workflow".
• This will automatically retrieve media information from Google Sheets, upload the media to Blotato, and post it to all configured social media accounts.
• The workflow can be scheduled to run automatically at specific intervals.

Notable Quotes

• "This is this really cool API where you can just use this one API the Blot API where you can post to all different nine social media accounts."
• "The great thing is you only have to do this once so once you have your account connected and we'll set up our automation then you're completely done right you don't have to do this again."
• "If you have everything set up and you want to have the same media that you want to upload to all of these accounts the only thing you have to do is just click on test workflow then it will post everything if you did everything correctly on all of your accounts at the same time and that's why I said this is kind of a one-click installation oneclick automation right."

Technical Terms and Concepts

• API (Application Programming Interface): A set of rules and specifications that software programs can follow to communicate with each other.
• Node: A building block in N8N workflows that performs a specific task.
• Credential: Securely stored authentication information (e.g., API keys, OAuth tokens) used to access external services.
• JSON Schema: A formal description of the structure and data types of a JSON document.
• Endpoint: A specific URL that an API exposes for accessing a particular resource or functionality.

Logical Connections

The workflow is structured to flow logically from data source (Google Sheets) to media processing (Blotato upload) to social media posting. The "Set" node acts as a central repository for account IDs, allowing them to be easily referenced in subsequent nodes. The use of JSON payloads ensures that the data is formatted correctly for each social media platform's API.

Synthesis/Conclusion

The video provides a detailed, step-by-step guide to automating social media posting using N8N and the Blotato API. By integrating Google Sheets for content management and leveraging Blotato's multi-platform posting capabilities, users can efficiently schedule and distribute media across multiple social media accounts with minimal manual effort. The use of JSON payloads and account IDs ensures that the data is formatted correctly for each platform, while the N8N workflow provides a flexible and customizable automation solution.