AppSheet 社区模板-工作流
高级
这是一个AI领域的自动化工作流，包含 25 个节点。主要使用 Set, Limit, Aggregate, HttpRequest, Agent 等节点，结合人工智能技术实现智能自动化。 AppSheet 智能查询编排器 - 查询任何数据！
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Anthropic API Key
- •Google Gemini API Key
使用的节点 (25)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "EbTFAsvfdJZBB3J5",
"meta": {
"instanceId": "28532c0819ec8862291e01fb286b386e2fa3156b644ba3d1efc7c46bdaf57519",
"templateId": "VMiAxXa3lCAizGB5f7dVZQSFfg3FtHkdTKvLuupqBls=",
"templateCredsSetupCompleted": true
},
"name": "Appsheet 社区模板-工作流",
"tags": [],
"nodes": [
{
"id": "b4e6fed9-f776-4075-83d8-090c5180fb5a",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
320,
180
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
860,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4",
"name": "AppSheet",
"type": "n8n-nodes-rifad-appsheet.appSheet",
"position": [
920,
320
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "f58c1671-396e-49d3-beed-7884d5fa5f92",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
1020,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
"name": "聚合排名",
"type": "n8n-nodes-base.set",
"position": [
1580,
-20
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8fef5f0b-d163-468f-8dc0-f09240f06021",
"name": "最终重排输出",
"type": "n8n-nodes-base.set",
"position": [
1840,
-20
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d",
"name": "Cohere 重排",
"type": "n8n-nodes-base.httpRequest",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "47e28822-19f5-40f2-b6ab-63223049e66f",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
120,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f05514c-1499-4bc9-9d4e-2c1311a29340",
"name": "获取工作表列表",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
600,
-740
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "349f36e5-634f-4141-a41c-23907144d39e",
"name": "获取表头",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
760,
-1060
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "e60a29e9-5c61-4d62-b666-195a2e822b14",
"name": "调用 Appsheet API",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
1180,
-1120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"name": "Appsheet 架构分析器",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "This agent gets input and start exploring the data and its relationships throughout the app and creates a storyline",
"onError": "continueRegularOutput",
"position": [
420,
-1260
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.7
},
{
"id": "8f1e81d0-7ace-40d6-939e-e51e9d953da3",
"name": "Anthropic 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
340,
-1060
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "75ccf02e-721c-468a-a7a4-8b8e4c7239c4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-200
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "b3debcb8-18bc-4eb5-8df1-64a5d532b8ce",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-200
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "65e9ed23-f01a-4a9e-b262-328e7b97cc8d",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-220
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "79919a4e-e7d4-49f4-a6b8-d4861a456925",
"name": "当被另一个工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-240,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "994be9b4-d4e8-4f30-a724-52d7bf9567aa",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-1700
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "e0dce744-c592-45b1-a81f-5abe9f47e2bc",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
240
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "a6fe8fe1-459c-441e-ae65-7433da62b4a8",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-140,
-1260
],
"webhookId": "e1fa302e-3f84-46a5-b90a-cb009f33a5b7",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "03dcef04-4a4c-48ab-b6f6-03b294fd83c2",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-920
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"name": "清理并结构化输入",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
60,
-20
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "eaf92dab-8aa8-431e-9662-02c03a55d796",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-1240
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "61b16043-6f64-44f7-91d8-b2500ce6a1b8",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
160
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "7c9f2bd9-7f43-408f-95e3-0f9ab3c092ca",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-1440
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "376d90d3-0560-4d3a-a1b1-0436fac53325",
"connections": {
"Limit": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"AppSheet": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Cohere Rerank",
"type": "main",
"index": 0
}
]
]
},
"GetHeaders": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"Cohere Rerank": {
"main": [
[
{
"node": "AggregateRanked",
"type": "main",
"index": 0
}
]
]
},
"AggregateRanked": {
"main": [
[
{
"node": "Final Reranked Output",
"type": "main",
"index": 0
}
]
]
},
"CallAppsheetAPI": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"GetListOfWorksheets": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"Anthropic Chat Model": {
"ai_languageModel": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Final Reranked Output": {
"main": [
[]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Cleanup and structure the input",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Cleanup and structure the input",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Appsheet Schema Analyser",
"type": "main",
"index": 0
}
]
]
},
"Cleanup and structure the input": {
"main": [
[
{
"node": "AppSheet",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Cleanup and structure the input",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
在Braze中更新现有邮件模板
使用AI为Instagram、Facebook、LinkedIn和X自动化社交媒体内容
Set
Gmail
Merge
+22
73 节点LukaszB
设计
AI邮件分诊与GPT-4警报系统及Telegram通知
AI邮件分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+22
104 节点Peter Joslyn
客户支持
博客WordPress复制销售
使用GPT-4、Perplexity AI和WordPress自动化SEO博客内容创建
Set
Code
Notion
+16
39 节点LukaszB
人工智能
自动化博客撰写与社交媒体推广代理
使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体
Set
Code
Gmail
+21
79 节点LukaszB
设计
用于 WordPress 的 AI 博客内容撰写器与图片生成器
基于GPT Image 1和Perplexity的WordPress自动化博客内容创建器
Set
Code
Notion
+16
41 节点LukaszB
人工智能
