直接在 Notion 数据库中自动记录 n8n 工作流
中级
这是一个Other领域的自动化工作流，包含 10 个节点。主要使用 If, N8n, Set, Notion, HttpRequest 等节点。 直接在 Notion 数据库中自动记录 n8n 工作流
前置要求
- •Notion API Key
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "2c3549c1-99c1-4255-a02d-2f454e6ced5e",
"name": "每 15 分钟",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
560,
340
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 15
}
]
}
},
"typeVersion": 1.1
},
{
"id": "3380272e-5631-44aa-b7da-5e23e0966978",
"name": "获取所有带标签的工作流",
"type": "n8n-nodes-base.n8n",
"position": [
780,
340
],
"parameters": {
"filters": {
"tags": "sync-to-notion"
}
},
"credentials": {
"n8nApi": {
"id": "230",
"name": "n8n admin account"
}
},
"typeVersion": 1
},
{
"id": "d702f13e-8e93-4142-87c7-49fbb6031e19",
"name": "设置字段",
"type": "n8n-nodes-base.set",
"position": [
1000,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "1744510d-7ed7-46d8-acd3-f975ab73f298",
"name": "active",
"type": "boolean",
"value": "={{ $json.active }}"
},
{
"id": "7e76f5dc-0c32-4b26-a289-975155b80112",
"name": "url",
"type": "string",
"value": "={{ $vars.instance_url }}workflow/{{ $json.id }}"
},
{
"id": "a7b069bf-8090-4dca-a432-f4fd7aa84e6f",
"name": "errorWorkflow",
"type": "boolean",
"value": "={{ !!$json.settings?.errorWorkflow }}"
},
{
"id": "0bff7a9b-0860-4552-b0f6-5fc279fc75d6",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "3065ee2f-d1bb-42b7-b341-7bb38b0f6720",
"name": "updatedAt",
"type": "string",
"value": "={{ $json.updatedAt }}"
},
{
"id": "ea9d39e4-50ca-4c79-b6ab-8b22cafd0257",
"name": "createdAt",
"type": "string",
"value": "={{ $json.createdAt }}"
},
{
"id": "265d66cd-1796-40eb-ae5b-dca8d1a91871",
"name": "envId",
"type": "string",
"value": "=internal-{{ $json.id }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "4527dc91-bad5-4214-b210-ea8f89504fbf",
"name": "使用工作流 ID 获取 Notion 页面",
"type": "n8n-nodes-base.httpRequest",
"position": [
1220,
340
],
"parameters": {
"url": "https://api.notion.com/v1/databases/fa25c53eac9a416eab3961b2f5c0c647/query",
"method": "POST",
"options": {},
"jsonBody": "={\n \"filter\": { \"and\": [\n {\n \"property\": \"env id\",\n \"rich_text\": { \"contains\": \"{{ $json.envId }}\" }\n }]\n}\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Notion-Version",
"value": "2022-06-28"
}
]
},
"nodeCredentialType": "notionApi"
},
"credentials": {
"notionApi": {
"id": "1exvaAn7wzyBgkXZ",
"name": "Nik's Notion Cred"
}
},
"typeVersion": 4.1
},
{
"id": "ced49644-b18f-4984-8dfd-199d88e3ded7",
"name": "映射字段",
"type": "n8n-nodes-base.set",
"position": [
1440,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "49092f3a-7f42-4067-b8ea-1073ef1d1bb8",
"name": "input",
"type": "object",
"value": "={{ $('Set fields').item.json }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.3
},
{
"id": "b890dacf-2ac2-4802-b96a-5097119d35ee",
"name": "如果是新添加的工作流",
"type": "n8n-nodes-base.if",
"position": [
1660,
340
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "88337d36-8cf6-4cd5-bec1-5123cf612934",
"operator": {
"type": "array",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.results }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "86edfe55-9a88-49ed-82de-df0c44a65d53",
"name": "添加到 Notion",
"type": "n8n-nodes-base.notion",
"position": [
1920,
240
],
"parameters": {
"title": "={{ $json.input.name }}",
"options": {},
"resource": "databasePage",
"databaseId": {
"__rl": true,
"mode": "list",
"value": "fa25c53e-ac9a-416e-ab39-61b2f5c0c647",
"cachedResultUrl": "https://www.notion.so/fa25c53eac9a416eab3961b2f5c0c647",
"cachedResultName": "Workflows maintained"
},
"propertiesUi": {
"propertyValues": [
{
"key": "env id|rich_text",
"textContent": "={{ $json.input.envId }}"
},
{
"key": "URL (dev)|url",
"urlValue": "={{ $json.input.url }}"
},
{
"key": "isActive (dev)|checkbox",
"checkboxValue": "={{ $json.input.active }}"
},
{
"key": "Workflow created at|date",
"date": "={{ $json.input.createdAt }}"
},
{
"key": "Workflow updatded at|date",
"date": "={{ $json.input.updatedAt }}"
},
{
"key": "Error workflow setup|checkbox",
"checkboxValue": "={{ $json.input.errorWorkflow }}"
}
]
}
},
"credentials": {
"notionApi": {
"id": "1exvaAn7wzyBgkXZ",
"name": "Nik's Notion Cred"
}
},
"typeVersion": 2.1
},
{
"id": "9d547270-37dd-41ee-98b7-13001c954ffa",
"name": "在 Notion 中更新",
"type": "n8n-nodes-base.notion",
"position": [
1920,
440
],
"parameters": {
"pageId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.results[0].url }}"
},
"options": {},
"resource": "databasePage",
"operation": "update",
"propertiesUi": {
"propertyValues": [
{
"key": "isActive (dev)|checkbox",
"checkboxValue": "={{ $json.input.active }}"
},
{
"key": "Name|title",
"title": "={{ $json.input.name }}"
},
{
"key": "URL (dev)|url",
"urlValue": "={{ $json.input.url }}"
},
{
"key": "isActive (dev)|checkbox",
"checkboxValue": "={{ $json.input.active }}"
},
{
"key": "Workflow updatded at|date",
"date": "={{ $json.input.updatedAt }}"
},
{
"key": "Error workflow setup|checkbox",
"checkboxValue": "={{ false }}"
}
]
}
},
"credentials": {
"notionApi": {
"id": "1exvaAn7wzyBgkXZ",
"name": "Nik's Notion Cred"
}
},
"typeVersion": 2.1
},
{
"id": "9e4d88f6-aff8-48f1-9470-8b18aae7b83a",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
540,
100
],
"parameters": {
"color": 5,
"width": 445.6145160912248,
"height": 193.68880276091272,
"content": "### 👨🎤 设置"
},
"typeVersion": 1
},
{
"id": "c212f6ec-22e3-41cf-b1a5-03f261715444",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1000,
540
],
"parameters": {
"color": 7,
"width": 368.0997057335963,
"height": 80,
"content": "### 👆 设置实例 URL 而不是 `{{ $vars.instance_url }}`（或者如果您有该功能，请设置环境变量）"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Map fields": {
"main": [
[
{
"node": "if newly added workflow",
"type": "main",
"index": 0
}
]
]
},
"Set fields": {
"main": [
[
{
"node": "Get notion page with workflow id",
"type": "main",
"index": 0
}
]
]
},
"Every 15 minutes": {
"main": [
[
{
"node": "Get all workflows with tag",
"type": "main",
"index": 0
}
]
]
},
"if newly added workflow": {
"main": [
[
{
"node": "Add to Notion",
"type": "main",
"index": 0
}
],
[
{
"node": "Update in Notion",
"type": "main",
"index": 0
}
]
]
},
"Get all workflows with tag": {
"main": [
[
{
"node": "Set fields",
"type": "main",
"index": 0
}
]
]
},
"Get notion page with workflow id": {
"main": [
[
{
"node": "Map fields",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 其他
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
任意RSS源转邮件
将任意RSS源转换为邮件
If
Set
Gmail
+6
10 节点Mutasem
其他
双向同步 Google 通讯录与 Notion
双向同步 Google 通讯录与 Notion
If
Set
Merge
+9
82 节点Solomon
其他
每小时重试执行
自动重试引擎：错误恢复工作流
If
N8n
Set
+6
14 节点Francis Njenga
其他
将工作流备份到 Gitea 上的 git 仓库
备份工作流到 Gitea 上的 git 仓库
If
N8n
Set
+5
20 节点Octoleo
其他
备份工作流到 GitHub（子文件夹）
备份工作流到 GitHub（子文件夹）
If
N8n
Set
+12
25 节点Nazmy
其他
备份工作流到 GitHub
备份工作流到 GitHub
If
N8n
Set
+12
23 节点Solomon
其他
