在Facebook页面上发布Reel
高级
这是一个Social Media领域的自动化工作流，包含 17 个节点。主要使用 If, Set, Code, Wait, GoogleDrive 等节点。 使用Google表格和Drive自动化Facebook Reels发布
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "hpXL1RWOL0AurfV4",
"meta": {
"instanceId": "b5825084f383ba38862ba0b5b7e95c5107a40c4ed7afc78372d74501163a8e33",
"templateCredsSetupCompleted": true
},
"name": "在Facebook页面上发布Reel",
"tags": [
{
"id": "bijhlBrac9anlLzs",
"name": "Drive",
"createdAt": "2025-10-24T11:20:52.395Z",
"updatedAt": "2025-10-24T11:20:52.395Z"
},
{
"id": "jjIfrn6w1N0BsOpf",
"name": "Facebook",
"createdAt": "2025-10-24T11:20:43.395Z",
"updatedAt": "2025-10-24T11:20:43.395Z"
},
{
"id": "AGH85nOczgSmrhPc",
"name": "Reels",
"createdAt": "2025-10-13T08:26:02.604Z",
"updatedAt": "2025-10-13T08:26:02.604Z"
},
{
"id": "U9LHxJS6pH2YCEtj",
"name": "Sheet",
"createdAt": "2025-10-13T08:26:02.584Z",
"updatedAt": "2025-10-13T08:26:02.584Z"
}
],
"nodes": [
{
"id": "c98f4dee-831a-4de6-b2df-d44cf320a7f4",
"name": "信息",
"type": "n8n-nodes-base.set",
"position": [
-1472,
48
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "5ca53588-a5fd-47fe-a9db-5e8b42e88a19",
"name": "Token",
"type": "string",
"value": "<token>"
},
{
"id": "0fc539bd-e223-4f1a-86b2-15e4b2a34df6",
"name": "Id Page",
"type": "string",
"value": "<id page>"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5dee332a-6319-419c-9fe2-2ed3f4b7639b",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1696,
48
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 30
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f0a8f95d-88f8-41b6-8a38-2ae55a4ce3ec",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1456,
384
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Get Row Sheet').first().json['File ID'] }}"
},
"options": {
"binaryPropertyName": "data"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "b1IgmLfVK7MkWuXO",
"name": "Google Drive account"
}
},
"executeOnce": true,
"typeVersion": 3,
"alwaysOutputData": false
},
{
"id": "4424daa9-14d9-47d5-b78b-2b2fda283540",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
-1360,
656
],
"webhookId": "42d2250f-9af7-4912-862f-4ae0615bf2fd",
"parameters": {
"unit": "minutes"
},
"typeVersion": 1.1
},
{
"id": "e8db21a1-9a82-4c4b-a50e-af406a12bb8d",
"name": "步骤1：初始化上传会话",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1664,
384
],
"parameters": {
"url": "=https://graph.facebook.com/v23.0/{{ $('info').first().json['Id Page'] }}/video_reels\n",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "upload_phase",
"value": "start"
},
{
"name": "access_token",
"value": "={{ $('info').first().json.Token }}"
}
]
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "62cef400-c3fb-439e-a0ab-3c8f77e4c158",
"name": "步骤2：上传视频",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1040,
384
],
"parameters": {
"url": "={{ $('Step 1: Initialize an Upload Session').first().json.body.upload_url }}",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "offset",
"value": "0"
},
{
"name": "file_size",
"value": "={{ $('Get the size file').first().json.actualSize }}"
},
{
"name": "=Authorization",
"value": "=OAuth {{ $('info').first().json.Token }}"
}
]
},
"inputDataFieldName": "=data"
},
"typeVersion": 4.2
},
{
"id": "547c52ee-7883-432d-8485-2a7c1f3b92c9",
"name": "步骤3：发布Reel",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1664,
752
],
"parameters": {
"url": "=https://graph.facebook.com/v23.0/{{ $('info').first().json['Id Page'] }}/video_reels",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "video_id",
"value": "={{ $('Step 1: Initialize an Upload Session').first().json.body.video_id }}"
},
{
"name": "upload_phase",
"value": "finish"
},
{
"name": "access_token",
"value": "={{ $('info').first().json.Token }}"
},
{
"name": "video_state",
"value": "PUBLISHED"
},
{
"name": "description",
"value": "={{ $('Get Row Sheet').first().json['Caption'] }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "91e05176-b3a8-44de-a819-32a0575e288a",
"name": "获取行表",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1248,
48
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78/edit#gid=0",
"cachedResultName": "Trang tính1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78/edit?usp=drivesdk",
"cachedResultName": "Publish a reel on a Facebook Page"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HfujyDOlKBcmEBrq",
"name": "Google Sheets account"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "ea72e8eb-6685-4e91-93cd-a9bdf276ad95",
"name": "获取文件大小",
"type": "n8n-nodes-base.code",
"position": [
-1248,
384
],
"parameters": {
"jsCode": "return items.map(item => {\n const size = item.binary.data.fileSize;\n const contentLength = Buffer.from(item.binary.data.data, 'base64').length;\n\n item.json = {\n declaredSize: size,\n actualSize: contentLength\n };\n\n return item;\n});\n"
},
"typeVersion": 2
},
{
"id": "bfb4edf0-3c25-4e88-9bf6-16657f977d59",
"name": "更新状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1360,
832
],
"parameters": {
"columns": {
"value": {
"Link post": "x",
"row_number": "={{ $('Get Row Sheet').first().json.row_number }}"
},
"schema": [
{
"id": "File ID",
"type": "string",
"display": true,
"required": false,
"displayName": "File ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "File name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "File name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link Share",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Link Share",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link post",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Link post",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78/edit#gid=0",
"cachedResultName": "Trang tính1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JMT2BpWxfcG-d_XEWRppdSr_ZkG0XvtiaGaB8Lzdl78/edit?usp=drivesdk",
"cachedResultName": "Publish a reel on a Facebook Page"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HfujyDOlKBcmEBrq",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ac97c446-241f-4306-bdb8-5d6768fcffa5",
"name": "创建帖子评论",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
-1040,
656
],
"parameters": {
"url": "=https://graph.facebook.com/v23.0/115432036514099_{{ $('Step 1: Initialize an Upload Session').first().json.body.video_id }}/comments",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "access_token",
"value": "={{ $('info').first().json.Token }}"
},
{
"name": "message",
"value": "=Mua hàng tại Shopee: {{ $('Get Row Sheet').item.json['Link Aff 1'] }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d6e2986d-25da-47aa-b73e-6766b0ac6ba1",
"name": "搜索文件和文件夹",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1424,
-288
],
"parameters": {
"filter": {
"folderId": {
"__rl": true,
"mode": "list",
"value": "16tm-jSUaz4B4Xk8Dc0h-jxxKVydzwHKJ",
"cachedResultUrl": "https://drive.google.com/drive/folders/16tm-jSUaz4B4Xk8Dc0h-jxxKVydzwHKJ",
"cachedResultName": "n8n creator"
}
},
"options": {
"fields": [
"id",
"name"
]
},
"resource": "fileFolder",
"returnAll": true,
"queryString": "mimeType = 'video/mp4'",
"searchMethod": "query"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "b1IgmLfVK7MkWuXO",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "74566e2f-e8b3-408b-8b7b-b4f6aa5907b4",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1712,
-288
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "162ef463-3032-4744-bfea-60a02b441dc9",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1072,
-288
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json.name }}",
"File ID": "={{ $json.id }}",
"Link Share": "=https://drive.google.com/uc?id={{ $json.id }}&export=download"
},
"schema": [
{
"id": "Stories",
"type": "string",
"display": true,
"required": false,
"displayName": "Stories",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "File ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "File ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link Share",
"type": "string",
"display": true,
"required": false,
"displayName": "Link Share",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"File ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RnE5O06l7W6TLCLKkwEH5Oyl-EZ3OE-Uc3OWFbDohYI/edit#gid=0",
"cachedResultName": "Trang tính1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1RnE5O06l7W6TLCLKkwEH5Oyl-EZ3OE-Uc3OWFbDohYI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1RnE5O06l7W6TLCLKkwEH5Oyl-EZ3OE-Uc3OWFbDohYI/edit?usp=drivesdk",
"cachedResultName": "Video stories facebook"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HfujyDOlKBcmEBrq",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "33b6589f-a47e-45e1-a914-2796db631b35",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2400,
-336
],
"parameters": {
"width": 1536,
"height": 272,
"content": "## 自动化Google Drive视频列表更新到Google Sheet"
},
"typeVersion": 1
},
{
"id": "e715160f-c6be-4daf-a27b-addcfe315b63",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-1040,
48
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "960b3395-7df1-4cdd-ac7a-2a738c812cc9",
"operator": {
"type": "number",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json[\"File ID\"] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9b3751d2-558e-46f7-991a-474279e09b50",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2400,
16
],
"parameters": {
"width": 1536,
"height": 992,
"content": "## 在Facebook页面上发布Reel"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "Asia/Ho_Chi_Minh",
"callerPolicy": "workflowsFromSameOwner",
"availableInMCP": false,
"executionOrder": "v1"
},
"versionId": "4cab5ef2-d515-4c2a-a7ab-bd2268ab3db1",
"connections": {
"If": {
"main": [
[
{
"node": "Step 1: Initialize an Upload Session",
"type": "main",
"index": 0
}
],
[
{
"node": "Get Row Sheet",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Create comment post",
"type": "main",
"index": 0
}
]
]
},
"info": {
"main": [
[
{
"node": "Get Row Sheet",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Get the size file",
"type": "main",
"index": 0
}
]
]
},
"Get Row Sheet": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "info",
"type": "main",
"index": 0
}
]
]
},
"Get the size file": {
"main": [
[
{
"node": "Step 2: Upload the Video",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Search files and folders",
"type": "main",
"index": 0
}
]
]
},
"Search files and folders": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Step 2: Upload the Video": {
"main": [
[
{
"node": "Step 3: Publish the Reel",
"type": "main",
"index": 0
}
]
]
},
"Step 3: Publish the Reel": {
"main": [
[
{
"node": "Update status",
"type": "main",
"index": 0
},
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Step 1: Initialize an Upload Session": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在您的 Facebook 页面发布视频故事
使用 Google Drive 和 Sheets 自动化视频故事发布到 Facebook 页面
If
Set
Code
+5
16 节点Đỗ Thành Nguyên
社交媒体
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
自动化推荐工作流
使用GPT-4处理推荐信，并通过Google表格自动生成社交媒体卡片
If
Set
Code
+9
34 节点Jitesh Dugar
社交媒体
使用 Google Drive 和 Meta Graph API 从 Google Sheets 上传视频和图片广告到 Meta Ads Manager
从 Google Sheets 和 Google Drive 上传视频和图片广告到 Meta Ads Manager
If
Set
Code
+11
42 节点Daniel Setzermann
社交媒体
AI驱动视频创作与上传至Instagram、TikTok和YouTube
从云端硬盘进行AI驱动视频创作并上传至Instagram、TikTok和YouTube
If
Set
Code
+14
53 节点DevCode Journey
内容创作
AI自动化TikTok/Youtube短视频/Reels生成器
基于AI的短视频生成器，集成OpenAI、Flux、Kling和ElevenLabs
If
Set
Code
+9
41 节点Cameron Wills
人工智能
