8
n8n 中文网amn8n.com

AI 潜在客户资质判定

中级

这是一个Miscellaneous, AI Summarization, Multimodal AI领域的自动化工作流，包含 10 个节点。主要使用 Code, GoogleSheets, Agent, GoogleSheetsTrigger, LmChatAzureOpenAi 等节点。 使用 Azure GPT-4o-mini 和 Google Sheets 进行 AI 评审分析的潜在客户资质判定

前置要求
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (10)

Code
StickyNote
GoogleSheets
Agent
GoogleSheetsTrigger
LmChatAzureOpenAi

分类

杂项
AI 摘要总结
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "D3gKQ4UE1XR2TC8n",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "AI 潜在客户资质判定",
  "tags": [],
  "nodes": [
    {
      "id": "4c1057b9-9d53-47b3-a319-b726d87759b4",
      "name": "Google Sheets触发器",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -544,
        -128
      ],
      "parameters": {
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 931869588,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI/edit#gid=931869588",
          "cachedResultName": "Form Responses 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cOFWYxogbcRih5akkyApvBsV7vXPTFWUjAGtJe-fwEI/edit?usp=drivesdk",
          "cachedResultName": "Product Review form (Responses)"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "tjY8nawuuRO1rxAE",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5abf8a0d-a5d9-46d6-8e3d-097158a50d9b",
      "name": "代码 - 解析 AI JSON",
      "type": "n8n-nodes-base.code",
      "position": [
        32,
        -128
      ],
      "parameters": {
        "jsCode": "// Loop over all input items\nfor (const item of $input.all()) {\n  // Add a new field\n  item.json.myNewField = 1;\n\n  // Parse the stringified JSON in 'output'\n  const parsed = JSON.parse(item.json.output);\n  const sheet = $('Google Sheets Trigger').first().json;\n\n  // Extract and assign values\n  item.json.Timestamp = sheet.Timestamp;\n  item.json.Name = sheet.Name;\n  item.json.Email = sheet.Email;\n  item.json['Contact Number'] = sheet['Contact Number'];\n  item.json['Review of the product'] = sheet['Review of the product'];\n  item.json.intent = parsed.intent;\n  item.json.sentiment = parsed.sentiment;\n  item.json.score = parsed.score;\n  item.json.summary = parsed.summary;\n\n\n  delete item.json.output;\n  delete item.json.myNewField;\n}\n\n// Return updated items\nreturn $input.all();\n"
      },
      "typeVersion": 2
    },
    {
      "id": "908c833d-4230-45b6-a7ae-d3f3d4d4ac51",
      "name": "Google Sheets - 更新潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        256,
        -128
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.Name }}",
            "Email": "={{ $json.Email }}",
            "Score": "={{ $json.score }}",
            "Intent": "={{ $json.intent }}",
            "Summary": "={{ $json.summary }}",
            "Sentiment": "={{ $json.sentiment }}",
            "Timestamp": "={{ $json.Timestamp }}",
            "row_number": 0,
            "Contact Number": "={{ $json[\"Contact Number\"] }}",
            "Review of the product": "={{ $json[\"Review of the product\"] }}"
          },
          "schema": [
            {
              "id": "Timestamp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Number",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Contact Number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Review of the product",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Review of the product",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Intent",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Intent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Sentiment",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Sentiment",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Score",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1qohS8H6x3_CrXiT0t1jpxjDk_YbEbHrkAa2tDHWJCc4/edit?usp=drivesdk",
          "cachedResultName": "Updated product review"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "8d30516b-719c-4d62-a419-571423e98969",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -336,
        -128
      ],
      "parameters": {
        "text": "=Here is the customer review data: {{ $json[\"Review of the product\"] }}",
        "options": {
          "systemMessage": "=You are an AI assistant that analyzes customer product reviews.\nYour job is to:\n\nUnderstand the customer’s intent (e.g., praise, complaint, suggestion, feature request, mixed feedback).\n\nEvaluate the sentiment (positive, neutral, negative, or mixed).\n\nAssign a score from 1–10 (1 = very negative, 10 = excellent).\n\nReturn results in clean JSON format with these keys:\n\nintent\n\nsentiment\n\nscore\n\nsummary (short 1–2 sentence summary of the review).\n\nDo not add extra commentary outside the JSON."
        },
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "789b8347-91ce-4152-9eaf-7a7550016897",
      "name": "Azure OpenAI聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        -352,
        32
      ],
      "parameters": {
        "model": "gpt-4o-mini",
        "options": {}
      },
      "credentials": {
        "azureOpenAiApi": {
          "id": "C3WzT18XqF8OdVM6",
          "name": "Azure Open AI account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ab65ad1f-f875-437b-bb05-4decf1d27c8b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -496
      ],
      "parameters": {
        "width": 288,
        "height": 336,
        "content": "## 节点 1：Google Sheets 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "a7c641fd-b529-4038-b5ed-2c18d2eea2be",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        -544
      ],
      "parameters": {
        "width": 272,
        "height": 384,
        "content": "## 节点 2：AI Agent"
      },
      "typeVersion": 1
    },
    {
      "id": "d132ceb8-058a-434f-b872-5aab1275ee2d",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        144
      ],
      "parameters": {
        "height": 384,
        "content": "## 节点 3：Azure OpenAI 聊天模型"
      },
      "typeVersion": 1
    },
    {
      "id": "9ae50a46-7c45-47b0-85cc-d11731138f66",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        32
      ],
      "parameters": {
        "height": 432,
        "content": "## 节点 4：代码 - 解析 AI JSON"
      },
      "typeVersion": 1
    },
    {
      "id": "91c624b3-9f27-4d26-8918-fe7e27e092e1",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        -560
      ],
      "parameters": {
        "width": 256,
        "height": 416,
        "content": "## 节点 5：Google Sheets - 更新潜在客户"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "79ed4ff6-5908-4fff-9cb7-a4ed0f023328",
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Code - Parse AI JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code - Parse AI JSON": {
      "main": [
        [
          {
            "node": "Google Sheets - Update Lead",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 杂项, AI 摘要总结, 多模态 AI

需要付费吗？

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

相关工作流推荐

候选人问卷分析
使用Azure GPT-4o-mini和Google Sheets评估面试并更新分数
Set
Code
Google Sheets
+4
16 节点Rahul Joshi
杂项
技能矩阵提取器
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+5
17 节点Rahul Joshi
杂项
潜在客户接收与去重工作流
使用 Google Sheets 去重潜在客户数据：自动邮件提醒与日志管理
If
Code
Filter
+4
18 节点Rahul Joshi
客户关系管理
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
Code
Email Send
Http Request
+6
20 节点Rahul Joshi
市场调研
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
工作流信息
难度等级
中级
节点数量10
分类3
节点类型6
难度说明

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

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.

外部链接
在 n8n.io 查看 →

分享此工作流