商业AI指挥中心:Google Workspace模块化代理、向量搜索与多渠道报告

高级

这是一个Document Extraction、AI Chatbot领域的自动化工作流,包含 80 个节点。主要使用 Set、Gmail、Slack、Switch、Markdown 等节点。 商业AI指挥中心:Google Workspace模块化代理、向量搜索与多渠道报告

前置要求
  • Google 账号和 Gmail API 凭证
  • Slack Bot Token 或 Webhook URL
  • Telegram Bot Token
  • Google Drive API 凭证
  • PostgreSQL 数据库连接信息
  • 可能需要目标 API 的认证凭证
  • OpenAI API Key
  • Google Sheets API 凭证
  • Anthropic API Key
  • Supabase URL 和 API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "e7ccf4281d5afb175c79c02db95b45f15d5b53862cb6bc357c5e5bc26567f35c"
  },
  "nodes": [
    {
      "id": "0a7f8501-c9a7-47d6-b6b9-1a32de661ce0",
      "name": "Google Sheets - 读取数据",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "📊 READ SPREADSHEET DATA\n\nRetrieve and analyze data from Google Sheets. Perfect for AI to read, process, and extract insights from spreadsheet content.\n\nUse Cases:\n• \"Read data from the Sales sheet\"\n• \"Get all entries from A1:E100\"\n• \"Show me the data in the Budget spreadsheet\"\n• \"Extract customer information from the CRM sheet\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• Sheet_Name: Specific sheet tab name\n• Range: Cell range to read (optional)",
      "position": [
        3024,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "e18d26cf-8208-45ca-8e6e-fdb83e1127ba",
      "name": "Google Sheets - 清除数据",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "🗑️ CLEAR SPREADSHEET DATA\n\nRemove data from specific ranges or entire sheets. Useful for resetting data, clearing temporary calculations, or preparing sheets for new data.\n\nUse Cases:\n• \"Clear all data from the temp sheet\"\n• \"Remove entries from A1:E100\"\n• \"Clean up the old data in column C\"\n• \"Reset the calculation area\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• Sheet_Name: Sheet to clear data from\n• Range: Specific range to clear\n\n⚠️ Use with caution - data will be permanently removed!",
      "position": [
        3136,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5f24bc02-2510-4dcf-b2f2-b32d114fdda8",
      "name": "Google Sheets - 添加数据",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "➕ ADD NEW DATA\n\nAppend new rows of data to existing sheets. Perfect for adding records, logging events, or inserting new entries without affecting existing data.\n\nUse Cases:\n• \"Add a new customer to the CRM sheet\"\n• \"Log today's sales data\"\n• \"Insert a new project entry\"\n• \"Record the meeting notes\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• Sheet_Name: Sheet to add data to\n• Data_To_Add: Array/object of new data\n\nFeatures:\n• Automatically finds next empty row\n• Preserves existing data\n• Supports multiple columns",
      "position": [
        3264,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "4018894e-21d2-4c01-93aa-03132bdd423c",
      "name": "Google Sheets - 创建工作表",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "📋 CREATE NEW SHEET\n\nCreate new worksheet tabs within existing spreadsheets. Great for organizing data into categories or creating project-specific sheets.\n\nUse Cases:\n• \"Create a new sheet called 'Q4 Sales'\"\n• \"Add a Project Timeline sheet\"\n• \"Make a new Budget 2024 tab\"\n• \"Create a sheet for customer feedback\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• New_Sheet_Name: Name for the new sheet\n• Header_Row: Optional column headers\n\nBest Practices:\n• Use descriptive sheet names\n• Include header rows for data structure\n• Consider sheet organization strategy",
      "position": [
        3408,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "7d2702dd-3bef-4165-8568-0574491bad0f",
      "name": "Google Sheets - 更新数据",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "✏️ UPDATE EXISTING DATA\n\nModify specific cells or ranges with new values. Perfect for updating records, correcting data, or maintaining current information.\n\nUse Cases:\n• \"Update the status in cell C5 to 'Complete'\"\n• \"Change the price in the product list\"\n• \"Modify the project deadline\"\n• \"Update customer contact information\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• Sheet_Name: Sheet containing data to update\n• Range: Specific cells to update (e.g., A1:B2)\n• New_Values: Array of new values\n\nTip: Use precise ranges to avoid overwriting unintended data",
      "position": [
        3680,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5567f996-6f8e-4abd-9a34-e0e1dcfbb1c2",
      "name": "Google Sheets - 删除工作表",
      "type": "n8n-nodes-base.googleSheetsTool",
      "notes": "🗑️ DELETE SHEET\n\nRemove entire worksheet tabs when they're no longer needed. Use with caution as this permanently removes all data in the sheet.\n\nUse Cases:\n• \"Delete the old temp sheet\"\n• \"Remove the expired project tab\"\n• \"Clean up test worksheets\"\n• \"Delete duplicate sheets\"\n\nAI Parameters:\n• Document_ID: Target spreadsheet ID\n• Sheet_Name: Sheet tab to delete\n\n⚠️ PERMANENT ACTION - Cannot be undone!\nAlways backup important data first.",
      "position": [
        3536,
        -352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "ebdfd923-6296-4252-b2b4-52364324cb8d",
      "name": "MCP Server Sheets",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "notes": "🚀 MCP TRIGGER\n\nThis is the entry point for AI interactions with Google Sheets. The MCP (Model Context Protocol) trigger allows AI models to call any of the connected Google Sheets tools based on user requests.\n\nKey Features:\n• Enables natural language spreadsheet commands\n• Routes AI requests to appropriate Sheets operations\n• Provides context-aware data management\n• Supports complex multi-step data workflows\n• Handles dynamic sheet and document selection",
      "position": [
        3024,
        -768
      ],
      "webhookId": "f0a1fd29-3717-4827-a4d8-ad975f43c401",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "f9a2e5b2-6911-4a06-a253-f32af17fd2f5",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        3056,
        192
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "44fa0faf-4d15-4d40-b8c5-2f2bda41b057",
      "name": "下载文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        3264,
        192
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "c90553f9-65b4-4284-8453-ec2b5112c7e0",
      "name": "默认数据加载器1",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        3616,
        416
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "268a3365-4f6b-49fb-b599-408e0c66f26e",
      "name": "递归字符文本分割器1",
      "type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
      "position": [
        3696,
        624
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "80a67e90-3b0c-468d-aabd-f0d473db5c8b",
      "name": "添加到 Supabase 向量数据库",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        3504,
        192
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "a6de1318-7101-4358-8610-f45cd659001e",
      "name": "Embeddings OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        3488,
        416
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "5fcd1395-3f14-45c4-b0ae-0eea0f97e0ac",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2928,
        1344
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5012eb86-62b4-4e0a-adb4-19045ad3d93e",
      "name": "当由另一个工作流执行时",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        3360,
        1840
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "14417687-e3fa-4ab8-9c8b-8e9b6c15e673",
      "name": "Google Drive MCP Server",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        2960,
        1456
      ],
      "webhookId": "a289c719-fb71-4b08-97c6-79d12645dc7e",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fd659c06-c670-4baf-a668-bef56ec31de1",
      "name": "下载文件1",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        3712,
        1840
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "7db762ea-339b-4d17-b57e-249634ad055c",
      "name": "文件类型",
      "type": "n8n-nodes-base.switch",
      "position": [
        3904,
        1792
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "0b5e8931-4151-4e41-acc0-c75a62ade255",
      "name": "操作",
      "type": "n8n-nodes-base.switch",
      "position": [
        3536,
        1840
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "e49c8cc0-279c-49d9-9699-a807a1173eea",
      "name": "从 PDF 提取",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        4176,
        1552
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a5318ca9-b843-44f6-9477-b2850811f091",
      "name": "从 CSV 提取",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        4176,
        1744
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a6afcc29-7c24-45a5-91f9-fd0362ee850a",
      "name": "获取 PDF 响应",
      "type": "n8n-nodes-base.set",
      "position": [
        4336,
        1552
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "d8fc6b8c-b03c-4917-8f2a-e9f7ce6ea0db",
      "name": "获取 CSV 响应",
      "type": "n8n-nodes-base.set",
      "position": [
        4336,
        1744
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3.4
    },
    {
      "id": "99feec0e-c0da-40cc-af57-34496d15fb15",
      "name": "从 GDrive 读取文件",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        3216,
        1648
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "d6ce37d1-c35c-41cb-8f39-b9195d80d353",
      "name": "从 GDrive 搜索文件",
      "type": "n8n-nodes-base.googleDriveTool",
      "position": [
        3024,
        1680
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "d6b0d109-47ce-4807-8615-b66a5613f6ca",
      "name": "分析图像",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        4176,
        1920
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "2fe752f2-edcc-42c0-8795-25f9ac1579bd",
      "name": "转录音频",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        4176,
        2096
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "b1707a09-48b6-4d2d-8dc7-02f0690fbd41",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3344,
        1280
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2736696c-16ed-4102-a348-d0019559161f",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3328,
        1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "32c8178e-f0dd-4034-906a-f1b630b38c62",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2960,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b6849af3-6062-4368-8994-ca376479a5e0",
      "name": "Postgres 聊天记忆1",
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
      "position": [
        848,
        496
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "0277def2-25e8-4e48-ab60-ad19fb68df39",
      "name": "Embeddings OpenAI2",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        2224,
        592
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "365cdef7-f4eb-4428-b813-edb34f601f98",
      "name": "Cohere 重排序器1",
      "type": "@n8n/n8n-nodes-langchain.rerankerCohere",
      "position": [
        2416,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9877f738-e3b5-4973-a233-37255bac0cc6",
      "name": "Anthropic聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        672,
        496
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "b5e79c10-7647-4ed2-b31a-8db04024e394",
      "name": "结构化数据1",
      "type": "n8n-nodes-base.postgresTool",
      "position": [
        1280,
        528
      ],
      "parameters": {},
      "typeVersion": 2.6
    },
    {
      "id": "91baf464-fdf1-4d45-809b-6f904eff4354",
      "name": "通用知识1",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        2240,
        432
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "97f7e6af-edb6-489a-8bb9-a3da8b13018d",
      "name": "思考1",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        960,
        496
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7abfd51a-07e5-4670-b674-c0fa09536906",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fec6d805-ce61-4825-b628-f9a977e1e274",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "dfdace36-b1b6-4c00-acb5-3ec811111402",
      "name": "在 Perplexity 中向模型发送消息1",
      "type": "n8n-nodes-base.perplexityTool",
      "position": [
        1600,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "eace82ff-d393-4faa-8ae7-4e712ea64ca1",
      "name": "便签10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        736
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8b340a56-a810-41af-b148-af2fbae5c397",
      "name": "搜索 Google Drive 中的任何文档1",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        2352,
        1664
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "18d33f00-fe6a-421c-9fd3-2f0caa71f4bd",
      "name": "MCP Sheets",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        2512,
        -512
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "043e6e5d-7785-48a3-a7ee-adc5a181f1c2",
      "name": "知识代理1",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        1392,
        160
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "c243dbf0-5f81-403a-95f6-b1f99aa1adb8",
      "name": "便签11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2144,
        304
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b747ada7-a2c5-46ca-b154-a6d9680b88c1",
      "name": "便签12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2464,
        -576
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "de984cb1-b2cf-4ca5-9a10-71bd4cf115ff",
      "name": "便签13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2976,
        -880
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1329ca42-57fe-442f-b804-9c826514f621",
      "name": "推理模型(推荐)",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        400,
        -288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b2e79be6-451a-4563-9983-3a53afd7cc73",
      "name": "便签14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3360,
        1664
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d1b8b120-3a4d-485b-81cd-4740d08eef86",
      "name": "便签15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2928,
        1232
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bf2d1550-1295-4b9c-8339-381a6ca15a46",
      "name": "便签16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2256,
        1600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "270675da-a077-4603-a6fb-7c932620d3ac",
      "name": "计算器",
      "type": "@n8n/n8n-nodes-langchain.toolCalculator",
      "position": [
        1056,
        496
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e31f90fd-a807-4b15-bbbf-b6de9a5108c8",
      "name": "Postgres 聊天记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
      "position": [
        544,
        -288
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "af277a1b-9937-41c2-b4d5-2471c66b65cf",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -208,
        560
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "584ebbd9-5f20-4cd8-8435-3c6fa2db527a",
      "name": "HTTP 请求 1",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        48,
        544
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "83dd7fbc-a215-48ab-adb3-394bb7251452",
      "name": "Linkedin 爬虫",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -128,
        368
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "a32a9945-7b44-4f58-90e4-eb7c4a7227c6",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        544
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "75b1ada9-fba3-47fb-9737-5ed90d570af6",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "09061eeb-642f-4f4c-bd23-c1c6f8860e88",
      "name": "创建报告",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        2880,
        -1360
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "a5718897-37e9-4dbb-9718-f034b6448e91",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3344,
        -1616
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "937db1ac-b57d-41ed-85d6-cfb2d1801887",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        4048,
        -1424
      ],
      "webhookId": "09fb0a64-20a6-47b2-bac5-665d03919614",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "04f7da41-964f-4e6f-8806-112367683f8c",
      "name": "便签17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        -448
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7dc82c51-d8aa-4c84-80d8-2a7ed729affc",
      "name": "便签18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1952,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1d097bd2-7c7a-4541-a162-46d1bf4a5055",
      "name": "创建结构化报告",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        3328,
        -1424
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "9259bafa-ce05-4268-abfc-0d63f9b24318",
      "name": "便签19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2832,
        -1440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a4d7b366-3e1f-41c0-8df4-c1340cf07b6c",
      "name": "便签20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3184,
        -1472
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8d94e473-424a-4784-8ae8-8eed18cfd7b7",
      "name": "Markdown 转 HTML",
      "type": "n8n-nodes-base.markdown",
      "position": [
        3760,
        -1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0ab0e43e-5d25-4f73-a124-7e21e881d4a0",
      "name": "OpenRouter聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        3344,
        -1216
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6f1fb114-1a5e-4fad-8235-39ba94ebd46a",
      "name": "发送文本消息",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1584,
        -1344
      ],
      "webhookId": "be0f5e9f-0231-43f3-8ee7-cc02ab9ac01f",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ac745c45-7580-456e-a496-03e8f70e2ec1",
      "name": "发送消息",
      "type": "n8n-nodes-base.whatsApp",
      "disabled": true,
      "position": [
        1584,
        -1184
      ],
      "webhookId": "21ce03e2-b672-49f5-8e5e-f187a644523e",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "27025bf3-a8ba-4b50-a076-4b43dfb85f4a",
      "name": "发送消息1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1584,
        -848
      ],
      "webhookId": "39551306-44d1-45a0-947c-8ed49c46edce",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "cc5e0c42-01aa-47a5-925c-8e3063ebfcfd",
      "name": "发送消息2",
      "type": "n8n-nodes-base.slack",
      "position": [
        1584,
        -1024
      ],
      "webhookId": "1eeadb85-d39f-4373-be60-f2ba89fee6e3",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "c7c0646a-a7ae-4186-8b42-f4d83ba516ef",
      "name": "Slack 触发器",
      "type": "n8n-nodes-base.slackTrigger",
      "position": [
        256,
        -832
      ],
      "webhookId": "74ec72e0-6007-4f91-9767-245bd2822825",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9df33c1b-c682-4a36-99a5-d4190e0b73a7",
      "name": "Telegram 触发器",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        272,
        -1168
      ],
      "webhookId": "d68442bd-ea54-4190-ad36-1b413aa6efb9",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "965d5853-b0ea-4c5c-9c3d-6bf55030945f",
      "name": "Gmail 触发器",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        272,
        -1008
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "0359340e-d8d5-413b-b40e-bdf939b62a43",
      "name": "WhatsApp 触发器",
      "type": "n8n-nodes-base.whatsAppTrigger",
      "disabled": true,
      "position": [
        256,
        -640
      ],
      "webhookId": "e744ea57-9ad4-40bb-b468-bf51d8295373",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c324fb98-0529-4de7-b82a-d791d84dafd4",
      "name": "便签21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -1344
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "96832356-2ffc-41d2-aeee-14f6ab9cce2c",
      "name": "设置消息变量",
      "type": "n8n-nodes-base.set",
      "position": [
        720,
        -624
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "995f8927-d45e-46db-aacc-0f293a419602",
      "name": "主代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        912,
        -624
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "d6c6292c-0380-43f3-91cc-f999654736c4",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        -1728
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Think1": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "FileType": {
      "main": [
        [
          {
            "node": "Extract from PDF",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Extract from CSV",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Analyse Image",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Transcribe Audio",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Operation": {
      "main": [
        [
          {
            "node": "Download File1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculator": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "MAIN AGENT": {
      "main": [
        [
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send message",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message2",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MCP Sheets": {
      "ai_tool": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "Add to Supabase Vector DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "Set message variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "ai_tool": [
        [
          {
            "node": "Linkedin Scraper",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Slack Trigger": {
      "main": [
        [
          {
            "node": "Set message variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create reports": {
      "ai_tool": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Download File1": {
      "main": [
        [
          {
            "node": "FileType",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from CSV": {
      "main": [
        [
          {
            "node": "Get CSV Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from PDF": {
      "main": [
        [
          {
            "node": "Get PDF Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Knowledge Agent1": {
      "ai_tool": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Linkedin Scraper": {
      "ai_tool": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Markdown to HTML": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reranker Cohere1": {
      "ai_reranker": [
        [
          {
            "node": "General knowledge1",
            "type": "ai_reranker",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "Set message variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "WhatsApp Trigger": {
      "main": [
        [
          {
            "node": "Set message variable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "structured data1": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI1": {
      "ai_embedding": [
        [
          {
            "node": "Add to Supabase Vector DB",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI2": {
      "ai_embedding": [
        [
          {
            "node": "General knowledge1",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "General knowledge1": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Linkedin Scraper",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Default Data Loader1": {
      "ai_document": [
        [
          {
            "node": "Add to Supabase Vector DB",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "Postgres Chat Memory": {
      "ai_memory": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Set message variable": {
      "main": [
        [
          {
            "node": "MAIN AGENT",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Anthropic Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Create structured Reports",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Postgres Chat Memory1": {
      "ai_memory": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Read File From GDrive": {
      "ai_tool": [
        [
          {
            "node": "Google Drive MCP Server",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Add Data": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Search Files from Gdrive": {
      "ai_tool": [
        [
          {
            "node": "Google Drive MCP Server",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create structured Reports": {
      "main": [
        [
          {
            "node": "Markdown to HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Read Data": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Clear Data": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Update Data": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Create Sheet": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets - Delete Sheet": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Sheets",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Reasoning model (recommended)": {
      "ai_languageModel": [
        [
          {
            "node": "MAIN AGENT",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Message a model in Perplexity1": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Operation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Recursive Character Text Splitter1": {
      "ai_textSplitter": [
        [
          {
            "node": "Default Data Loader1",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "search  about any doc in google drive1": {
      "ai_tool": [
        [
          {
            "node": "Knowledge Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

这是一个高级难度的工作流,适用于Document Extraction、AI Chatbot等场景。适合高级用户,包含 16+ 个节点的复杂工作流

需要付费吗?

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

工作流信息
难度等级
高级
节点数量80
分类2
节点类型38
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者

Automation expert & n8n power user. I build advanced workflows combining AI, outbound, and business logic. Grab my templates or reach out for custom builds.

外部链接
在 n8n.io 上查看 →

分享此工作流