智能邮件助手:基于AI和Supabase的客户支持自动化

高级

这是一个Support、AI领域的自动化工作流,包含 23 个节点。主要使用 Set、Switch、Supabase、GmailTool、GoogleDrive 等节点,结合人工智能技术实现智能自动化。 智能邮件助手:基于AI和Supabase的客户支持自动化

前置要求
  • Supabase URL 和 API Key
  • Google 账号和 Gmail API 凭证
  • Google Drive API 凭证
  • OpenAI API Key

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "4786bf0f18c0e8e92c361de5a158cabf4eb0bb3b9c113091b054ff26e359a029",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "c71e68fa-1901-4df7-b76f-9508213f0753",
      "name": "邮件监控器",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -760,
        -640
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "4a5d0db0-41c9-4824-80b2-6329bd1379d0",
      "name": "AI 邮件分类器",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "notes": "Uses AI to classify incoming emails as customer support or non-support",
      "position": [
        -240,
        -640
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "cb835409-ba65-406e-ba54-60d9a62c6b5d",
      "name": "路由邮件",
      "type": "n8n-nodes-base.switch",
      "notes": "Routes emails based on AI classification results",
      "position": [
        120,
        -640
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "91198514-c899-427d-9e7a-41017897390a",
      "name": "AI 回复生成器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "notes": "Generates personalized support responses using AI",
      "position": [
        620,
        -700
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "26f65176-b37a-48cb-bd77-5d02485f0a56",
      "name": "OpenAI聊天模型2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        380,
        -360
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "90b26157-6653-4f50-982f-0cfae21576bc",
      "name": "向量存储工具1",
      "type": "@n8n/n8n-nodes-langchain.toolVectorStore",
      "position": [
        880,
        -500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9ccfe80d-195e-42a9-8168-3d76d3252817",
      "name": "OpenAI Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1320,
        -240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "db7eea69-2084-49ce-940b-d90c213fef1a",
      "name": "OpenAI1 嵌入",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        680,
        -120
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4168a0fd-05e4-4db1-a0bb-119d8a60bb23",
      "name": "Supabase 向量存储",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        740,
        -300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1e71a2f2-90b9-4a34-ad67-59fdc2ee9f71",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2400,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8bbdc661-4a8b-4da6-93dc-34239eca7675",
      "name": "默认数据加载器",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        1120,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1a153c81-9322-4829-99d1-f7c862dbf5bc",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6d4520bd-d7a8-4f67-8826-d310c15e3a01",
      "name": "下载文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        460,
        440
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3
    },
    {
      "id": "4afd45d7-4d67-4fef-af05-0e6e82392742",
      "name": "文件已创建",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -580,
        340
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a3bea952-8bf0-4a86-8c31-b9042556e2ce",
      "name": "文件已更新",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -580,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "95891826-3c3e-4e77-abed-33133672eea9",
      "name": "提取文档文本",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        720,
        440
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "4cb79fec-98e2-45f3-b88f-52b5e4145b73",
      "name": "递归字符文本分割器",
      "type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
      "position": [
        1120,
        760
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ea6a2e0e-a5c4-4ee5-8c32-9e3c002a4859",
      "name": "删除旧文档行",
      "type": "n8n-nodes-base.supabase",
      "position": [
        160,
        440
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "8a3257e2-89b8-4999-8201-39af615976da",
      "name": "设置文件 ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -260,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "139d3e27-90b0-4ada-b31f-7cc98b6b089f",
      "name": "插入到 Supabase Vectorstore",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        1000,
        340
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2db8ca4f-79f6-4407-b498-3d05d3b506ac",
      "name": "OpenAI 嵌入",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        960,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "01463a9d-0781-4ee8-9649-f7210ad25dd4",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -860,
        -900
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d8fc3491-0b50-4cdb-b5bc-6cbffcd3276b",
      "name": "Create Draft",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        1440,
        -520
      ],
      "webhookId": "5f724cfa-d253-47eb-b526-bab10f444d38",
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "pinData": {},
  "connections": {
    "Route Email": {
      "main": [
        [
          {
            "node": "AI Response Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set File ID": {
      "main": [
        [
          {
            "node": "Delete Old Doc Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Draft": {
      "ai_tool": [
        [
          {
            "node": "AI Response Generator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "File Created": {
      "main": [
        [
          {
            "node": "Set File ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "File Updated": {
      "main": [
        [
          {
            "node": "Set File ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download File": {
      "main": [
        [
          {
            "node": "Extract Document Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Monitor": {
      "main": [
        [
          {
            "node": "AI Email Classifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI": {
      "ai_embedding": [
        [
          {
            "node": "Insert into Supabase Vectorstore",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI1": {
      "ai_embedding": [
        [
          {
            "node": "Supabase Vector Store",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "AI Response Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "Vector Store Tool1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Vector Store Tool1": {
      "ai_tool": [
        [
          {
            "node": "AI Response Generator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "AI Email Classifier": {
      "main": [
        [
          {
            "node": "Route Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Default Data Loader": {
      "ai_document": [
        [
          {
            "node": "Insert into Supabase Vectorstore",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "Delete Old Doc Rows": {
      "main": [
        [
          {
            "node": "Download File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Document Text": {
      "main": [
        [
          {
            "node": "Insert into Supabase Vectorstore",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Supabase Vector Store": {
      "ai_vectorStore": [
        [
          {
            "node": "Vector Store Tool1",
            "type": "ai_vectorStore",
            "index": 0
          }
        ]
      ]
    },
    "Recursive Character Text Splitter": {
      "ai_textSplitter": [
        [
          {
            "node": "Default Data Loader",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

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

分享此工作流