8
n8n 中文网amn8n.com

使用Gmail、Google Sheets和AI自动分类邮件

高级

这是一个Other, Support, AI领域的自动化工作流，包含 17 个节点。主要使用 Set, Gmail, Filter, GoogleSheets, SplitInBatches 等节点，结合人工智能技术实现智能自动化。 使用Gmail、Google Sheets和AI自动分类邮件

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

使用的节点 (17)

Set
Gmail
Filter
StickyNote
GoogleSheets
SplitInBatches
Agent
ScheduleTrigger
LmChatOpenRouter

分类

其他
客户支持
人工智能
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "c8c9ba5d3eb26ae47a06d24ff164a01c0d73ed4753a74903c2bb609d434a0f6b",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "fd08b5e1-f370-46b6-8088-c2e59c73d71c",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "78f01440-ef12-4ee6-a9a5-af4d39104c0c",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -140
      ],
      "parameters": {
        "width": 420,
        "content": "## 1 - 配置"
      },
      "typeVersion": 1
    },
    {
      "id": "58417d60-eaaf-4d3f-affb-3a1655d2777b",
      "name": "配置",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "cf1d4687-98df-4f65-b72e-6722075ab703",
              "name": "sheets_url",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/1LKIx1Z3dCSX1uzyZH9s2HE0QRMvLTDI6sJApFU5LTj0/edit?gid=0#gid=0"
            },
            {
              "id": "5df50301-a77a-483f-80ce-7717daa04231",
              "name": "extra_filter",
              "type": "string",
              "value": ""
            },
            {
              "id": "4fc76947-79c9-4f73-bf36-c18e664b14b4",
              "name": "limit",
              "type": "number",
              "value": 2
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "8f8812bc-dc04-4405-8d33-e6d457e2d1e8",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        880,
        0
      ],
      "parameters": {
        "text": "=Email subject:\n\n{{ $json.headers.subject }}\n\n\nText: {{ $json.text }}\n\nChoose the best fitting of the category names below, based on their definition:\n{{ JSON.stringify($('Get Labels').all()) }}\n\nImportant: ONLY respond with the category Name. EXACTLY one of the names, do not add any other texts.\n\nSo response should be one of:\n{{ $('Get Labels').all().map(({ json: { Name } }) => Name ).join('\\n') }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "e1bf4a15-a2b5-48a4-83d4-af649f20101f",
      "name": "OpenRouter 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        900,
        220
      ],
      "parameters": {
        "model": "deepseek/deepseek-r1:free",
        "options": {}
      },
      "credentials": {
        "openRouterApi": {
          "id": "iZmDjXmiYrP8nGux",
          "name": "OpenRouter account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5c597cd5-69f0-42ac-a158-a5ef766157b0",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        20
      ],
      "parameters": {
        "width": 420,
        "height": 400,
        "content": "## 2 - 连接 AI (可选：查找免费模型)"
      },
      "typeVersion": 1
    },
    {
      "id": "8ec93dff-52a4-410e-b45f-f492bcc0bb88",
      "name": "邮件回复",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        440,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $json.sheets_url }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $json.sheets_url }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gbEbCNKqCMSRZPql",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "221de31a-e662-402d-8795-1bcd40757855",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -220
      ],
      "parameters": {
        "height": 80,
        "content": "# 设置"
      },
      "typeVersion": 1
    },
    {
      "id": "e41fb3ca-5de0-4a1a-a0f7-4f6fddc739ed",
      "name": "如果标签不存在则创建标签",
      "type": "n8n-nodes-base.gmail",
      "onError": "continueRegularOutput",
      "position": [
        1620,
        280
      ],
      "webhookId": "9482c1cf-26bd-42a6-98cd-78c34810597d",
      "parameters": {
        "name": "={{ $json.output }}",
        "options": {},
        "resource": "label",
        "operation": "create"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "duhSaIumY2CifCex",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "fea8a543-0bb4-460e-9862-06c711ec30e6",
      "name": "获取现有标签",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1820,
        280
      ],
      "webhookId": "bb39b430-d756-4a9f-8bfb-9d1a63c495c4",
      "parameters": {
        "resource": "label",
        "returnAll": true
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "duhSaIumY2CifCex",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "a45806ca-6b98-411a-a8b2-a8b9f071d6c0",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1460,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "de31842d-88de-4281-a8f7-5e88db026ece",
      "name": "过滤器",
      "type": "n8n-nodes-base.filter",
      "position": [
        2020,
        280
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "e36a5069-09dd-424d-a2b8-096cefa059d7",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.name }}",
              "rightValue": "={{ $('Loop Over Items').item.json.output }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "fe0c9d60-bd76-4a72-adb4-0b04bcd971bc",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2200,
        280
      ],
      "webhookId": "332f57fb-6795-4a88-aff7-25d3838ffea7",
      "parameters": {
        "labelIds": "={{ $json.id }}",
        "resource": "thread",
        "threadId": "={{ $('Loop Over Items').item.json.threadId }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "duhSaIumY2CifCex",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "3f3c2627-c20d-443f-8a6f-c803139c4143",
      "name": "用于循环的字段",
      "type": "n8n-nodes-base.set",
      "position": [
        1240,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "cf0978da-37a2-48e8-8da9-8ec110638a42",
              "name": "threadId",
              "type": "string",
              "value": "={{ $('Get Messages').item.json.threadId }}"
            },
            {
              "id": "71cac306-cca3-4e28-8bba-d920d83037ac",
              "name": "output",
              "type": "string",
              "value": "={{ $json.output }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "10ede08e-bdbc-4c3f-8c25-2724bfbda6f5",
      "name": "获取消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        660,
        0
      ],
      "webhookId": "5d1e7386-2e1c-4743-b03a-daffea28b66b",
      "parameters": {
        "limit": "={{ $('Config').item.json.limit }}",
        "simple": false,
        "filters": {
          "q": "=has:nouserlabels {{ $('Config').item.json.extra_filter }}"
        },
        "options": {},
        "operation": "getAll"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "duhSaIumY2CifCex",
          "name": "Gmail account"
        }
      },
      "executeOnce": true,
      "typeVersion": 2.1
    },
    {
      "id": "f15bda54-5a37-49e1-b06c-322308689c6e",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        160
      ],
      "parameters": {
        "width": 310,
        "content": "👆⬆️"
      },
      "typeVersion": 1
    },
    {
      "id": "d34f5149-6749-4064-bfcf-6fc32651e945",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -280,
        -540
      ],
      "parameters": {
        "color": 5,
        "width": 580,
        "height": 400,
        "content": "# 关于作者"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Config": {
      "main": [
        [
          {
            "node": "Get Labels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Fields For Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Labels": {
      "main": [
        [
          {
            "node": "Get Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Messages": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fields For Loop": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Create Label if Doesn't exist",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Existing Labels": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Create Label if Doesn't exist": {
      "main": [
        [
          {
            "node": "Get Existing Labels",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 其他, 客户支持, 人工智能

需要付费吗？

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

相关工作流推荐

基于AI的MIS代理
基于AI的管理信息系统代理
If
Set
Code
+29
129 节点Kumar Shivam
客户支持
自动化每日客户挽回活动与 AI 优惠
自动化每日客户挽回活动与 AI 优惠
If
Set
Gmail
+8
17 节点Onur
客户支持
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
If
Set
Gmail
+14
51 节点Willemijn
产品
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
产品
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
发票处理与验证 - n8n 模板
基于Gmail、Drive、表格和OCR AI的发票验证与确认
If
Set
Code
+13
47 节点Dhrumil Patel
财务
工作流信息
难度等级
高级
节点数量17
分类3
节点类型9
难度说明

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

作者
Milan Vasarhelyi

Milan Vasarhelyi

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

分享此工作流