Automatisierte Veröffentlichung von Inhalten auf TikTok, YouTube, Instagram, Facebook mit Blotato vide-ok

• •Google Sheets API-Anmeldedaten

{
  "id": "DmyJBaePJ8M25f40",
  "meta": {
    "instanceId": "a2b23892dd6989fda7c1209b381f5850373a7d2b85609624d7c2b7a092671d44",
    "templateCredsSetupCompleted": true
  },
  "name": "💥 Automate Content Publishing to TikTok, YouTube, Instagram, Facebook via Blotato vide-ok",
  "tags": [],
  "nodes": [
    {
      "id": "ab387c03-9d70-43d0-b627-c4a3e74091bc",
      "name": "Get Google Drive ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -500,
        1160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a1750d20-2f6e-4826-80b8-654d0985120d",
              "name": "final_google_drive_url",
              "type": "string",
              "value": "={{ $('URL VIDEO to Post').item.json['URL GOOGLE DRIVE'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "9499bb9a-9127-4c78-b9e9-0fdd5f9b7322",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1000,
        340
      ],
      "parameters": {
        "color": 6,
        "width": 508,
        "height": 576,
        "content": "# The ULTIMATE Agent to Auto-Publish Content Hourly  \n### **Post to 9 social platforms with Blotato + Google Sheets + n8n**\n[![Watch the full tutorial on YouTube](https://img.youtube.com/vi/33opLrLAs3g/maxresdefault.jpg)](https://youtu.be/33opLrLAs3g)\n## 📌 Tutorial Youtube : [Youtube](https://www.blotato.com) \n## 📌 Documentation : [Notion](https://automatisation.notion.site/Blotato-2473d6550fd980e19983f69611a80a0d?source=copy_link) \n\n-"
      },
      "typeVersion": 1
    },
    {
      "id": "fa4b8e2f-5063-44e7-9e9a-5ea0a63490e4",
      "name": "Notiz 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        340
      ],
      "parameters": {
        "color": 4,
        "width": 592,
        "height": 992,
        "content": "## 📢 Auto-Post to All Platforms\n\n> ## **Important Reminder**  \n#### Avoid uploading the same image or video repeatedly — doing so can trigger spam filters on social platforms.  \n### Also, if you're using AI-generated avatars or content, make sure to **disclose it clearly** when required by the platform.\n---\n\n### 📚 Useful Resources\n\n- 📘 [Blotato API Documentation](https://help.blotato.com/api)  \n- 🧰 [API Dashboard for Troubleshooting](https://my.blotato.com/api-dashboard)  \n- 📷 [Media Format & Size Requirements](https://help.blotato.com/api/media)  \n"
      },
      "typeVersion": 1
    },
    {
      "id": "c5d76e40-7ef4-4032-828b-88033f4dae74",
      "name": "Check Every 1 Hours",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -940,
        1160
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0b91ff90-a758-44d3-9c3d-61618d6afef0",
      "name": "URL VIDEO to Post",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -720,
        1160
      ],
      "parameters": {
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "="
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "51us92xkOlrvArhV",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "fabedc11-5501-4bc9-ba0f-e9ce6961f892",
      "name": "Upload Video to BLOTATO",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        -260,
        1160
      ],
      "parameters": {
        "mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}",
        "resource": "media"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "67b945ab-d159-4842-80c5-3d790848e8ec",
      "name": "Youtube",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        440,
        940
      ],
      "parameters": {
        "options": {
          "scheduledTime": "2025-08-09T08:00:00"
        },
        "platform": "youtube",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "8047",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/8047",
          "cachedResultName": "DR FIRASS (Dr. Firas)"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}",
        "postCreateYoutubeOptionTitle": "={{ $('URL VIDEO to Post').item.json.Title }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "d58660c1-8a15-4e9f-b548-5a1b9e69138f",
      "name": "Tiktok",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        80,
        760
      ],
      "parameters": {
        "options": {},
        "platform": "tiktok",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "9332",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/9332",
          "cachedResultName": "docteur.firas"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "a21d443d-029f-4267-af7c-471fd4c52709",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        820,
        540
      ],
      "parameters": {
        "numberInputs": 9
      },
      "typeVersion": 3.2
    },
    {
      "id": "559749a1-9979-4405-b533-30c719f71086",
      "name": "Update Status to \"DONE\"",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1000,
        660
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "DONE",
            "Caption": "={{ $('URL VIDEO to Post').item.json.Caption }}"
          },
          "schema": [
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL GOOGLE DRIVE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "URL GOOGLE DRIVE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Caption",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Caption",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Caption"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "="
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "="
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "51us92xkOlrvArhV",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "de240308-b7d1-4a0f-b6e2-fe9c0de8c944",
      "name": "Notiz 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        340
      ],
      "parameters": {
        "color": 6,
        "width": 448,
        "height": 576,
        "content": "## ⚙️ Requirements\n\n## 🧰 Setup Instructions — What You Need Before You Start\n\n1. ✅ **Create a [Blotato](https://blotato.com/?ref=firas) account** (Pro plan required for API access)  \n2. 🔑 **Generate your Blotato API Key** via: `Settings > API > Generate API Key`  \n3. 📦 **Enable “Verified Community Nodes”** in the n8n admin settings  \n4. 🧩 **Install the Blotato** verified community node in n8n  \n5. 🛠 **Create a Blotato API credential** inside your n8n credentials tab  \n6. 📄 **Duplicate this [Google Sheet template](https://docs.google.com/spreadsheets/d/1kKGEgdZCLxnILMiOph_YU95-rB8XZsQFz9XJ3gLZvas/edit?usp=sharing)**  \n7. ☁️ **Make sure your Google Drive folder is PUBLIC** (anyone with the link can access)  \n8. 📌 **Complete the 3 brown sticky note steps** inside the workflow editor\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9402b28e-a221-40c6-a0d6-a3ff15d772a5",
      "name": "Linkedin",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        260,
        760
      ],
      "parameters": {
        "options": {},
        "platform": "linkedin",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "1446",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/1446",
          "cachedResultName": "Samuel Amalric"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "3923843d-d75d-4242-a8cb-0223f1a2e9dd",
      "name": "Facebook",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        440,
        760
      ],
      "parameters": {
        "options": {},
        "platform": "facebook",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "1759",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/1759",
          "cachedResultName": "Firass Ben"
        },
        "facebookPageId": {
          "__rl": true,
          "mode": "list",
          "value": "101603614680195",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/1759/subaccounts/101603614680195",
          "cachedResultName": "Dr. Firas"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "28bc3d39-e17b-477f-9f24-4878e5b7edb5",
      "name": "Instagram",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        80,
        940
      ],
      "parameters": {
        "options": {},
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "7341",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/7341",
          "cachedResultName": "doc.firass"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "6f2a9012-e643-4d0a-80a8-7db2de047211",
      "name": "Threads",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        80,
        1140
      ],
      "parameters": {
        "options": {},
        "platform": "threads",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "2280",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/2280",
          "cachedResultName": "doc.firass"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "1a87aee5-10b6-4f42-a75f-8a7cd916b5f4",
      "name": "Bluesky",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        260,
        1140
      ],
      "parameters": {
        "options": {},
        "platform": "bluesky",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "6012",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/6012",
          "cachedResultName": "formationinternet.bsky.social"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "34e0eff3-77e7-4d33-b666-6a79173691a7",
      "name": "Pinterest",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        440,
        1140
      ],
      "parameters": {
        "options": {},
        "platform": "pinterest",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "363",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/363",
          "cachedResultName": "formationinternet2022"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "pinterestBoardId": {
          "__rl": true,
          "mode": "id",
          "value": "1146"
        },
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "55ee0a7e-1be0-4fb2-8814-3cc2ff60d396",
      "name": "Twitter (X)",
      "type": "@blotato/n8n-nodes-blotato.blotato",
      "position": [
        260,
        940
      ],
      "parameters": {
        "options": {},
        "platform": "twitter",
        "accountId": {
          "__rl": true,
          "mode": "list",
          "value": "1289",
          "cachedResultUrl": "https://backend.blotato.com/v2/accounts/1289",
          "cachedResultName": "Docteur_Firas"
        },
        "postContentText": "={{ $('URL VIDEO to Post').item.json.Caption }}",
        "postContentMediaUrls": "={{ $json.url }}"
      },
      "credentials": {
        "blotatoApi": {
          "id": "NtMnRSKAAN5u9lyc",
          "name": "Blotato account"
        }
      },
      "typeVersion": 2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1f2005a7-245a-4039-9281-d4969619fd4d",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "559749a1-9979-4405-b533-30c719f71086",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d58660c1-8a15-4e9f-b548-5a1b9e69138f": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1a87aee5-10b6-4f42-a75f-8a7cd916b5f4": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 7
          }
        ]
      ]
    },
    "6f2a9012-e643-4d0a-80a8-7db2de047211": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "67b945ab-d159-4842-80c5-3d790848e8ec": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "3923843d-d75d-4242-a8cb-0223f1a2e9dd": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "9402b28e-a221-40c6-a0d6-a3ff15d772a5": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "28bc3d39-e17b-477f-9f24-4878e5b7edb5": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "34e0eff3-77e7-4d33-b666-6a79173691a7": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 8
          }
        ]
      ]
    },
    "55ee0a7e-1be0-4fb2-8814-3cc2ff60d396": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "0b91ff90-a758-44d3-9c3d-61618d6afef0": {
      "main": [
        [
          {
            "node": "ab387c03-9d70-43d0-b627-c4a3e74091bc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c5d76e40-7ef4-4032-828b-88033f4dae74": {
      "main": [
        [
          {
            "node": "0b91ff90-a758-44d3-9c3d-61618d6afef0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab387c03-9d70-43d0-b627-c4a3e74091bc": {
      "main": [
        [
          {
            "node": "fabedc11-5501-4bc9-ba0f-e9ce6961f892",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fabedc11-5501-4bc9-ba0f-e9ce6961f892": {
      "main": [
        [
          {
            "node": "d58660c1-8a15-4e9f-b548-5a1b9e69138f",
            "type": "main",
            "index": 0
          },
          {
            "node": "9402b28e-a221-40c6-a0d6-a3ff15d772a5",
            "type": "main",
            "index": 0
          },
          {
            "node": "3923843d-d75d-4242-a8cb-0223f1a2e9dd",
            "type": "main",
            "index": 0
          },
          {
            "node": "28bc3d39-e17b-477f-9f24-4878e5b7edb5",
            "type": "main",
            "index": 0
          },
          {
            "node": "55ee0a7e-1be0-4fb2-8814-3cc2ff60d396",
            "type": "main",
            "index": 0
          },
          {
            "node": "67b945ab-d159-4842-80c5-3d790848e8ec",
            "type": "main",
            "index": 0
          },
          {
            "node": "6f2a9012-e643-4d0a-80a8-7db2de047211",
            "type": "main",
            "index": 0
          },
          {
            "node": "1a87aee5-10b6-4f42-a75f-8a7cd916b5f4",
            "type": "main",
            "index": 0
          },
          {
            "node": "34e0eff3-77e7-4d33-b666-6a79173691a7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}