n8n 终端
中级
这是一个Document Extraction, Multimodal AI领域的自动化工作流,包含 9 个节点。主要使用 Webhook, DateTimeTool, GoogleSheets, Agent, GoogleSheetsTool 等节点。 基于 Google Gemini 和 Google Sheets 的智能发货优先级排序
前置要求
- •HTTP Webhook 端点(n8n 会自动生成)
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (9)
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "TEMPLATE_ID",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "n8n 终端",
"tags": [],
"nodes": [
{
"id": "3199f6ce-dacc-4749-b2ee-cf644d83abb5",
"name": "按钮",
"type": "n8n-nodes-base.webhook",
"position": [
60,
0
],
"webhookId": "REPLACE_WITH_WEBHOOK_ID",
"parameters": {
"path": "REPLACE_WITH_PATH",
"options": {},
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "5dd0c8d7-fb91-486a-a0b6-223d01bd6727",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
280,
0
],
"parameters": {
"text": "Select priority shipping. Answer with Json with idEnvio, nombre, direccion and detalle",
"options": {
"systemMessage": "=You are an assistant with access to these tools:\nDate and Time\nShipping sheet\n\nYour mission is to select one sheet row for next shipment.\n\nPriority order is oldest fechaOrden, but if the customer says that it could cancel in detalle column, that is priority."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "12572d7a-a0e4-4aea-9f71-f59ac41829b5",
"name": "日期与时间",
"type": "n8n-nodes-base.dateTimeTool",
"position": [
440,
300
],
"parameters": {
"options": {}
},
"typeVersion": 2
},
{
"id": "998c2ccb-8237-4e15-a7ce-1a2b877f10c1",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
800,
300
],
"parameters": {
"jsonSchemaExample": "{\n\t\"idEnvio\": \"1\",\n \"nombre\": \"John Doe\",\n\t\"direccion\": \"8345 NW 55 st\",\n \"detalle\": \"I need it today\"\n}"
},
"typeVersion": "1.3"
},
{
"id": "3e045185-102b-4705-b1cb-3c019484e1fd",
"name": "Gemini Flash 2.5",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
220,
300
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.5-flash-lite"
},
"credentials": {},
"typeVersion": 1
},
{
"id": "801cbafc-97be-4a14-9d06-eb971e2f1981",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
280,
-200
],
"parameters": {
"content": "## n8n 终端"
},
"typeVersion": 1
},
{
"id": "41fdd632-92a9-4d43-872c-59986720fe11",
"name": "更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
-60
],
"parameters": {
"columns": {
"value": {
"enviado": "X",
"idEnvio": "={{ $node[\"AI Agent\"].json[\"output\"][\"idEnvio\"] }}"
},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [
"idEnvio"
]
},
"options": {},
"operation": "update",
"sheetName": {
"value": "REPLACE_WITH_SHEET_NAME"
},
"documentId": {
"value": "REPLACE_WITH_DOC_ID"
}
},
"credentials": {},
"typeVersion": "4.6"
},
{
"id": "22d24aee-9c7c-4760-89fe-0b1cf5df5470",
"name": "屏幕",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
880,
100
],
"parameters": {
"options": {},
"respondWith": "allIncomingItems"
},
"typeVersion": "1.4"
},
{
"id": "1de34a45-f608-4fd9-bd0b-cf16ec17dda9",
"name": "运输",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
620,
300
],
"parameters": {
"options": {},
"sheetName": {
"value": "REPLACE_WITH_SHEET_NAME"
},
"documentId": {
"value": "REPLACE_WITH_DOC_ID"
},
"descriptionType": "manual",
"toolDescription": "Shipments sheet"
},
"credentials": {},
"typeVersion": "4.6"
}
],
"active": true,
"settings": {
"executionOrder": "v1"
},
"versionId": "TEMPLATE_VERSION_ID",
"connections": {
"Button": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Update",
"type": "main",
"index": 0
},
{
"node": "Screen",
"type": "main",
"index": 0
}
]
]
},
"Shipping": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Date & Time": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Gemini Flash 2.5": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 文档提取, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用Gemini AI进行自然语言Google Sheets数据分析
使用Gemini AI进行自然语言Google Sheets数据分析
Switch
Aggregate
Summarize
+9
22 节点Robert Breen
文档提取
AI Retro Console 上传
多服务终端:通过Gemini AI访问Gmail、X、Telegram和新闻
Webhook
Gmail Tool
Twitter Tool
+10
14 节点Roni Bandini
个人效率
基于Google Gemini、Notion和Telegram的统一业务编排器(CEO专用)
基于Google Gemini、Notion和Telegram的统一业务编排器(CEO专用)
Set
Notion
Switch
+18
93 节点YungCEO
AI 聊天机器人
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
我的工作流 7
基于Google Gemini与WHMCS的虚拟主机AI客服聊天解决方案
Webhook
Agent
Http Request Tool
+5
15 节点Muhammad Omer Fayyaz
AI RAG 检索增强
构建用于Slack候选人评估的AI驱动聊天机器人
AI简历分析与候选人评估:Slack和Google表格集成
If
Code
Slack
+12
29 节点Trung Tran
AI 聊天机器人
工作流信息
难度等级
中级
节点数量9
分类2
节点类型9
作者
Roni Bandini
@bandiniExploring the intersection of technology, subversion, and creative resistance. My work focuses on TinyML prototypes and LLM projects, pushing the boundaries of AI and embedded systems.
外部链接
在 n8n.io 查看 →
分享此工作流