💥 Automatische Erzeugung von Social-Media-Videos mit GPT-5 und Veröffentlichung mit Blotato - Video
Experte
Dies ist ein Social Media, Multimodal AI-Bereich Automatisierungsworkflow mit 31 Nodes. Hauptsächlich werden Set, Merge, Telegram, GoogleDrive, GoogleSheets und andere Nodes verwendet. Automatisierte Erstellung von Social-Media-Videos mit GPT-5 und Veröffentlichung mit Blotato
Voraussetzungen
- •Telegram Bot Token
- •Google Drive API-Anmeldedaten
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (31)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "4H8VzyaoTpFXg9Nj",
"meta": {
"instanceId": "a2b23892dd6989fda7c1209b381f5850373a7d2b85609624d7c2b7a092671d44",
"templateCredsSetupCompleted": true
},
"name": "💥 Auto-Generate Social Media Videos with GPT-5 and Publish via Blotato - vide",
"tags": [],
"nodes": [
{
"id": "768ae3b3-0e54-475f-a856-9fb125f7bc58",
"name": "Video auf BLOTATO hochladen",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-2000,
560
],
"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": "8abd8f46-83d7-45b9-a725-770a5391310a",
"name": "Youtube",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1040,
440
],
"parameters": {
"options": {},
"platform": "youtube",
"accountId": {
"__rl": true,
"mode": "list",
"value": "8047",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/8047",
"cachedResultName": "DR FIRASS (Dr. Firas)"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}",
"postCreateYoutubeOptionTitle": "={{ $('Google Sheets - Read Post Data').item.json.Title }}",
"postCreateYoutubeOptionPrivacyStatus": "private",
"postCreateYoutubeOptionShouldNotifySubscribers": false
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "bcf70961-a973-4695-9606-886ffff44adf",
"name": "Tiktok",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1620,
260
],
"parameters": {
"options": {},
"platform": "tiktok",
"accountId": {
"__rl": true,
"mode": "list",
"value": "9332",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/9332",
"cachedResultName": "docteur.firas"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"name": "Zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
-660,
340
],
"parameters": {
"numberInputs": 9
},
"typeVersion": 3.2
},
{
"id": "28dda1ac-17b0-422a-90c3-d2443dcf065f",
"name": "Linkedin",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1340,
260
],
"parameters": {
"options": {},
"platform": "linkedin",
"accountId": {
"__rl": true,
"mode": "list",
"value": "1446",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/1446",
"cachedResultName": "Samuel Amalric"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "9ad659bc-9ca7-40fc-9da7-1c025ceed23d",
"name": "Facebook",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1040,
260
],
"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": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "e77f84c3-4ded-425a-b8b1-c160f5bf75f2",
"name": "Instagram",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1620,
440
],
"parameters": {
"options": {
"instagramMediaType": "reel"
},
"accountId": {
"__rl": true,
"mode": "list",
"value": "7341",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/7341",
"cachedResultName": "doc.firass"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "68ef8511-885f-4b6a-bbdb-35172b6cee84",
"name": "Threads",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1620,
640
],
"parameters": {
"options": {},
"platform": "threads",
"accountId": {
"__rl": true,
"mode": "list",
"value": "2280",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/2280",
"cachedResultName": "doc.firass"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "510db975-9dbd-4097-a441-34d9472b8bd4",
"name": "Bluesky",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1340,
640
],
"parameters": {
"options": {},
"platform": "bluesky",
"accountId": {
"__rl": true,
"mode": "list",
"value": "6012",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/6012",
"cachedResultName": "formationinternet.bsky.social"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "b651f6fa-5130-4ebf-b33a-4b8339726bea",
"name": "Pinterest",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1040,
640
],
"parameters": {
"options": {},
"platform": "pinterest",
"accountId": {
"__rl": true,
"mode": "list",
"value": "363",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/363",
"cachedResultName": "formationinternet2022"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"pinterestBoardId": {
"__rl": true,
"mode": "id",
"value": "1146658823815436667"
},
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "8c53c394-7c0b-4bc9-ae34-264f19f31c0a",
"name": "Twitter (X)",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-1340,
440
],
"parameters": {
"options": {},
"platform": "twitter",
"accountId": {
"__rl": true,
"mode": "list",
"value": "1289",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/1289",
"cachedResultName": "Docteur_Firas"
},
"postContentText": "={{ $('Google Sheets - Read Post Data').item.json.Caption }}",
"postContentMediaUrls": "={{ $json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "NtMnRSKAAN5u9lyc",
"name": "Blotato account"
}
},
"typeVersion": 2
},
{
"id": "66631674-f38b-4156-8cd0-d25d26627f43",
"name": "Notiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
-620
],
"parameters": {
"width": 1960,
"height": 660,
"content": "# 🧠 Step 1 — Generate Title & Caption from a Video"
},
"typeVersion": 1
},
{
"id": "f8fb8bb2-f5fa-4014-af80-1e81389566c4",
"name": "Notiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
100
],
"parameters": {
"width": 1960,
"height": 760,
"content": "# 🚀 Step 2 — Auto-Publish to 9 Social Platforms"
},
"typeVersion": 1
},
{
"id": "1db9406d-a683-4241-98da-887cedebe925",
"name": "Google Drive-ID abrufen",
"type": "n8n-nodes-base.set",
"position": [
-1820,
280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a1750d20-2f6e-4826-80b8-654d0985120d",
"name": "final_google_drive_url",
"type": "string",
"value": "={{ $json['URL GOOGLE DRIVE'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9d58d8dd-3d83-4455-a82f-af86435266be",
"name": "Telegram - Videoidee empfangen",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-2020,
-380
],
"webhookId": "16624061-74c8-4f16-aae3-5fa49db0be0a",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "KjI1uSohs9LZVUF0",
"name": "Telegram account 8"
}
},
"typeVersion": 1.2
},
{
"id": "65165699-7361-40c8-8272-0de344734b2f",
"name": "Google Sheets - Zeile erstellen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1800,
-380
],
"parameters": {
"columns": {
"value": {
"NAME FILE": "={{ $json.message.video.file_name }}"
},
"schema": [
{
"id": "NAME FILE",
"type": "string",
"display": true,
"required": false,
"displayName": "NAME FILE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"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": "ID URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcription",
"type": "string",
"display": true,
"required": false,
"displayName": "Transcription",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "51us92xkOlrvArhV",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "753e1949-56b1-43a8-93c8-7f48867179fa",
"name": "Telegram - Video herunterladen",
"type": "n8n-nodes-base.telegram",
"position": [
-1580,
-380
],
"webhookId": "ca9facc4-fd23-4772-9ab8-4ebed7b7bf1e",
"parameters": {
"fileId": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_id }}",
"resource": "file"
},
"credentials": {
"telegramApi": {
"id": "KjI1uSohs9LZVUF0",
"name": "Telegram account 8"
}
},
"typeVersion": 1.2
},
{
"id": "89b0c98a-84c2-4808-8f8f-db69e8b21bcb",
"name": "Google Drive - Video hochladen",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1320,
-280
],
"parameters": {
"name": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_name }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1jSkENv2t7O6CMaSomvqQcgHmtaoPbxqb",
"cachedResultUrl": "https://drive.google.com/drive/folders/1jSkENv2t7O6CMaSomvqQcgHmtaoPbxqb",
"cachedResultName": "Cours Udemy Blotato V2"
},
"inputDataFieldName": "=data"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "gzeHMd64HAz6HBIe",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "71e2b9cb-9d75-4b68-924c-87ea7ffd7ff4",
"name": "OpenAI - Video in Text transkribieren",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1320,
-500
],
"parameters": {
"options": {
"language": "fr",
"temperature": 0
},
"resource": "audio",
"operation": "transcribe"
},
"credentials": {
"openAiApi": {
"id": "6h3DfVhNPw9I25nO",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "dfbb598e-413e-4a3b-bcb9-dd185fe501eb",
"name": "Google Sheets - Videoinfo speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1060,
-280
],
"parameters": {
"columns": {
"value": {
"NAME FILE": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_name }}",
"URL GOOGLE DRIVE": "={{ $('Google Drive - Upload Video').item.json.webViewLink }}",
"ID URL GOOGLE DRIVE": "={{ $('Google Drive - Upload Video').item.json.id }}"
},
"schema": [
{
"id": "NAME FILE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NAME FILE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": 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": "ID URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcription",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Transcription",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"NAME FILE"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zrfxthPoUhbf1Ae3cKsDrJKw-Stri7uM-d3-eO9CgA4/edit#gid=0",
"cachedResultName": "URL"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1zrfxthPoUhbf1Ae3cKsDrJKw-Stri7uM-d3-eO9CgA4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zrfxthPoUhbf1Ae3cKsDrJKw-Stri7uM-d3-eO9CgA4/edit?usp=drivesdk",
"cachedResultName": "url_Videos_AUTOPUBLICATION"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "51us92xkOlrvArhV",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "210413ab-7b4f-43c6-ac17-d6364baf4c2e",
"name": "Google Sheets - Transkript speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1060,
-500
],
"parameters": {
"columns": {
"value": {
"NAME FILE": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_name }}",
"Transcription": "={{ $json.text }}"
},
"schema": [
{
"id": "NAME FILE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NAME FILE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ID URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcription",
"type": "string",
"display": true,
"required": false,
"displayName": "Transcription",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"NAME FILE"
],
"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.6
},
{
"id": "1839a4ba-8654-4732-8449-372d98a3cf20",
"name": "Zusammenführen - Video + Transkript verbinden",
"type": "n8n-nodes-base.merge",
"position": [
-820,
-380
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3.2
},
{
"id": "d7ee48ca-6b7c-4dbe-ba93-78fdf75cf36c",
"name": "Google Sheets - Daten für KI auslesen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-640,
-380
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_name }}",
"lookupColumn": "NAME FILE"
}
]
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "51us92xkOlrvArhV",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "b16d45e1-04ac-483c-be42-6dab8e9dcb70",
"name": "KI-Agent - Titel & Beschreibung generieren",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-480,
-380
],
"parameters": {
"text": "={{ $json.Transcription }}",
"options": {
"systemMessage": "=You will create a concise Title and a short Caption using ONLY the TRANSCRIPTION below. Do not invent new content. Detect the language from the TRANSCRIPTION and write in that same language. No emojis. No hashtags.\n\nRULES\n- Title: clear, compelling, faithful to the content. Aim ≤ 70 characters. No clickbait. No emojis/hashtags.\n- Caption: ≤ 200 characters (characters, not words). Crisp, adds context or a takeaway. No emojis/hashtags.\n- Keep facts aligned with the TRANSCRIPTION. No external info.\n- Output JSON only on a single line. No markdown, no explanations.\n\nFINAL OUTPUT (single line JSON):\n{\"title\":\"<TITLE>\", \"caption\":\"<CAPTION>\"}\n\nTRANSCRIPTION:\n{{ $json.Transcription }}\n\nUse the Google Sheets tool to save the generated title and caption for this video.\n\n\n\n"
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "74e5b89f-9dcb-4b7d-8c20-d631d43242dd",
"name": "OpenAI Modell GPT-5",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-620,
-120
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-5",
"cachedResultName": "gpt-5"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "6h3DfVhNPw9I25nO",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "e7640b66-aaff-4dfa-9366-383ef2508d11",
"name": "LangChain - Denk-Tool",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
-440,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "da5fbfd8-985e-4ddc-ba23-598c5191ca2b",
"name": "Google Sheets - Titel & Beschreibung aktualisieren",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
-260,
-120
],
"parameters": {
"columns": {
"value": {
"Title": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Title', ``, 'string') }}",
"Caption": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Caption', ``, 'string') }}",
"NAME FILE": "={{ $json['NAME FILE'] }}"
},
"schema": [
{
"id": "NAME FILE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NAME FILE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ID URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcription",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Transcription",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"NAME FILE"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "51us92xkOlrvArhV",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "184abcde-a529-4fac-ac84-0b60db7d9d05",
"name": "Google Sheets - Beitragsdaten auslesen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2020,
280
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $('Telegram - Receive Video Idea').item.json.message.video.file_name }}",
"lookupColumn": "NAME FILE"
}
]
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "51us92xkOlrvArhV",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "fde2606f-c15a-429f-9a38-5bf5115691f0",
"name": "Google Sheets - Status aktualisieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
-360,
360
],
"parameters": {
"columns": {
"value": {
"Status": "DONE",
"ID URL GOOGLE DRIVE": "={{ $('Get Google Drive ID').item.json.final_google_drive_url }}"
},
"schema": [
{
"id": "NAME FILE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "NAME FILE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ID URL GOOGLE DRIVE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID URL GOOGLE DRIVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcription",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Transcription",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ID URL GOOGLE DRIVE"
],
"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": "b8f79262-7418-4206-8666-a0e9e51a4cd1",
"name": "Telegram - Beitragsfertigstellung benachrichtigen",
"type": "n8n-nodes-base.telegram",
"position": [
-360,
580
],
"webhookId": "0794ffb5-68c7-466e-ad69-f36922a2df31",
"parameters": {
"text": "POST DONE",
"chatId": "={{ $('Telegram - Receive Video Idea').item.json.message.chat.id }}",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "KjI1uSohs9LZVUF0",
"name": "Telegram account 8"
}
},
"typeVersion": 1.2
},
{
"id": "2753beb0-2166-44d7-bcdd-16a79e432288",
"name": "Notiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-620
],
"parameters": {
"color": 6,
"width": 508,
"height": 1476,
"content": "# 🚀 Auto-Generate Social Media Videos with GPT-5 and Blotato\n\nCreate, caption, and publish videos on 9 platforms automatically using **GPT-5**, **Blotato**, **Google Sheets**, and **n8n**.\n\n---\n\n### 🎥 Full Tutorial \n[](https://youtu.be/E9NhhUDK42g) \n👉 [Click here to watch the full YouTube tutorial](https://youtu.be/E9NhhUDK42g)\n\n---\n\n### 📘 Documentation \nAccess detailed setup instructions, API config, platform connection guides, and workflow customization tips:\n\n📎 [Open the full documentation on Notion](https://automatisation.notion.site/Blotato-2473d6550fd980e19983f69611a80a0d?source=copy_link)\n\n---\n\n## ⚙️ Requirements\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\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "61d20a17-bf1c-4a93-8e75-5bd630c3ce0c",
"connections": {
"2d87b20b-b64c-411c-817c-098d9e6f7fed": {
"main": [
[
{
"node": "fde2606f-c15a-429f-9a38-5bf5115691f0",
"type": "main",
"index": 0
}
]
]
},
"bcf70961-a973-4695-9606-886ffff44adf": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 0
}
]
]
},
"510db975-9dbd-4097-a441-34d9472b8bd4": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 7
}
]
]
},
"68ef8511-885f-4b6a-bbdb-35172b6cee84": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 6
}
]
]
},
"8abd8f46-83d7-45b9-a725-770a5391310a": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 5
}
]
]
},
"9ad659bc-9ca7-40fc-9da7-1c025ceed23d": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 2
}
]
]
},
"28dda1ac-17b0-422a-90c3-d2443dcf065f": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 1
}
]
]
},
"e77f84c3-4ded-425a-b8b1-c160f5bf75f2": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 3
}
]
]
},
"b651f6fa-5130-4ebf-b33a-4b8339726bea": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 8
}
]
]
},
"8c53c394-7c0b-4bc9-ae34-264f19f31c0a": {
"main": [
[
{
"node": "2d87b20b-b64c-411c-817c-098d9e6f7fed",
"type": "main",
"index": 4
}
]
]
},
"74e5b89f-9dcb-4b7d-8c20-d631d43242dd": {
"ai_languageModel": [
[
{
"node": "b16d45e1-04ac-483c-be42-6dab8e9dcb70",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1db9406d-a683-4241-98da-887cedebe925": {
"main": [
[
{
"node": "768ae3b3-0e54-475f-a856-9fb125f7bc58",
"type": "main",
"index": 0
}
]
]
},
"e7640b66-aaff-4dfa-9366-383ef2508d11": {
"ai_tool": [
[
{
"node": "b16d45e1-04ac-483c-be42-6dab8e9dcb70",
"type": "ai_tool",
"index": 0
}
]
]
},
"768ae3b3-0e54-475f-a856-9fb125f7bc58": {
"main": [
[
{
"node": "bcf70961-a973-4695-9606-886ffff44adf",
"type": "main",
"index": 0
},
{
"node": "28dda1ac-17b0-422a-90c3-d2443dcf065f",
"type": "main",
"index": 0
},
{
"node": "9ad659bc-9ca7-40fc-9da7-1c025ceed23d",
"type": "main",
"index": 0
},
{
"node": "e77f84c3-4ded-425a-b8b1-c160f5bf75f2",
"type": "main",
"index": 0
},
{
"node": "8c53c394-7c0b-4bc9-ae34-264f19f31c0a",
"type": "main",
"index": 0
},
{
"node": "8abd8f46-83d7-45b9-a725-770a5391310a",
"type": "main",
"index": 0
},
{
"node": "68ef8511-885f-4b6a-bbdb-35172b6cee84",
"type": "main",
"index": 0
},
{
"node": "510db975-9dbd-4097-a441-34d9472b8bd4",
"type": "main",
"index": 0
},
{
"node": "b651f6fa-5130-4ebf-b33a-4b8339726bea",
"type": "main",
"index": 0
}
]
]
},
"753e1949-56b1-43a8-93c8-7f48867179fa": {
"main": [
[
{
"node": "89b0c98a-84c2-4808-8f8f-db69e8b21bcb",
"type": "main",
"index": 0
},
{
"node": "71e2b9cb-9d75-4b68-924c-87ea7ffd7ff4",
"type": "main",
"index": 0
}
]
]
},
"65165699-7361-40c8-8272-0de344734b2f": {
"main": [
[
{
"node": "753e1949-56b1-43a8-93c8-7f48867179fa",
"type": "main",
"index": 0
}
]
]
},
"89b0c98a-84c2-4808-8f8f-db69e8b21bcb": {
"main": [
[
{
"node": "dfbb598e-413e-4a3b-bcb9-dd185fe501eb",
"type": "main",
"index": 0
}
]
]
},
"fde2606f-c15a-429f-9a38-5bf5115691f0": {
"main": [
[
{
"node": "b8f79262-7418-4206-8666-a0e9e51a4cd1",
"type": "main",
"index": 0
}
]
]
},
"9d58d8dd-3d83-4455-a82f-af86435266be": {
"main": [
[
{
"node": "65165699-7361-40c8-8272-0de344734b2f",
"type": "main",
"index": 0
}
]
]
},
"184abcde-a529-4fac-ac84-0b60db7d9d05": {
"main": [
[
{
"node": "1db9406d-a683-4241-98da-887cedebe925",
"type": "main",
"index": 0
}
]
]
},
"210413ab-7b4f-43c6-ac17-d6364baf4c2e": {
"main": [
[
{
"node": "1839a4ba-8654-4732-8449-372d98a3cf20",
"type": "main",
"index": 0
}
]
]
},
"dfbb598e-413e-4a3b-bcb9-dd185fe501eb": {
"main": [
[
{
"node": "1839a4ba-8654-4732-8449-372d98a3cf20",
"type": "main",
"index": 1
}
]
]
},
"1839a4ba-8654-4732-8449-372d98a3cf20": {
"main": [
[
{
"node": "d7ee48ca-6b7c-4dbe-ba93-78fdf75cf36c",
"type": "main",
"index": 0
}
]
]
},
"d7ee48ca-6b7c-4dbe-ba93-78fdf75cf36c": {
"main": [
[
{
"node": "b16d45e1-04ac-483c-be42-6dab8e9dcb70",
"type": "main",
"index": 0
}
]
]
},
"71e2b9cb-9d75-4b68-924c-87ea7ffd7ff4": {
"main": [
[
{
"node": "210413ab-7b4f-43c6-ac17-d6364baf4c2e",
"type": "main",
"index": 0
}
]
]
},
"b16d45e1-04ac-483c-be42-6dab8e9dcb70": {
"main": [
[
{
"node": "184abcde-a529-4fac-ac84-0b60db7d9d05",
"type": "main",
"index": 0
}
]
]
},
"da5fbfd8-985e-4ddc-ba23-598c5191ca2b": {
"ai_tool": [
[
{
"node": "b16d45e1-04ac-483c-be42-6dab8e9dcb70",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Soziale Medien, Multimodales KI
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
💥 HeyGen II - Clone Me - From Idea to Launch: GPT-5 Video Automation für YouTube, TikTok und Instagram
Automatisiere die Video-Erstellung mit Spracheingabe durch HeyGen, GPT-5 und Social-Media-Publishing-Automatisierung
If
Set
Wait
+
If
Set
Wait
41 NodesDr. Firas
Content-Erstellung
💥 HeyGen - Von der Idee zur Veröffentlichung: GPT-5-Videoautomatisierung für YouTube, TikTok und Instagram - Video
Mit GPT-5 KI-Virtual-Character-Videos erstellen und auf Social-Media-Plattformen veröffentlichen
If
Set
Wait
+
If
Set
Wait
41 NodesDr. Firas
Content-Erstellung
💥 Automatisierung von Videoanzeigen mit NanoBanana, Seedream 4, ChatGPT Image und Veo 3 - VIDE
Automatisierung und Veröffentlichung von Video-Werbekampagnen mit KI (NanoBanana, Seedream, GPT-4o, Veo 3)
Set
Code
Wait
+
Set
Code
Wait
63 NodesDr. Firas
Content-Erstellung
💥 Generiere AI-Viral-Videos mit NanoBanana und VEO3 und teile sie über Blotato auf Social Media - Video
AI-Virale-Videos mit NanoBanana und VEO3 generieren und über Blotato in sozialen Medien teilen
Set
Code
Wait
+
Set
Code
Wait
47 NodesDr. Firas
Verschiedenes
Verwenden Sie NanoBanana und Seedance, um virale Werbeanzeigen zu erstellen und diese über upload-post in sozialen Medien zu veröffentlichen VIDE II
Erstellen Sie virale Multimedia-Werbung mit KI: NanoBanana, Seedance und Suno für soziale Medien
If
Set
Code
+
If
Set
Code
45 NodesDr. Firas
Verschiedenes
💥 Erstellen und automatisch auf 9 Plattformen veröffentlichen von viralen KI-Videos mit VEO3 und Blotato
VEO3 nutzen, um AI-Videos zu erstellen und über Blotato auf mehreren Plattformen zu verteilen
Set
Wait
Telegram
+
Set
Wait
Telegram
29 NodesDr. Firas
Content-Erstellung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes31
Kategorie2
Node-Typen13
Autor
Dr. Firas
@drfirasAutomation expert and certified trainer. I create hands-on courses to master automation with n8n. Contact me to access my exclusive training and start building powerful workflows today. 🚀
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen