8
n8n 中文网amn8n.com

个人助理

中级

这是一个Support, AI领域的自动化工作流，包含 11 个节点。主要使用 GmailTool, Agent, GoogleSheetsTool, ToolThink, McpTrigger 等节点，结合人工智能技术实现智能自动化。 使用OpenAI和Google表格的供应商自动邮件助手

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (11)

GmailTool
StickyNote
Agent
GoogleSheetsTool
ToolThink
McpTrigger
ChatTrigger
LmChatOpenAi
McpClientTool
MemoryBufferWindow

分类

客户支持
人工智能
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "chCFNRonfZBJVoUK",
  "meta": {
    "instanceId": "a51a10c949270e540a12639c8a3df5e1b80aa3342c96f49f7646a09c92df9d8c",
    "templateCredsSetupCompleted": true
  },
  "name": "个人助理",
  "tags": [],
  "nodes": [
    {
      "id": "f1ecb3d0-eca9-4055-966f-9afbd2ccffca",
      "name": "MCP 服务器触发器",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        -20,
        -640
      ],
      "webhookId": "cbbbcf9a-2105-4289-9874-45d3ca20dd2e",
      "parameters": {
        "path": "cbbbcf9a-2105-4289-9874-45d3ca20dd2e"
      },
      "typeVersion": 1
    },
    {
      "id": "056176ce-7aed-44e1-8c95-6545d8742d63",
      "name": "通过 Gmail 发送消息",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        300,
        -460
      ],
      "webhookId": "101ef28f-8092-4013-8f87-c5b81e9dbfa5",
      "parameters": {
        "sendTo": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('To', ``, 'string') }}",
        "message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
        "options": {},
        "subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "N9jC76TL1WVjVRW4",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "579d3a6f-8f64-4d1f-8837-ed566ffe56cc",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -620,
        -720
      ],
      "parameters": {
        "color": 4,
        "width": 1140,
        "height": 480,
        "content": "## 要实现这个供应商个人邮件助理，"
      },
      "typeVersion": 1
    },
    {
      "id": "0e3e99ef-434c-4c65-b282-6f2d267ad9f9",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -620,
        -200
      ],
      "parameters": {
        "color": 5,
        "width": 1140,
        "height": 660,
        "content": "## 这将是连接到 MCP 服务器的 AI Agent — 换句话说，它是 MCP 客户端。"
      },
      "typeVersion": 1
    },
    {
      "id": "fda2fd56-fb9b-4074-9a4f-ae14e94d95de",
      "name": "入口点：与 Agent 聊天",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -300,
        40
      ],
      "webhookId": "0a1b3beb-fe6e-4a05-9150-944517f0a65b",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "de8be0e7-2eea-43d5-9f8c-a6232986c524",
      "name": "个人邮件助理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        60,
        40
      ],
      "parameters": {
        "options": {
          "systemMessage": "=Eres mi asistente personal. Tienes acceso a diferentes herramientas (como Think y Google Sheets). Sigue estas instrucciones paso a paso para responder correctamente:\n\n1. Ejecuta la herramienta **Think** para analizar si tienes toda la información necesaria para completar la solicitud del usuario.\n2. La fecha y hora actual es: {{ $now.setZone('America/Mexico_City').toFormat('yyyy-MM-dd HH:mm') }}.\n3. Si para cumplir la solicitud del usuario necesitas el **correo de un proveedor**, búscalo usando la herramienta **Google Sheets** con el nombre del proveedor como referencia.\n4. Una vez tengas toda la información, **realiza la acción solicitada por el usuario** y responde de forma clara y directa.\n5. Si falta información o no puedes encontrarla, pide al usuario que complete lo que falta o reporta que no la encontraste.\n"
        }
      },
      "typeVersion": 1.9
    },
    {
      "id": "05ab000e-3d2c-4429-a75e-7b4db94baa03",
      "name": "AI 模型 Open AI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -160,
        260
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "QDynOcTL9yRJIEpN",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cd649882-bd30-4589-ac73-e23da4f4d16e",
      "name": "聊天记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -20,
        240
      ],
      "parameters": {
        "contextWindowLength": 20
      },
      "typeVersion": 1.3
    },
    {
      "id": "804571d9-95b1-427e-90ad-a6562c246310",
      "name": "连接到 MCP 服务器的节点。",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        120,
        260
      ],
      "parameters": {
        "sseEndpoint": "https://lucychats-n8n.jpe85q.easypanel.host/mcp/cbbbcf9a-2105-4289-9874-45d3ca20dd2e/sse"
      },
      "typeVersion": 1
    },
    {
      "id": "df1ba763-2ab5-4cc9-adf0-47f39bf6e0ec",
      "name": "思考器，在执行前思考。",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        260,
        220
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e2721ce5-6283-4c20-945f-e0e88b25514f",
      "name": "供应商数据库。",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        400,
        260
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', ``, 'string') }}",
              "lookupColumn": "Nombre del Proveedor"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8/edit#gid=0",
          "cachedResultName": "Hoja 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vFkApkyOU1npZJvl90sIZ4x8xnSXylfTjvCGhWTeOB8/edit?usp=drivesdk",
          "cachedResultName": "Proveedores"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "kbToWpEBxTdKlK78",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "517b84f6-a704-4934-87a9-d550677b7bee",
  "connections": {
    "Gmail": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Trigger",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Chat Memory": {
      "ai_memory": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "AI Model Open AI": {
      "ai_languageModel": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Supplier database.": {
      "ai_tool": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Personal Email Assistant": {
      "main": [
        []
      ]
    },
    "Entry Point: Chat with the Agent": {
      "main": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Thinker, think before executing.": {
      "ai_tool": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Node that connects to the MCP server.": {
      "ai_tool": [
        [
          {
            "node": "Personal Email Assistant",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 客户支持, 人工智能

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

构建您自己的PostgreSQL MCP服务器（无可视化界面）
使用Claude和DeepSeek的PostgreSQL对话代理（多KPI、安全）
Switch
Postgres
Postgres Tool
+10
21 节点hippolyte-hu
客户支持
个人助理 MCP 服务器
使用MCP构建集成Google Gemini、Gmail和日历的个人助理
Gmail Tool
Agent
Google Sheets Tool
+7
20 节点Aitor | 1node.ai
其他
💥 AI病毒视频生成：NanoBanana和VEO3，通过Blotato分享到社交平台 - 视频
AI个人助理：通过Telegram管理Google任务、日历、邮件和开支
Set
Filter
Switch
+15
52 节点minh
个人效率
基于AI的MIS代理
基于AI的管理信息系统代理
If
Set
Code
+29
129 节点Kumar Shivam
客户支持
WhatsApp上的Jarvis
集成OpenAI、Gmail、日历、任务和费用追踪的WhatsApp生产力助手
Set
Filter
Switch
+16
53 节点Jitesh Dugar
内容创作
客户与销售支持
智能销售支持聊天机器人（GPT-4o与Google表格）
Agent
Google Sheets Tool
Chat Trigger
+4
10 节点Babish Shrestha
销售
工作流信息
难度等级
中级
节点数量11
分类2
节点类型10
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Omar Hdez

Omar Hdez

@omarhdez
外部链接
在 n8n.io 查看 →

分享此工作流