💥 使用GPT-5自动生成社交媒体视频并通过Blotato发布 - 视频
高级
这是一个Social Media, Multimodal AI领域的自动化工作流，包含 31 个节点。主要使用 Set, Merge, Telegram, GoogleDrive, GoogleSheets 等节点。 使用GPT-5自动生成社交媒体视频并通过Blotato发布
前置要求
- •Telegram Bot Token
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (31)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "4H8VzyaoTpFXg9Nj",
"meta": {
"instanceId": "a2b23892dd6989fda7c1209b381f5850373a7d2b85609624d7c2b7a092671d44",
"templateCredsSetupCompleted": true
},
"name": "💥 使用 GPT-5 自动生成社交媒体视频并通过 Blotato 发布 - 视频",
"tags": [],
"nodes": [
{
"id": "768ae3b3-0e54-475f-a856-9fb125f7bc58",
"name": "上传视频到 BLOTATO",
"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": "合并",
"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": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
-620
],
"parameters": {
"width": 1960,
"height": 660,
"content": "# 🧠 步骤 1 — 从视频生成标题和描述"
},
"typeVersion": 1
},
{
"id": "f8fb8bb2-f5fa-4014-af80-1e81389566c4",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
100
],
"parameters": {
"width": 1960,
"height": 760,
"content": "# 🚀 步骤 2 — 自动发布到 9 个社交平台"
},
"typeVersion": 1
},
{
"id": "1db9406d-a683-4241-98da-887cedebe925",
"name": "获取Google Drive ID",
"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 - 接收视频创意",
"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 - 创建行",
"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 - 下载视频",
"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 - 上传视频",
"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 - 将视频转录为文本",
"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 - 保存视频信息",
"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 - 保存转录文本",
"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": "合并 - 连接视频 + 转录文本",
"type": "n8n-nodes-base.merge",
"position": [
-820,
-380
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3.2
},
{
"id": "d7ee48ca-6b7c-4dbe-ba93-78fdf75cf36c",
"name": "Google Sheets - 为 AI 读取数据",
"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": "AI Agent - 生成标题和描述",
"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 模型 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 - 思考工具",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
-440,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "da5fbfd8-985e-4ddc-ba23-598c5191ca2b",
"name": "Google Sheets - 更新标题和描述",
"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 - 读取帖子数据",
"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 - 更新状态",
"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 - 通知帖子完成",
"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": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-620
],
"parameters": {
"color": 6,
"width": 508,
"height": 1476,
"content": "# 🚀 使用 GPT-5 和 Blotato 自动生成社交媒体视频"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "61d20a17-bf1c-4a93-8e75-5bd630c3ce0c",
"connections": {
"Merge": {
"main": [
[
{
"node": "Google Sheets - Update Status",
"type": "main",
"index": 0
}
]
]
},
"Tiktok": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Bluesky": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 7
}
]
]
},
"Threads": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 6
}
]
]
},
"Youtube": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 5
}
]
]
},
"Facebook": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Linkedin": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Instagram": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Pinterest": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 8
}
]
]
},
"Twitter (X)": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 4
}
]
]
},
"OpenAI Model GPT-5": {
"ai_languageModel": [
[
{
"node": "AI Agent - Generate Title & Caption",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Get Google Drive ID": {
"main": [
[
{
"node": "Upload Video to BLOTATO",
"type": "main",
"index": 0
}
]
]
},
"LangChain - Think Tool": {
"ai_tool": [
[
{
"node": "AI Agent - Generate Title & Caption",
"type": "ai_tool",
"index": 0
}
]
]
},
"Upload Video to BLOTATO": {
"main": [
[
{
"node": "Tiktok",
"type": "main",
"index": 0
},
{
"node": "Linkedin",
"type": "main",
"index": 0
},
{
"node": "Facebook",
"type": "main",
"index": 0
},
{
"node": "Instagram",
"type": "main",
"index": 0
},
{
"node": "Twitter (X)",
"type": "main",
"index": 0
},
{
"node": "Youtube",
"type": "main",
"index": 0
},
{
"node": "Threads",
"type": "main",
"index": 0
},
{
"node": "Bluesky",
"type": "main",
"index": 0
},
{
"node": "Pinterest",
"type": "main",
"index": 0
}
]
]
},
"Telegram - Download Video": {
"main": [
[
{
"node": "Google Drive - Upload Video",
"type": "main",
"index": 0
},
{
"node": "OpenAI - Transcribe Video to Text",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Create Row": {
"main": [
[
{
"node": "Telegram - Download Video",
"type": "main",
"index": 0
}
]
]
},
"Google Drive - Upload Video": {
"main": [
[
{
"node": "Google Sheets - Save Video Info",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Status": {
"main": [
[
{
"node": "Telegram - Notify Post Done",
"type": "main",
"index": 0
}
]
]
},
"Telegram - Receive Video Idea": {
"main": [
[
{
"node": "Google Sheets - Create Row",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Read Post Data": {
"main": [
[
{
"node": "Get Google Drive ID",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Save Transcript": {
"main": [
[
{
"node": "Merge - Join Video + Transcript",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Save Video Info": {
"main": [
[
{
"node": "Merge - Join Video + Transcript",
"type": "main",
"index": 1
}
]
]
},
"Merge - Join Video + Transcript": {
"main": [
[
{
"node": "Google Sheets - Read Data for AI",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Read Data for AI": {
"main": [
[
{
"node": "AI Agent - Generate Title & Caption",
"type": "main",
"index": 0
}
]
]
},
"OpenAI - Transcribe Video to Text": {
"main": [
[
{
"node": "Google Sheets - Save Transcript",
"type": "main",
"index": 0
}
]
]
},
"AI Agent - Generate Title & Caption": {
"main": [
[
{
"node": "Google Sheets - Read Post Data",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Title & Caption": {
"ai_tool": [
[
{
"node": "AI Agent - Generate Title & Caption",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
💥 HeyGen II - 克隆我 - 从想法到发布：适用于 YouTube、TikTok 和 Instagram 的 GPT-5 视频自动化 - 视频
使用 HeyGen、GPT-5 和社交发布自动化语音输入视频创作
If
Set
Wait
+13
41 节点Dr. Firas
内容创作
💥 HeyGen - 从想法到发布：用于 YouTube、TikTok 和 Instagram 的 GPT-5 视频自动化 - 视频
使用 GPT-5 生成 AI 虚拟形象视频并发布至社交媒体平台
If
Set
Wait
+13
41 节点Dr. Firas
内容创作
💥 使用NanoBanana、Seedream 4、ChatGPT Image和Veo 3自动化视频广告 - VIDE
使用AI（NanoBanana、Seedream、GPT-4o、Veo 3）自动化和发布视频广告活动
Set
Code
Wait
+16
63 节点Dr. Firas
内容创作
💥 使用NanoBanana和VEO3生成AI病毒视频，通过Blotato分享到社交平台 - 视频
使用NanoBanana和VEO3生成AI病毒视频，通过Blotato在社交媒体分享
Set
Code
Wait
+13
47 节点Dr. Firas
杂项
💥 使用 NanoBanana 和 Seedance 创建病毒式广告，通过 upload-post 在社交媒体发布 VIDE II
使用 AI 创建病毒式多媒体广告：NanoBanana、Seedance 和 Suno 用于社交媒体
If
Set
Code
+13
45 节点Dr. Firas
杂项
💥 使用 VEO3 和 Blotato 创建并自动发布到 9 个平台的病毒式 AI 视频
使用 VEO3 生成 AI 视频并通过 Blotato 在多个平台分发
Set
Wait
Telegram
+9
29 节点Dr. Firas
内容创作
工作流信息
难度等级
高级
节点数量31
分类2
节点类型13
作者
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. 🚀
外部链接
在 n8n.io 查看 →
分享此工作流