使用数据表获取长时效Facebook访问令牌
中级
这是一个Social Media领域的自动化工作流，包含 11 个节点。主要使用 Set, SplitOut, DataTable, HttpRequest, ScheduleTrigger 等节点。 通过数据表存储自动化Facebook页面令牌续期
前置要求
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "enqUom6Fs1WaDOCW",
"meta": {
"instanceId": "b5825084f383ba38862ba0b5b7e95c5107a40c4ed7afc78372d74501163a8e33",
"templateId": "2535"
},
"name": "使用数据表获取长时效 Facebook 访问令牌",
"tags": [],
"nodes": [
{
"id": "11a68266-f7ec-4c56-9327-c4fd0e4478f6",
"name": "设置参数",
"type": "n8n-nodes-base.set",
"position": [
720,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b1f6b8a1-dc25-4b1e-9aa3-0c0e452ae2de",
"name": " client_id",
"type": "string",
"value": "<client_id>"
},
{
"id": "9a63879a-c359-49ad-9fec-19c9e4c78dd6",
"name": " client_secret",
"type": "string",
"value": "<client_secret>"
},
{
"id": "6971a841-ed5e-4d96-bdab-1eaec2d51ccc",
"name": "user_access_token",
"type": "string",
"value": "<user_access_token>"
},
{
"id": "c75d5e50-62ea-4ee0-bfaa-5f79cf4d147e",
"name": "app_scoped_user_id",
"type": "string",
"value": "<app_scoped_user_id>"
},
{
"id": "75516211-496a-46bf-82ad-2352f7080512",
"name": "long_user_access_token",
"type": "string",
"value": "={{ $json.body.access_token }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c844cc76-6a73-4e4c-b5af-dd3b0c391a66",
"name": "分离",
"type": "n8n-nodes-base.splitOut",
"position": [
352,
880
],
"parameters": {
"include": "allOtherFields",
"options": {
"includeBinary": false
},
"fieldToSplitOut": "body.data"
},
"typeVersion": 1
},
{
"id": "5bbff2d4-0b0e-4194-97f7-c1a4c09c7c77",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
544,
880
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fead0c79-b7a9-4da8-adc8-c68ea86041af",
"name": "access_token",
"type": "string",
"value": "={{ $json['body.data'].access_token }}"
},
{
"id": "98467cc1-4960-4291-a685-b7dd04f24211",
"name": "name",
"type": "string",
"value": "={{ $json['body.data'].name }}"
},
{
"id": "6b7b8c21-ef78-40ba-86df-0a7f46057bca",
"name": "id",
"type": "string",
"value": "={{ $json['body.data'].id }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "fa84d8ed-511e-42b7-a954-a35bb5b70dd8",
"name": "插入/更新行",
"type": "n8n-nodes-base.dataTable",
"position": [
736,
880
],
"parameters": {
"columns": {
"value": {
"token": "={{ $json.access_token }}",
"id_page": "={{ $json.id }}",
"name_page": "={{ $json.name }}"
},
"schema": [
{
"id": "name_page",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "name_page",
"defaultMatch": false
},
{
"id": "id_page",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "id_page",
"defaultMatch": false
},
{
"id": "token",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "token",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"filters": {
"conditions": [
{
"keyName": "id_page",
"keyValue": "={{ $json.id }}"
}
]
},
"matchType": "allConditions",
"operation": "upsert",
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "tmKVoWFoXqgiVHtI",
"cachedResultUrl": "/projects/ZsXeoU4uGUhTbvTf/datatables/tmKVoWFoXqgiVHtI",
"cachedResultName": "n8n"
}
},
"typeVersion": 1
},
{
"id": "76b1d58f-41d6-4088-99e1-da2a3663116e",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
272,
240
],
"parameters": {
"rule": {
"interval": [
{
"field": "months",
"monthsInterval": 2
}
]
}
},
"typeVersion": 1.2
},
{
"id": "831a32d7-ea1a-4d5b-bd2e-e9e715e6d7a1",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
176
],
"parameters": {
"color": 6,
"width": 1072,
"height": 288,
"content": "## 步骤 1"
},
"typeVersion": 1
},
{
"id": "cfbc57a3-bfb2-4237-b7b0-88d339362931",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
512
],
"parameters": {
"color": 3,
"width": 1072,
"height": 288,
"content": "## 步骤 2"
},
"typeVersion": 1
},
{
"id": "dddf5f0d-2cab-4b75-8cc4-ecbcd5e3cbcc",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
848
],
"parameters": {
"width": 1072,
"height": 288,
"content": "## 步骤 3"
},
"typeVersion": 1
},
{
"id": "9f3d0b85-8c02-4d78-9da8-f9ce98b189b2",
"name": "获取长时效 Facebook 用户令牌",
"type": "n8n-nodes-base.httpRequest",
"position": [
304,
560
],
"parameters": {
"url": "https://graph.facebook.com/v23.0/oauth/access_token",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "grant_type",
"value": "fb_exchange_token"
},
{
"name": "client_id",
"value": "={{ $json[' client_id'] }}"
},
{
"name": "client_secret",
"value": "={{ $json[' client_secret'] }}"
},
{
"name": "fb_exchange_token",
"value": "={{ $json.user_access_token }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "84e16f5c-6be3-4639-9d34-18cc057725e6",
"name": "获取 Facebook 页面列表",
"type": "n8n-nodes-base.httpRequest",
"position": [
512,
560
],
"parameters": {
"url": "https://graph.facebook.com/v23.0/me/accounts",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "access_token",
"value": "={{ $json.body.access_token }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "4e898760-43cd-4d4f-a76c-555175fb2a27",
"name": "获取长时效 Facebook 页面令牌",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
560
],
"parameters": {
"url": "=https://graph.facebook.com/v23.0/{{ $('Set Parameter').item.json.app_scoped_user_id }}/accounts",
"method": "=GET",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": " access_token",
"value": "={{ $('Get long lived facebook user token').item.json.body.access_token }}"
}
]
}
},
"typeVersion": 4.2
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a43aee60-5261-4af8-bdde-cf2c27b2cbc8",
"connections": {
"Split Out": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Upsert row(s)",
"type": "main",
"index": 0
}
]
]
},
"Set Parameter": {
"main": [
[
{
"node": "Get long lived facebook user token",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set Parameter",
"type": "main",
"index": 0
}
]
]
},
"Get list facebook page": {
"main": [
[
{
"node": "Get long lived facebook page token",
"type": "main",
"index": 0
}
]
]
},
"Get long lived facebook page token": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Get long lived facebook user token": {
"main": [
[
{
"node": "Get list facebook page",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 社交媒体
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在Facebook页面上发布Reel
使用Google表格和Drive自动化Facebook Reels发布
If
Set
Code
+6
17 节点Đỗ Thành Nguyên
社交媒体
在您的 Facebook 页面发布视频故事
使用 Google Drive 和 Sheets 自动化视频故事发布到 Facebook 页面
If
Set
Code
+5
16 节点Đỗ Thành Nguyên
社交媒体
使用 Claude AI 替代文本生成器从 Lightroom 到 Instagram 自动化
使用 Claude AI 替代文本生成器从 Lightroom 到 Instagram 自动化
Set
Code
Sort
+7
14 节点Camille Roux
社交媒体
使用 Apify 和 GPT-4.1 从 Skool 社区发现互动机会
通过 Apify 和 GPT-4.1 从 Skool 社区发现互动机会
Set
Filter
Airtable
+7
18 节点Alexandra Spalato
社交媒体
基于美国众议院法案使用Gemini AI生成周度动物权益行动简报
基于美国众议院法案使用Gemini AI生成周度动物权益行动简报
If
Set
Html
+13
26 节点Open Paws
社交媒体
Lightroom 照片 Instagram 自动发布器（AI 字幕）
Lightroom 照片 Instagram 自动发布器（AI 字幕）
Set
Sort
Limit
+5
17 节点Camille Roux
社交媒体
