使用Telegram、Redis缓存和Google Sheets管理用户认证
中级
这是一个Engineering领域的自动化工作流，包含 15 个节点。主要使用 Set, Code, Merge, Redis, Switch 等节点。 使用Telegram、Redis缓存和Google Sheets管理用户认证
前置要求
- •Redis 服务器连接信息
- •Google Sheets API 凭证
- •Telegram Bot Token
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "wQIlBiGuRAehquVv",
"meta": {
"instanceId": "933df83c84196d70ce3ffd0bf5d3e1aca31b7366f2f84e1f3482640096e4a3a9",
"templateCredsSetupCompleted": true
},
"name": "登录系统",
"tags": [],
"nodes": [
{
"id": "47ba2270-9e4d-4bf1-a3c5-c68e2e810065",
"name": "获取消息",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-160,
800
],
"webhookId": "36b5c727-a6f8-4fee-9055-c9ad06b93a38",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "2ab85c19-5f38-49de-b6a6-316c621705f6",
"name": "查找用户",
"type": "n8n-nodes-base.googleSheets",
"position": [
560,
600
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "3dcd8b09-cb74-439b-80aa-87c7994e65b1",
"name": "是否为新用户",
"type": "n8n-nodes-base.switch",
"position": [
760,
600
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "9e20fe5b-c5e0-4b94-8262-01dd022ff0e7",
"name": "获取用户ID",
"type": "n8n-nodes-base.code",
"position": [
920,
780
],
"parameters": {},
"typeVersion": 2
},
{
"id": "17f198c5-7a18-4661-b299-3cac28804b99",
"name": "创建用户",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
780
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ae42ce20-dd11-4ae3-8036-3d424cac004b",
"name": "用户ID",
"type": "n8n-nodes-base.merge",
"position": [
1500,
900
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "d70a4151-887d-475b-baeb-9588be242929",
"name": "查找缓存用户",
"type": "n8n-nodes-base.redis",
"position": [
60,
1040
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c930bee8-2e8c-4eab-9a59-56ee1cb9349e",
"name": "是否已缓存",
"type": "n8n-nodes-base.switch",
"position": [
280,
1040
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4896c86b-42f8-4b18-899b-f4353ef397ac",
"name": "缓存用户",
"type": "n8n-nodes-base.redis",
"position": [
1120,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "07465c66-6b72-4870-b02d-156e32f551ab",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
420
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "715e7922-e3fc-40cb-8a00-207c2ac08861",
"name": "当由另一个工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-160,
600
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5de97977-1128-42f7-9b96-075dd9662e1e",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-160,
1040
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "5e68c21d-51f2-4a61-803b-5aff05007d3c",
"name": "获取用户",
"type": "n8n-nodes-base.googleSheets",
"position": [
60,
600
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "da473a91-2c5b-4d6d-b850-4c35a1426625",
"name": "获取简报",
"type": "n8n-nodes-base.set",
"position": [
60,
800
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "642b0052-8987-4c09-b926-5382e37ddc02",
"name": "编辑字段2",
"type": "n8n-nodes-base.set",
"position": [
320,
600
],
"parameters": {},
"typeVersion": 3.4
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "c91fe9b2-0dd1-4aeb-a3d5-37e962b09495",
"connections": {
"5de97977-1128-42f7-9b96-075dd9662e1e": {
"main": [
[
{
"node": "d70a4151-887d-475b-baeb-9588be242929",
"type": "main",
"index": 0
}
]
]
},
"ae42ce20-dd11-4ae3-8036-3d424cac004b": {
"main": [
[]
]
},
"5e68c21d-51f2-4a61-803b-5aff05007d3c": {
"main": [
[
{
"node": "642b0052-8987-4c09-b926-5382e37ddc02",
"type": "main",
"index": 0
}
]
]
},
"2ab85c19-5f38-49de-b6a6-316c621705f6": {
"main": [
[
{
"node": "3dcd8b09-cb74-439b-80aa-87c7994e65b1",
"type": "main",
"index": 0
}
]
]
},
"c930bee8-2e8c-4eab-9a59-56ee1cb9349e": {
"main": [
[
{
"node": "2ab85c19-5f38-49de-b6a6-316c621705f6",
"type": "main",
"index": 0
}
],
[
{
"node": "ae42ce20-dd11-4ae3-8036-3d424cac004b",
"type": "main",
"index": 2
}
]
]
},
"4896c86b-42f8-4b18-899b-f4353ef397ac": {
"main": [
[
{
"node": "ae42ce20-dd11-4ae3-8036-3d424cac004b",
"type": "main",
"index": 0
}
]
]
},
"9e20fe5b-c5e0-4b94-8262-01dd022ff0e7": {
"main": [
[
{
"node": "17f198c5-7a18-4661-b299-3cac28804b99",
"type": "main",
"index": 0
}
]
]
},
"17f198c5-7a18-4661-b299-3cac28804b99": {
"main": [
[
{
"node": "ae42ce20-dd11-4ae3-8036-3d424cac004b",
"type": "main",
"index": 1
}
]
]
},
"da473a91-2c5b-4d6d-b850-4c35a1426625": {
"main": [
[
{
"node": "5de97977-1128-42f7-9b96-075dd9662e1e",
"type": "main",
"index": 1
}
]
]
},
"47ba2270-9e4d-4bf1-a3c5-c68e2e810065": {
"main": [
[
{
"node": "da473a91-2c5b-4d6d-b850-4c35a1426625",
"type": "main",
"index": 0
}
]
]
},
"3dcd8b09-cb74-439b-80aa-87c7994e65b1": {
"main": [
[
{
"node": "4896c86b-42f8-4b18-899b-f4353ef397ac",
"type": "main",
"index": 0
}
],
[
{
"node": "9e20fe5b-c5e0-4b94-8262-01dd022ff0e7",
"type": "main",
"index": 0
}
]
]
},
"642b0052-8987-4c09-b926-5382e37ddc02": {
"main": [
[
{
"node": "5de97977-1128-42f7-9b96-075dd9662e1e",
"type": "main",
"index": 0
}
]
]
},
"d70a4151-887d-475b-baeb-9588be242929": {
"main": [
[
{
"node": "c930bee8-2e8c-4eab-9a59-56ee1cb9349e",
"type": "main",
"index": 0
}
]
]
},
"715e7922-e3fc-40cb-8a00-207c2ac08861": {
"main": [
[
{
"node": "5e68c21d-51f2-4a61-803b-5aff05007d3c",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 工程
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
每日验证商业创意：使用 n8n 和 Upwork
每日验证商业创意：使用 n8n 和 Upwork
Set
Merge
Filter
+
Set
Merge
Filter
20 节点Archit Jain
产品
基于Telegram、Google Sheets和OpenAI
基于Telegram、Google Sheets和OpenAI的AI驱动收据和支出追踪器
If
Set
Code
+
If
Set
Code
50 节点Khairul Muhtadin
财务
API架构提取器
API架构提取器
If
Set
Code
+
If
Set
Code
88 节点Polina Medvedieva
工程
使用Telegram、Google表格和AI创建产品满意度调查
通过Telegram、Google表格和AI创建产品满意度调查
If
Set
Redis
+
If
Set
Redis
40 节点Jimleuk
工程
竞争对手Facebook广告分析
使用Gemini和Open AI进行Facebook广告竞争分析
Set
Wait
Merge
+
Set
Wait
Merge
18 节点Archit Jain
人工智能
使用 GPT、Tavily 搜索和 Google Sheets 生成深度研究
使用 GPT、Tavily 搜索和 Google Sheets 生成深度研究 Markdown 报告
Set
Code
Merge
+
Set
Code
Merge
36 节点Archit Jain
构建模块
