自动个性化首次接触（新潜在客户）

• •Google Sheets API 凭证
• •OpenAI API Key

{
  "id": "sWPZWgk6NelYRau1",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "自动个性化首次接触（新潜在客户）",
  "tags": [],
  "nodes": [
    {
      "id": "cf5722fd-a808-4986-af8f-df5678d7b65f",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -496,
        368
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "edba5fac-43e6-42fd-a214-e1e7b64feb69",
      "name": "从 Google Sheets 获取潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -272,
        368
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "b0eac1b3-ceed-486f-8c8c-6b6c41dc3f92",
      "name": "AI 研究与个性化代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        176,
        368
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "0be1c1b5-2362-4bbf-8a4c-a79bf4587881",
      "name": "GPT-4o Mini 语言模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        240,
        592
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f97ac708-480d-46f7-abd9-f9a26bf167f4",
      "name": "逐个处理潜在客户",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -48,
        368
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "fb010d21-912e-49c3-882a-88501adb77e3",
      "name": "将 AI 响应解析到字段",
      "type": "n8n-nodes-base.code",
      "position": [
        528,
        368
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "de0e3bd5-a3eb-40a7-846e-7194ce8e5520",
      "name": "将消息写回表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        368
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "d13b3c5c-77e8-48b9-ac7c-efb1d80eafa5",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        112
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "475df974-f515-46a9-9274-2ac0d4d081f8",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        560
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "ab12913e-dbb2-4863-b55b-6170246f3c05",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        112
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "9bb9cee7-f943-4423-8690-2633ebd721a1",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        48
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "eeef77e7-0316-47cb-acfd-a2af290d8c28",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        576
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "f86697d9-a4d5-4625-9989-b49f51da8b3e",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        64
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "18490d76-c288-445d-b81a-140648ab8587",
      "name": "便签概览",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        304
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6c263b18-ec93-4c8c-b81f-675444270942",
  "connections": {
    "Process Leads One by One": {
      "main": [
        [],
        [
          {
            "node": "AI Research & Personalization Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GPT-4o Mini Language Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Research & Personalization Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse AI Response to Fields": {
      "main": [
        [
          {
            "node": "Write Message Back to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Message Back to Sheet": {
      "main": [
        [
          {
            "node": "Process Leads One by One",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Leads from Google Sheet": {
      "main": [
        [
          {
            "node": "Process Leads One by One",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Research & Personalization Agent": {
      "main": [
        [
          {
            "node": "Parse AI Response to Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Fetch Leads from Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}