8
n8n 中文网amn8n.com

AI线索评分与路由（Google Gemini、Sheets和Slack通知）

中级

这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 Set, Merge, Slack, Webhook, GoogleSheets 等节点。 AI线索评分与路由（Google Gemini、Sheets和Slack通知）

前置要求
  • •Slack Bot Token 或 Webhook URL
  • •HTTP Webhook 端点（n8n 会自动生成）
  • •Google Sheets API 凭证
  • •Google Gemini API Key

使用的节点 (13)

Set
Merge
Slack
Webhook
StickyNote
GoogleSheets
SentimentAnalysis
LmChatGoogleGemini

分类

内容创作
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "0a25db4fd0692af64b58f35e01611f2ef0b5bb9d6654c57ef3741021e7d8cc11",
    "templateId": "4322",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "e74de2ca-d3e1-499b-893c-972bb6bd9ad0",
      "name": "Google Gemini聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1424,
        736
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "MOufOXyoLNgKIzCu",
          "name": "Google Gemini(PaLM) Api account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "01b4b86b-8798-405e-93c9-5881f3d27d20",
      "name": "接收新潜在客户（Typeform）",
      "type": "n8n-nodes-base.webhook",
      "position": [
        896,
        480
      ],
      "webhookId": "20426827-714d-4a48-ab87-4a3216665bde",
      "parameters": {
        "path": "lead-webhook",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "b4007cc1-6332-42d3-a7d1-12db9bc35fec",
      "name": "准备潜在客户数据",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        480
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3.4
    },
    {
      "id": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
      "name": "分类情感（Gemini 或其他 AI 模型）",
      "type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
      "position": [
        1344,
        480
      ],
      "parameters": {
        "options": {},
        "inputText": "={{$json[\"message\"] || $json[\"mensagem\"] || $json[\"resposta\"]}}\n"
      },
      "typeVersion": 1
    },
    {
      "id": "20839991-6176-4485-98fe-1d188ac552f1",
      "name": "合并潜在客户数据",
      "type": "n8n-nodes-base.merge",
      "position": [
        1920,
        464
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "31b9506f-0537-4b58-9c51-fbdfcf05a3f0",
      "name": "发送消息",
      "type": "n8n-nodes-base.slack",
      "position": [
        2144,
        480
      ],
      "webhookId": "17d27255-fdc2-4b45-ab04-b35b00fabc99",
      "parameters": {
        "text": "wefwe",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09BP1AGRT9",
          "cachedResultName": "alle-in-meakcodes"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "BFRW6GiYcJw58eeZ",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "52a61391-f621-484a-b395-e72bffed9654",
      "name": "存储中性潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        480
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd",
      "name": "存储冷潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        672
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded",
      "name": "存储热潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        288
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "23596639-84c4-438f-a820-1809957a6cdf",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        192
      ],
      "parameters": {
        "color": 4,
        "height": 256,
        "content": "## 步骤 1 · 接收（Webhook）"
      },
      "typeVersion": 1
    },
    {
      "id": "b5c93a1c-55df-47d9-b9bc-b97831a331fa",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1328,
        176
      ],
      "parameters": {
        "color": 5,
        "height": 272,
        "content": "## 步骤 2 · 情感分类"
      },
      "typeVersion": 1
    },
    {
      "id": "c25b0dc7-9bf5-463c-bfb4-b03f5c24960d",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        0
      ],
      "parameters": {
        "color": 6,
        "height": 256,
        "content": "## 步骤 3 · 按细分存储（Sheets）"
      },
      "typeVersion": 1
    },
    {
      "id": "34e7fb02-48d3-43ff-ab15-bab12a60f3ea",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1968,
        176
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## 步骤 4 · 合并与通知"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Store Hot Lead": {
      "main": [
        [
          {
            "node": "Combine Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Cold Lead": {
      "main": [
        [
          {
            "node": "Combine Lead Data",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Combine Lead Data": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Lead Data": {
      "main": [
        [
          {
            "node": "Classify Sentiment (Gemini or other ai model)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Neutral Lead": {
      "main": [
        [
          {
            "node": "Combine Lead Data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Classify Sentiment (Gemini or other ai model)",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Receive New Lead (Typeform)": {
      "main": [
        [
          {
            "node": "Prepare Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Classify Sentiment (Gemini or other ai model)": {
      "main": [
        [
          {
            "node": "Store Hot Lead",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Store Neutral Lead",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Store Cold Lead",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 内容创作, 多模态 AI

需要付费吗？

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

相关工作流推荐

自动化潜在客户呼叫：VAPI、Google Sheets记录与日历预约
自动化潜在客户呼叫：VAPI、Google Sheets记录与日历预约
Set
Code
Webhook
+7
13 节点Meak
内容创作
自动化潜在客户跟进：GPT-4o mini分析用于Gmail、HubSpot和Slack
自动化潜在客户跟进：GPT-4o mini分析用于Gmail、HubSpot和Slack
If
Set
Code
+7
14 节点Meak
内容创作
自动化本地线索查找与冷邮件发送
使用 Apify、AI 和 Gmail 自动查找本地线索并发送冷邮件
If
Set
Wait
+10
18 节点Meak
内容创作
基于AI的潜在客户资格评定与个性化触达（使用Relevance AI）
基于AI的潜在客户资格评定与个性化触达：使用Relevance AI
Set
Code
Gmail
+11
34 节点Diptamoy Barman
内容创作
使用Groq、Gemini和Slack审批系统自动化RSS到Medium发布
通过Groq、Gemini和Slack审批系统实现RSS到Medium发布的自动化流程
If
Set
Code
+16
41 节点ObisDev
内容创作
防欺诈潜在客户捕获与培育系统
通过AI评分、表格跟踪和多渠道提醒捕获和培育防欺诈潜在客户
If
Set
Code
+11
28 节点Jitesh Dugar
内容创作
工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
难度说明

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

作者
Meak

Meak

@meak

I help people build $5k+/month online by starting their own AI agency. Without BS.

外部链接
在 n8n.io 查看 →

分享此工作流