已发送 - 访问权限
高级
这是一个Miscellaneous领域的自动化工作流，包含 19 个节点。主要使用 If, Filter, Notion, Switch, Airtable 等节点。 基于用户权限数据库的 Telegram 聊天访问控制
前置要求
- •Notion API Key
- •Airtable API Key
- •Telegram Bot Token
- •Google Sheets API 凭证
- •Slack Bot Token 或 Webhook URL
使用的节点 (19)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ZwLdirMz7WaPuc9u",
"meta": {
"instanceId": "abeb4de6795125f40ad5de96d2a952a3dd8b9999a00fda0c983edb96a5a49cc6",
"templateCredsSetupCompleted": true
},
"name": "已发送 - 访问权限",
"tags": [],
"nodes": [
{
"id": "c9472226-bbf2-48a8-b504-c2e0bac6fedc",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
-48,
-96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "032bed96-34be-465f-90fd-a7e9c9fe4982",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1184,
-112
],
"parameters": {
"height": 384,
"content": "## 输入数据"
},
"typeVersion": 1
},
{
"id": "8182317e-d432-48b4-ae2f-133200e4fdb2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-912,
-112
],
"parameters": {
"height": 384,
"content": "## 员工列表表格"
},
"typeVersion": 1
},
{
"id": "c04f2648-5327-46d3-a49f-d88f85922ce5",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-112
],
"parameters": {
"height": 384,
"content": "## 员工访问过滤器"
},
"typeVersion": 1
},
{
"id": "bf553e89-9301-48c1-93b7-c5ebe2ee302f",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
-112
],
"parameters": {
"height": 384,
"content": "## 访问被拒绝时的响应"
},
"typeVersion": 1
},
{
"id": "4f8ca4cb-f15d-4743-8b26-76fee1e8478c",
"name": "权限",
"type": "n8n-nodes-base.switch",
"position": [
-576,
96
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Granted",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f697ce64-74f6-4e00-a6e5-24107113995f",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Access }}",
"rightValue": "Granted"
}
]
},
"renameOutput": true
},
{
"outputKey": "Denied",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6ff5cad5-7ae5-40f6-8d67-a25b8951167d",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Access }}",
"rightValue": "Denied"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.3
},
{
"id": "f4f8be63-6023-4ea8-8f5f-3a8c67f75d42",
"name": "拒绝回答",
"type": "n8n-nodes-base.telegram",
"position": [
-304,
112
],
"webhookId": "46c3b238-25d1-4709-9a8a-3fc216dfa24d",
"parameters": {
"text": "Access dinied",
"chatId": "={{ $('Input Data').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "HJQKfpYJoO6wuDRR",
"name": "Test"
}
},
"typeVersion": 1.2
},
{
"id": "8a0a7195-0cd0-4f10-8d63-a8f275b6f869",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
336
],
"parameters": {
"color": 2,
"width": 640,
"height": 528,
"content": "## 描述"
},
"typeVersion": 1
},
{
"id": "538d0040-d075-4350-b888-8e75a85724bc",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
-112
],
"parameters": {
"color": 2,
"width": 640,
"height": 416,
"content": "## [视频教程](https://youtu.be/Blm7iamYaoA)"
},
"typeVersion": 1
},
{
"id": "e6a0b869-8c90-4a91-8301-fc3290c005be",
"name": "Telegram 触发器",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-1120,
96
],
"webhookId": "2e92d4dd-8ecb-4b1a-ba46-06bb10db2bc3",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "HJQKfpYJoO6wuDRR",
"name": "Test"
}
},
"typeVersion": 1.2
},
{
"id": "aa1bada5-b182-4ddc-855a-9bcdf413f30c",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1184,
304
],
"parameters": {
"color": 7,
"width": 848,
"height": 576,
"content": "## 可应用于"
},
"typeVersion": 1
},
{
"id": "0b0798a7-9672-444b-b909-b70b59a4672f",
"name": "Slack 触发器",
"type": "n8n-nodes-base.slackTrigger",
"position": [
-1136,
400
],
"webhookId": "3ada6a40-b42d-4175-a4ff-f208a8cae962",
"parameters": {
"options": {},
"trigger": [
"any_event"
],
"channelId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"typeVersion": 1
},
{
"id": "947b90c3-75e4-48ea-bfd5-ff7e51d51f5a",
"name": "获取工作表中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-848,
336
],
"parameters": {
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "PO5jjOqRb3T4m5PE",
"name": "Google Sheets EGM"
}
},
"typeVersion": 4.7
},
{
"id": "6b3daa96-e27d-4808-905d-95f68fb1cde6",
"name": "获取记录",
"type": "n8n-nodes-base.airtable",
"position": [
-848,
496
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": ""
},
"table": {
"__rl": true,
"mode": "list",
"value": ""
},
"options": {}
},
"typeVersion": 2.1
},
{
"id": "ad4f0fc1-6dea-4c04-ae52-0036b9b38480",
"name": "获取数据库页面",
"type": "n8n-nodes-base.notion",
"position": [
-848,
672
],
"parameters": {
"pageId": {
"__rl": true,
"mode": "url",
"value": ""
},
"resource": "databasePage",
"operation": "get"
},
"credentials": {
"notionApi": {
"id": "EddmMwhQbDV4V3oj",
"name": "Notion Archive"
}
},
"typeVersion": 2.2
},
{
"id": "0fecf591-9ac2-4682-9fb2-dd9c306cc301",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-576,
416
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "34636f26-6207-4687-9e42-2bac831c57a8",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "506988e7-e20e-47a3-9425-06e2acfc02d3",
"name": "筛选器",
"type": "n8n-nodes-base.filter",
"position": [
-576,
608
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b52c63b1-9c33-4a06-8c12-7b1f5e39dd35",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "fb2f871f-d2cb-48d3-bb67-2c3dd235006f",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2512,
-400
],
"parameters": {
"width": 640,
"height": 1264,
"content": "## 操作说明"
},
"typeVersion": 1
},
{
"id": "11357eba-2ed4-4739-b273-84fb2cc6a5f8",
"name": "员工数据库",
"type": "n8n-nodes-base.dataTable",
"position": [
-848,
96
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "UserName",
"keyValue": "={{ $json.message.from.username }}"
}
]
},
"operation": "get",
"dataTableId": {
"__rl": true,
"mode": "id",
"value": "59g2BfS1TctO7gzg"
}
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ff6351b4-120f-481d-a15a-ef1a168b646a",
"connections": {
"If": {
"main": [
[]
]
},
"Permission": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Answer Denied",
"type": "main",
"index": 0
}
]
]
},
"Get a record": {
"main": [
[]
]
},
"Slack Trigger": {
"main": [
[]
]
},
"Telegram Trigger": {
"main": [
[
{
"node": "Database with employees",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[]
]
},
"Database with employees": {
"main": [
[
{
"node": "Permission",
"type": "main",
"index": 0
}
],
[]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 杂项
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于角色的访问控制（RBAC）用于Telegram自动化
Telegram自动化的基于角色访问控制（RBAC）
If
Filter
Notion
+10
28 节点Yehor EGMS
杂项
使用Gemini AI视觉分析与Telegram警报监控X平台品牌提及
使用Gemini AI视觉分析与Telegram警报监控X平台品牌提及
If
Set
Code
+13
24 节点Atta
杂项
n8n自动化Twitter回复机器人工作流
n8n自动化Twitter回复机器人工作流
If
Set
Code
+17
55 节点Max
杂项
Telegram 语音消息_音频转录--> AI 摘要和情感分析--> Gmail 投递
使用 AssemblyAI 和 GPT-4.1 转录分析 Telegram 语音消息并发送至 Gmail
If
Wait
Gmail
+7
17 节点Sridevi Edupuganti
杂项
转录-Telegram-模板
使用 Whisper 和 Gemini 转录 Telegram 语音消息，含备用机制
If
Set
Code
+6
33 节点Yehor EGMS
文档提取
AI邮件分诊与GPT-4警报系统及Telegram通知
AI邮件分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+22
104 节点Peter Joslyn
客户支持
工作流信息
难度等级
高级
节点数量19
分类1
节点类型12
作者
Yehor EGMS
@egm-systemsBusiness Automation & E-commerce Expert | Founder & Entrepreneur | N8n.io & Make.com Specialist | Automate >80% of routine tasks — helping businesses reduce costs and accelerate processes
外部链接
在 n8n.io 查看 →
分享此工作流