1个帖子发布到所有平台
高级
这是一个Miscellaneous, Multimodal AI领域的自动化工作流,包含 23 个节点。主要使用 Set, Merge, GoogleSheets, ScheduleTrigger, Blotato 等节点。 使用 Google Sheets、Drive 和 Blotato 的自动化每日发布至 9 个社交平台
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "IsEN5SyZ7lz4zsGY",
"meta": {
"instanceId": "e232d38e020fdf3e4c5aac7fdf84cd849e91ffb2c1ad80af1a4b16753ff64418",
"templateCredsSetupCompleted": true
},
"name": "1个帖子发布到所有平台",
"tags": [],
"nodes": [
{
"id": "b203144c-fc13-47ed-815c-d034615e2ec4",
"name": "获取 Google Drive ID",
"type": "n8n-nodes-base.set",
"position": [
-576,
928
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a1750d20-2f6e-4826-80b8-654d0985120d",
"name": "final_google_drive_url",
"type": "string",
"value": "={{ $('Ready to Post Image/Video').item.json['Media URL (google drive)'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3816e08f-ca5f-4dc1-a376-0455edc6bad0",
"name": "准备发布的图片/视频",
"type": "n8n-nodes-base.googleSheets",
"position": [
-816,
928
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "Ready to Post",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
"cachedResultName": "1_post_everywhere"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NngJvVwUfIhrtQY2",
"name": "Google - Blotato"
}
},
"typeVersion": 4.5
},
{
"id": "fa56ad76-9c08-42cd-b2c2-4053895fb730",
"name": "上传图片/视频到 BLOTATO",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
-336,
928
],
"parameters": {
"mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}",
"resource": "media"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "dd641212-cc0e-4259-95fa-8dbea48c1fe4",
"name": "Tiktok [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"maxTries": 2,
"position": [
240,
240
],
"parameters": {
"options": {},
"platform": "tiktok",
"accountId": {
"__rl": true,
"mode": "list",
"value": "199",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/199",
"cachedResultName": "sabrina_ramonov"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"retryOnFail": false,
"typeVersion": 2,
"waitBetweenTries": 3000
},
{
"id": "ad80ba63-740a-4522-bee7-7ecd3237fe3d",
"name": "每3小时检查一次",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1056,
928
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 3
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cf740889-604b-4494-b565-11c472b689c0",
"name": "Linkedin [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
400
],
"parameters": {
"options": {},
"platform": "linkedin",
"accountId": {
"__rl": true,
"mode": "list",
"value": "4590",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/4590",
"cachedResultName": "Sabrina Ramonov 🍄"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "261a582e-fc1a-44c6-91d7-da34bfe631b2",
"name": "Facebook [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
560
],
"parameters": {
"options": {},
"platform": "facebook",
"accountId": {
"__rl": true,
"mode": "list",
"value": "369",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/369",
"cachedResultName": "Sabrina Ramonov"
},
"facebookPageId": {
"__rl": true,
"mode": "list",
"value": "161711670360847",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/369/subaccounts/161711670360847",
"cachedResultName": "Blotato"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "b721aba5-845d-44b7-ba80-fa8d79094a3f",
"name": "Instagram [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"maxTries": 2,
"position": [
240,
720
],
"parameters": {
"options": {},
"accountId": {
"__rl": true,
"mode": "list",
"value": "28",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/28",
"cachedResultName": "sabrina_ramonov"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"retryOnFail": true,
"typeVersion": 2,
"waitBetweenTries": 5000
},
{
"id": "2be9a129-4ed0-4a3b-9faa-4ef7cfaab7a7",
"name": "Twitter [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
880
],
"parameters": {
"options": {},
"platform": "twitter",
"accountId": {
"__rl": true,
"mode": "list",
"value": "38",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/38",
"cachedResultName": "Sabrina_Ramonov"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "f6527ebf-0f51-4301-aa83-8cb0bddef948",
"name": "Youtube [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
1040
],
"parameters": {
"options": {},
"platform": "youtube",
"accountId": {
"__rl": true,
"mode": "list",
"value": "111",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/111",
"cachedResultName": "Sabrina Ramonov 🍄"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}",
"postCreateYoutubeOptionTitle": "={{ $('Ready to Post Image/Video').item.json.Title }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "c6566c09-9366-4d8c-afb4-073b0013954d",
"name": "Threads [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
1200
],
"parameters": {
"options": {},
"platform": "threads",
"accountId": {
"__rl": true,
"mode": "list",
"value": "3",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/3",
"cachedResultName": "sabrina_ramonov"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "668aa4c7-0058-472e-9196-a5a41eb0dd19",
"name": "Bluesky [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
1360
],
"parameters": {
"options": {},
"platform": "bluesky",
"accountId": {
"__rl": true,
"mode": "list",
"value": "8",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/8",
"cachedResultName": "sabrinaramonov.bsky.social"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "dcee45da-64dc-48a2-8a41-086b441ba409",
"name": "Pinterest [BLOTATO]",
"type": "@blotato/n8n-nodes-blotato.blotato",
"onError": "continueErrorOutput",
"position": [
240,
1520
],
"parameters": {
"options": {},
"platform": "pinterest",
"accountId": {
"__rl": true,
"mode": "list",
"value": "358",
"cachedResultUrl": "https://backend.blotato.com/v2/accounts/358",
"cachedResultName": "sabrina_ramonov"
},
"postContentText": "={{ $('Ready to Post Image/Video').item.json.Caption }}",
"pinterestBoardId": {
"__rl": true,
"mode": "id",
"value": "1234"
},
"postContentMediaUrls": "={{ $('Upload Image/Video to BLOTATO').item.json.url }}"
},
"credentials": {
"blotatoApi": {
"id": "zI14DNda55rFeyY8",
"name": "Blotato - Brand"
}
},
"typeVersion": 2
},
{
"id": "eb36ef73-5b01-41ec-ae72-138647989dd5",
"name": "更新状态为\"已发布\"",
"type": "n8n-nodes-base.googleSheets",
"position": [
240,
1744
],
"parameters": {
"columns": {
"value": {
"Status": "Posted",
"Caption": "={{ $('Ready to Post Image/Video').item.json.Caption }}"
},
"schema": [
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Media URL (google drive)",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Media 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": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1v5S7F9p2apfWRSEHvx8Q6ZX8e-d1lZ4FLlDFyc0-ZA4/edit?usp=drivesdk",
"cachedResultName": "1_post_everywhere"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "LEqYeTjqcTBUQ2W2",
"name": "Google - Brand"
}
},
"typeVersion": 4.5
},
{
"id": "57f04d8e-8317-4921-8e74-19526f16e675",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1152,
304
],
"parameters": {
"color": 6,
"width": 1056,
"height": 1232,
"content": "# 准备发布"
},
"typeVersion": 1
},
{
"id": "c901d211-cf71-49a7-8220-9d2ef799668b",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
1104
],
"parameters": {
"color": 2,
"width": 224,
"height": 112,
"content": "# 设置 1"
},
"typeVersion": 1
},
{
"id": "c1b490bb-7fd4-4fdb-a72b-22adb7a3871e",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-608,
1104
],
"parameters": {
"color": 3,
"width": 150,
"height": 112,
"content": "# 请勿修改"
},
"typeVersion": 1
},
{
"id": "438b1381-f384-4365-aaf7-c990e28df071",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-256
],
"parameters": {
"color": 4,
"width": 928,
"height": 2224,
"content": "# 发布到所有平台"
},
"typeVersion": 1
},
{
"id": "e49dbbe2-fff5-44d5-a878-d8ada23a5d6b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-416,
1104
],
"parameters": {
"color": 2,
"width": 272,
"height": 304,
"content": "# 设置 2"
},
"typeVersion": 1
},
{
"id": "c1d94f4b-00e2-47f8-839e-81f104ecfbe9",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1056,
64
],
"parameters": {
"color": 7,
"width": 608,
"height": 1632,
"content": "# 平台特定说明"
},
"typeVersion": 1
},
{
"id": "5f3b1432-b8e8-49a6-8b64-cd87eb266cc4",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
128,
32
],
"parameters": {
"color": 2,
"width": 320,
"height": 176,
"content": "# 设置 3"
},
"typeVersion": 1
},
{
"id": "c6bd6077-6d4c-485b-84db-63386a12329c",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
1104
],
"parameters": {
"color": 7,
"width": 288,
"height": 192,
"content": "# 最终报告"
},
"typeVersion": 1
},
{
"id": "f75a35bc-24a7-4ec8-9165-c17e230e7f34",
"name": "最终报告",
"type": "n8n-nodes-base.merge",
"position": [
672,
720
],
"parameters": {
"numberInputs": 9
},
"notesInFlow": false,
"typeVersion": 3.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a3cc5077-67c4-472e-b9bb-e93b21130696",
"connections": {
"Tiktok [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 0
}
]
]
},
"Bluesky [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 7
}
]
]
},
"Threads [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 6
}
]
]
},
"Twitter [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 4
}
]
]
},
"Youtube [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 5
}
]
]
},
"Facebook [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 2
}
]
]
},
"Linkedin [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 1
}
]
]
},
"Check Every 3 Hours": {
"main": [
[
{
"node": "Ready to Post Image/Video",
"type": "main",
"index": 0
}
]
]
},
"Get Google Drive ID": {
"main": [
[
{
"node": "Upload Image/Video to BLOTATO",
"type": "main",
"index": 0
}
]
]
},
"Instagram [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 3
}
]
]
},
"Pinterest [BLOTATO]": {
"main": [
[],
[
{
"node": "Final Report",
"type": "main",
"index": 8
}
]
]
},
"Ready to Post Image/Video": {
"main": [
[
{
"node": "Get Google Drive ID",
"type": "main",
"index": 0
}
]
]
},
"Upload Image/Video to BLOTATO": {
"main": [
[
{
"node": "Tiktok [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Linkedin [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Facebook [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Instagram [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Twitter [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Youtube [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Threads [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Bluesky [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Pinterest [BLOTATO]",
"type": "main",
"index": 0
},
{
"node": "Update Status to \"Posted\"",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
高级 - 杂项, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
4个病毒式新闻到AI头像视频
使用Perplexity和HeyGen创建病毒式新闻AI头像视频并发布到9个平台
If
Set
Wait
+7
35 节点Sabrina Ramonov 🍄
杂项
3个Hackernews到AI克隆视频
使用Heygen和Blotato生成并自动发布科技新闻AI虚拟形象视频到社交媒体
If
Set
Wait
+9
30 节点Sabrina Ramonov 🍄
内容创作
5 使用AI聊天自动化Instagram轮播图
使用AI和Blotato在5个平台创建和发布社交媒体轮播图
If
Wait
Merge
+8
29 节点Sabrina Ramonov 🍄
杂项
每日 WhatsApp 群组智能分析:GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析:GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
使用ScrapeGraph AI提取n8n社区最近添加的工作流
使用ScrapeGraphAI和Gemini提取和存储n8n社区最近添加的工作流
Set
Merge
Split Out
+12
21 节点Davide
杂项
💥 使用VEO 3生成AI病毒视频并上传到TikTok
使用VEO 3生成AI病毒视频并上传到TikTok
Set
Code
Wait
+9
24 节点Dr. Firas
内容创作
工作流信息
难度等级
高级
节点数量23
分类2
节点类型6
作者
Sabrina Ramonov 🍄
@sabrina-ramonov- Teach 10M people AI - Sold AI startup for $10M+ - 0 to 1.3M+ followers in 1 year - Solo Founder, Blotato.com - social media API - Learn AI for free: www.sabrina.dev
外部链接
在 n8n.io 查看 →
分享此工作流