基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
高级
这是一个Sales, AI领域的自动化工作流，包含 51 个节点。主要使用 If, Set, Wait, Merge, Filter 等节点，结合人工智能技术实现智能自动化。 基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
前置要求
- •HubSpot API Key
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (51)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "4e6be3a68285934388a854ac0ffdc5e5500688d5cdb88d0ec2d734e85f097355",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "80ffc9b5-2a35-46e3-a641-45ae6f9556bd",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-5820,
2140
],
"parameters": {
"options": {
"columnsToWatch": [
"status"
]
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "VNqOvRgnzQaAingt",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "06d817c6-f625-495e-bfd3-d019a98f0ebb",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-3260,
2280
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\"$schema\": \"http://json-schema.org/draft-07/schema#\",\n\"title\": \"UserData\",\n\"type\": \"object\",\n\"properties\": {\n \"first_name\": {\n \"type\": \"string\"\n },\n \"last_name\": {\n \"type\": \"string\"\n },\n \"middle_name\": {\n \"type\": \"string\"\n },\n \"gender\": {\n \"type\": \"string\"\n },\n \"address\": {\n \"type\": \"string\"\n },\n \"city\": {\n \"type\": \"string\"\n },\n \"state\": {\n \"type\": \"string\"\n },\n \"zip\": {\n \"type\": \"integer\"\n },\n \"country\": {\n \"type\": \"string\"\n },\n \"email\": {\n \"type\": \"string\",\n \"format\": \"email\"\n },\n \"phone\": {\n \"type\": \"string\"\n },\n \"date_of_birth\": {\n \"type\": \"string\"\n },\n \"field_of_study\": {\n \"type\": \"string\"\n },\n \"graduation_date\": {\n \"type\": \"string\"\n },\n \"company\": {\n \"type\": \"string\"\n },\n \"job_title\": {\n \"type\": \"string\"\n },\n \"department\": {\n \"type\": \"string\"\n },\n \"facebook_handle\": {\n \"type\": \"string\"\n },\n \"linkedin_url\": {\n \"type\": \"string\",\n \"format\": \"uri\"\n },\n \"x_handle\": {\n \"type\": \"string\"\n },\n \"instagram_handle\": {\n \"type\": \"string\"\n },\n \"company_address\": {\n \"type\": \"string\"\n },\n \"company_city\": {\n \"type\": \"string\"\n },\n \"company_state\": {\n \"type\": \"string\"\n },\n \"company_zip\": {\n \"type\": \"integer\"\n },\n \"company_country\": {\n \"type\": \"string\"\n },\n \"company_phone\": {\n \"type\": \"string\"\n },\n \"company_email\": {\n \"type\": \"string\",\n \"format\": \"email\"\n },\n \"company_industry\": {\n \"type\": \"string\"\n },\n \"company_size\": {\n \"type\": \"integer\"\n },\n \"company_founded_year\": {\n \"type\": \"integer\"\n },\n \"degree\": {\n \"type\": \"string\"\n },\n \n \"job_function\": {\n \"type\": \"string\"\n },\n \"marital_status\": {\n \"type\": \"string\"\n },\n \"salutation\": {\n \"type\": \"string\"\n },\n \"school\": {\n \"type\": \"string\"\n },\n \"scrape_error\": {\n \"type\": \"string\"\n }\n},\n\"required\": [\n \"first_name\",\n \"last_name\",\n \"email\"\n],\n\"additionalProperties\": false\n}"
},
"typeVersion": 1.2
},
{
"id": "18ef61dc-5134-4c8b-817b-da162c093b06",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5880,
1920
],
"parameters": {
"color": 4,
"width": 460,
"height": 540,
"content": "## 根据“状态”列监控 Google Sheets 中更新的记录"
},
"typeVersion": 1
},
{
"id": "e3b79eff-1504-4da3-85ef-4423f5ee71cd",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
-3480,
2080
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease only return the first_name, last_name, email, and scrape_error (put the error details in this field)"
}
},
"typeVersion": 1
},
{
"id": "1023e561-8f92-4fe1-8d21-1b6fcd2bbb6e",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-3500,
2200
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "K4cmCYcro5viwUfR",
"name": "Thijs 2"
}
},
"typeVersion": 1.2
},
{
"id": "ac4f57e8-f7f0-47b8-b039-9a93f198083a",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6620,
1440
],
"parameters": {
"color": 4,
"width": 520,
"height": 540,
"content": "## 手动运行需要丰富数据的记录"
},
"typeVersion": 1
},
{
"id": "c46b338f-ccb6-4ce4-a1a3-623a615d19b2",
"name": "逐个处理每个线索",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4620,
1260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e6f86e5f-f49f-4781-90d2-78747efd5053",
"name": "筛选需要丰富数据的线索",
"type": "n8n-nodes-base.filter",
"position": [
-5600,
2140
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "1ec242aa-557e-434a-8bb5-d043b5645e88",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.status?.toString() }}",
"rightValue": ""
},
{
"id": "400fe682-5882-441f-a506-ea8f9bdb9df8",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "needs more enrichment"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "46203489-bdd1-48ea-a020-8f5e1734cbdb",
"name": "移除提示中不必要的字段",
"type": "n8n-nodes-base.set",
"position": [
-4100,
1260
],
"parameters": {
"include": "except",
"options": {},
"excludeFields": "row_number, status, row_id",
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "838ba8a6-3f41-4973-b5aa-805b9abc6baa",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
720
],
"parameters": {
"color": 4,
"width": 980,
"height": 1620,
"content": "# 更新 Google Sheet 中的记录"
},
"typeVersion": 1
},
{
"id": "1315c393-9cb2-4345-ba01-34faa5673e72",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4260,
1040
],
"parameters": {
"color": 6,
"width": 840,
"height": 740,
"content": "# 附加了 Bright Data MCP 的 AI Agent"
},
"typeVersion": 1
},
{
"id": "f77f311d-20c4-4e5d-a679-f905a5e1680a",
"name": "Bright Data MCP 客户端",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
-3760,
1540
],
"parameters": {
"include": "selected",
"sseEndpoint": "http://localhost:8000/sse",
"includeTools": [
"search_engine",
"web_data_linkedin_person_profile",
"web_data_linkedin_company_profile",
"web_data_linkedin_people_search",
"web_data_crunchbase_company",
"web_data_tiktok_profiles",
"web_data_instagram_profiles"
]
},
"typeVersion": 1
},
{
"id": "f5d6bf43-d9c0-4272-9d5f-cf1371f0e27a",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-4000,
1540
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "3wONK02jjm23nMHf",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "370ea5eb-0abc-418a-836f-f9e28d3f11be",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3360,
1040
],
"parameters": {
"width": 1160,
"height": 760,
"content": "# 格式化结果并与原始数据比较"
},
"typeVersion": 1
},
{
"id": "cc8043c0-6306-4808-9caf-0776b9a29553",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "54ed6517-f4b9-48ff-baf1-37c7551c85ed",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.first_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.first_name }}"
},
{
"id": "465b70a3-9830-4521-8248-a1236795b296",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.last_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.last_name }}"
},
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7cfe0f1d-d2ef-4630-b4d4-5ef155852f4c",
"name": "切换",
"type": "n8n-nodes-base.switch",
"position": [
-3240,
1280
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Email only",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "26b1eb37-80d1-4966-a223-fe7a6d032083",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email !== \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() === \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "Name only",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7a4f68df-3d5b-4476-b186-8a5fb847d78e",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email === \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() !== \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "Both email and name exists",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "13d089ae-1fd1-4a15-a35c-edae907141f5",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $('Process each leads one by one').item.json.email !== \"\" && ($('Process each leads one by one').item.json.first_name + \" \" + $('Process each leads one by one').item.json.last_name).trim() !== \"\" }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "f4357d32-0d4f-4131-8367-63ac527bb9e2",
"name": "条件判断2",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1120
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0efb7c41-869f-4803-b725-7133fe74dfd6",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-2620,
1620
],
"parameters": {
"mode": "chooseBranch",
"useDataOfInput": 2
},
"typeVersion": 3.1
},
{
"id": "5478a933-3704-4282-a043-b61e7c84c86e",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
-2980,
1280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "54ed6517-f4b9-48ff-baf1-37c7551c85ed",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.first_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.first_name }}"
},
{
"id": "465b70a3-9830-4521-8248-a1236795b296",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.last_name }}",
"rightValue": "={{ $('Process each leads one by one').item.json.last_name }}"
},
{
"id": "5a2f38ab-64e6-4e5d-92e2-7a88135e7884",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.email }}",
"rightValue": "={{ $('Process each leads one by one').item.json.email }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b96100ab-1edf-46ce-8c1d-c16c7617b327",
"name": "不匹配路径",
"type": "n8n-nodes-base.noOp",
"position": [
-2400,
1200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "896fdbd8-e6b2-4e5e-8cbb-8c347714f541",
"name": "请求间隔5秒",
"type": "n8n-nodes-base.wait",
"position": [
940,
1440
],
"webhookId": "ca47f66b-d536-4751-ab54-7d1e049ca14a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5e4b65b7-30b6-4980-a851-43b8112d6347",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3740,
1960
],
"parameters": {
"color": 6,
"width": 840,
"height": 560,
"content": "## 格式化输出"
},
"typeVersion": 1
},
{
"id": "146b61b9-cd18-4e72-b07f-4f848d909a66",
"name": "爬虫 AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "\nSteps:\n1. Scrape the url and find for the input fields common in the form such as text, radio buttons, checkboxes. etc. Identify selectors for these input fields. Find the submit button too or the button to proceed to the next section or step.",
"position": [
-3880,
1280
],
"parameters": {
"text": "=Here's the lead's data:\n\n{{ $json.toJsonString() }}",
"options": {
"maxIterations": 30,
"systemMessage": "=Prompt: Person and Company Enrichment Task\n\nObjective:\nEnrich the lead’s information as completely and accurately as possible. Avoid fabricating data and maintain strict adherence to the correct tool schema for each tool used in the MCP client.\n\n⸻\n\n1. Person Enrichment Instructions:\n- Start with a Google Search:\nPrioritize locating the individual’s LinkedIn profile URL using the available information.\n- Query Guidelines:\n- If the email address is available, use it in your search query.\n- If not, use the person’s first name and last name.\n- Always append keywords like “linkedin”, “facebook”, “instagram”, or other relevant social media platforms to refine the search.\n- LinkedIn-Based Enrichment:\nOnce the LinkedIn URL is found, use it to gather available details from their profile.\n\n⸻\n\n2. Company Enrichment Instructions:\n- Email Domain Extraction:\nIf the person’s email is not from a generic provider (e.g., gmail.com, outlook.com, hotmail.com, icloud.com), extract the domain and use it in your search.\n- Query Composition:\n- Combine the extracted domain with any existing value in the “company” field of the lead’s details.\n- Do not rely on or reuse company data obtained from other tool outputs.\n- Focus on sourcing reliable company information from LinkedIn and Crunchbase.\n\n⸻\n\nOutput Format:\n\nReturn the enriched data in valid JSON format using the original key structure. Exclude any fields that remain empty. Example output:\n\n{\n \"first_name\": \"John\",\n \"last_name\": \"Doe\",\n \"address\": \"123 Maple Street, Apt 4\",\n \"instagram_handle\": \"johndoe38\"\n}\n\n",
"returnIntermediateSteps": true
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 1.9
},
{
"id": "bfbf1be5-96a7-470e-a3d2-006dbf948c4d",
"name": "合并1",
"type": "n8n-nodes-base.merge",
"position": [
-1560,
1460
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.1
},
{
"id": "fa2096a7-56d7-45aa-b10f-4ae7456339b4",
"name": "判断爬取数据的准确性",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-2020,
1280
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "id",
"value": "=gpt-4o-mini"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "Task:\nEvaluate the accuracy of the scraped data compared to the original source data.\n\nInstructions:\n- Assess how closely the scraped output matches the original data in terms of content, structure, and completeness.\n- Provide a confidence score based on the overall accuracy.\n- Explain your reasoning in concise, clear remarks.\n\nOutput Format (JSON):\n\n{\n \"confidence\": [decimal between 0 and 1, e.g., 0.98 for 98% accuracy],\n \"remarks\": \"A brief explanation justifying the confidence score, highlighting any discrepancies or issues found.\"\n}\n"
},
{
"content": "=Original source data:\n{{ $('Remove unneccessary fields for the prompt').item.json.toJsonString() }}\n\nScraped output:\n{{ $json.output.toJsonString() }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "K4cmCYcro5viwUfR",
"name": "Thijs 2"
}
},
"typeVersion": 1.8
},
{
"id": "32f37490-752b-4ee1-b68f-c56f17615bf4",
"name": "仅为了使连接整洁",
"type": "n8n-nodes-base.noOp",
"position": [
1480,
2480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "01f944b6-e821-4ca3-ba09-bbc33f562ef4",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2080,
1020
],
"parameters": {
"color": 2,
"width": 1160,
"height": 740,
"content": "# 识别爬取数据的准确性"
},
"typeVersion": 1
},
{
"id": "08a34aec-7419-4cb9-b495-dff406c6f61d",
"name": "仅提取 AI 结果",
"type": "n8n-nodes-base.set",
"position": [
-1820,
1280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "298abc40-159e-4aa3-ab4d-039829c2d1a0",
"name": "confidence",
"type": "number",
"value": "={{ $json.message.content.confidence }}"
},
{
"id": "c2662984-8fa9-46eb-bc6d-fb7be5fc4451",
"name": "remarks",
"type": "string",
"value": "={{ $json.message.content.remarks }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "716a21d4-230d-4747-a031-ca8aac1bc3af",
"name": "检查置信度分数",
"type": "n8n-nodes-base.if",
"position": [
-720,
1580
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f153193c-b517-49fc-8ae4-1bea6bd0ff91",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.confidence }}",
"rightValue": 0.85
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a4eb12f7-26b9-4f8f-a51a-ff54c769c06b",
"name": "为 Google Sheets 准备爬取输出",
"type": "n8n-nodes-base.set",
"position": [
-1340,
1560
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json.output }}"
},
"typeVersion": 3.4
},
{
"id": "06bf86dc-c92f-4540-8963-219015d745fb",
"name": "将置信度分数添加到 Google Sheet",
"type": "n8n-nodes-base.set",
"position": [
-1140,
1580
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3d437c0b-ff3e-4c21-95e0-5557866806c5",
"name": "remarks",
"type": "string",
"value": "={{ $('Merge1').item.json.remarks }}"
},
{
"id": "5ef03fde-ee61-49a3-8c73-1ab4b66654a6",
"name": "confidence",
"type": "number",
"value": "={{ $('Merge1').item.json.confidence }}"
},
{
"id": "745b0dd7-7ac9-4e97-9192-db95ff2d2706",
"name": "row_id",
"type": "string",
"value": "={{ $('Process each leads one by one').item.json.row_id }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "f6ba009f-47f1-428e-95e6-b3d8ca23208d",
"name": "如果置信度分数低于85%则添加记录",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
2020
],
"parameters": {
"columns": {
"value": {
"first_name": "={{ $json.output.first_name }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"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": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9a5a4808-a8d1-4b49-82b5-b33bc48b56f5",
"name": "如果置信度分数等于或高于85%则覆盖记录",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
1400
],
"parameters": {
"columns": {
"value": {
"first_name": "={{ $json.output.first_name }}",
"row_number": "={{ $('Google Sheets').item.json.row_number }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"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": "company",
"type": "string",
"display": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "1eb07d73-aa8f-4cba-a760-5d142eea9734",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
1260
],
"parameters": {
"color": 7,
"width": 480,
"height": 360,
"content": "## 如果置信度分数等于或高于85%则覆盖记录"
},
"typeVersion": 1
},
{
"id": "274d8c92-9094-4b26-8d6e-689e38fe9540",
"name": "更新记录状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-220,
1020
],
"parameters": {
"columns": {
"value": {
"row_id": "={{ $('Process each leads one by one').item.json.row_id }}",
"status": "no information found"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9958acae-7675-48c2-a400-0ee00267745f",
"name": "GET 模型",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
1700
],
"parameters": {
"color": 7,
"width": 480,
"height": 560,
"content": "## 如果置信度分数低于85%则追加行"
},
"typeVersion": 1
},
{
"id": "ae5d281a-31a3-46a0-b5af-8dcf376d2947",
"name": "## 1. 创建新的自定义 OpenAI 凭据",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
840
],
"parameters": {
"color": 7,
"width": 480,
"height": 360,
"content": "## 爬取数据与源不匹配。这只会更新记录状态。"
},
"typeVersion": 1
},
{
"id": "a5aa4f8f-d7ec-4d28-87a2-c774ba627a95",
"name": "更新行ID和状态",
"type": "n8n-nodes-base.set",
"position": [
-300,
2020
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "9edb1a8c-d71c-4b13-aa89-6a329a58fd67",
"name": "row_id",
"type": "string",
"value": "={{ $('Process each leads one by one').item.json.row_id }}-{{ $now.toMillis() }}"
},
{
"id": "e95fdab0-79a5-4546-9b6d-0750fd44932c",
"name": "status",
"type": "string",
"value": "human review needed"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "2eb2c10a-1ab8-408f-9411-13fa356b4664",
"name": "更新原始记录状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
1780
],
"parameters": {
"columns": {
"value": {
"row_id": "={{ $json.row_id }}",
"status": "human review needed"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "row_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "e2cb5ff7-3d0d-4766-bda2-2ea5d1b8cf54",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
-5960,
780
],
"parameters": {
"options": {},
"fieldToSplitOut": "body"
},
"typeVersion": 1
},
{
"id": "da05a953-9e66-49b5-8c62-5cd48f439772",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-5420,
900
],
"parameters": {
"columns": {
"value": {
"email": "={{ $json.properties.email.value }}",
"phone": "={{ $json.properties.phone.value }}",
"row_id": "={{ $json.vid }}",
"last_name": "={{ $json.properties.lastname.value }}",
"first_name": "={{ $json.properties.firstname.value }}"
},
"schema": [
{
"id": "row_id",
"type": "string",
"display": true,
"required": false,
"displayName": "row_id",
"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": "middle_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "middle_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "department",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "department",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_of_birth",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "date_of_birth",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram_handle",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram_handle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_city",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_state",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_zip",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_zip",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_size",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_founded_year",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_founded_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "remarks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "remarks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "confidence",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "48243a45-396f-4610-b97f-808ca39e90a6",
"name": "HubSpot",
"type": "n8n-nodes-base.hubspot",
"position": [
-5680,
900
],
"parameters": {
"contactId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.contactId || $json.objectId }}"
},
"operation": "get",
"authentication": "appToken",
"additionalFields": {}
},
"credentials": {
"hubspotAppToken": {
"id": "udy2ya160kahX72n",
"name": "HubSpot App Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "1088136d-5530-47f2-b08f-3c91c28bd383",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-6280,
1620
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "status"
},
{
"lookupValue": "needs more enrichment",
"lookupColumn": "status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 870504645,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit#gid=870504645",
"cachedResultName": "sampleATcsv"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18bkVOsgjONipJNbPe91UiiLgKnSCvsr0b7BDLZUIJh0/edit?usp=drivesdk",
"cachedResultName": "Test Database"
},
"combineFilters": "OR"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB3Rn9lCQhQ5vKyg",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "16a4e5d7-3d4f-4aa4-b802-5bc61c6767b6",
"name": "当点击“执行工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-6520,
1620
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2cf15cf0-be32-41d8-82f6-78a142e32b4a",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6500,
540
],
"parameters": {
"color": 3,
"width": 1380,
"height": 720,
"content": "# Hubspot 中的新联系人触发器并保存到 Google Drive"
},
"typeVersion": 1
},
{
"id": "6a2d33a9-c2f9-412e-a70c-8a64b7da252b",
"name": "Hubpost 中的新联系人 (OAuth2)",
"type": "n8n-nodes-base.hubspotTrigger",
"position": [
-6340,
1020
],
"webhookId": "dab75ae0-affc-4616-bad6-2e88d1afabc7",
"parameters": {
"eventsUi": {
"eventValues": [
{}
]
},
"additionalFields": {}
},
"credentials": {
"hubspotDeveloperApi": {
"id": "HjFlmcRCWYRjI6nD",
"name": "New HS Dev"
}
},
"typeVersion": 1
},
{
"id": "fd273f08-9d98-4539-bad1-96a1ea6c0fc5",
"name": "Hubpost 中的新联系人 (私有应用)",
"type": "n8n-nodes-base.webhook",
"position": [
-6320,
680
],
"webhookId": "40d4eddf-4f9f-471f-a029-4a95f5f045b9",
"parameters": {
"path": "hsleads",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "d348c77a-7782-45c5-9d6d-d7464ff876c6",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
300,
1560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a1149d6-186f-49ce-a8b3-3a97b83b10a7",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
1840
],
"parameters": {
"color": 3,
"width": 680,
"height": 500,
"content": "# 为高置信度分数更新 Hubspot 联系人"
},
"typeVersion": 1
},
{
"id": "2c3f4e27-a1ee-4a0a-8fb8-180b5de97ae6",
"name": "更新 Hubspot 联系人",
"type": "n8n-nodes-base.hubspot",
"position": [
880,
2080
],
"parameters": {
"email": "={{ $json.email }}",
"options": {},
"authentication": "appToken",
"additionalFields": {
"city": "={{ $json.city }}",
"degree": "={{ $json.degree }}",
"gender": "={{ $json.gender }}",
"school": "={{ $json.school }}",
"country": "={{ $json.country }}",
"industry": "={{ $json.company_industry }}",
"jobTitle": "={{ $json.job_title }}",
"lastName": "={{ $json.last_name }}",
"firstName": "={{ $json.first_name }}",
"postalCode": "={{ $json.zip }}",
"salutation": "={{ $json.salutation }}",
"companyName": "={{ $json.company }}",
"dateOfBirth": "={{ $json.date_of_birth?.toDateTime() }}",
"jobFunction": "={{ $json.job_function }}",
"phoneNumber": "={{ $json.phone }}",
"fieldOfStudy": "={{ $json.field_of_study }}",
"maritalStatus": "={{ $json.marital_status }}",
"streetAddress": "={{ $json.address }}",
"graduationDate": "={{ $json.graduation_date?.toDateTime() }}",
"twitterUsername": "={{ $json.x_handle }}",
"customPropertiesUi": {
"customPropertiesValues": [
{
"value": "={{ $json.instagram_handle }}",
"property": "=instagram_handle"
},
{
"value": "={{ $json.facebook_handle }}",
"property": "=facebook_handle"
},
{
"value": "={{ $json.linkedin_url }}",
"property": "=linkedin_url"
}
]
}
}
},
"credentials": {
"hubspotAppToken": {
"id": "udy2ya160kahX72n",
"name": "HubSpot App Token account 2"
}
},
"typeVersion": 2.1
},
{
"id": "fdadcb0e-f66e-4755-8939-ab28d51301eb",
"name": "设置期望置信度分数",
"type": "n8n-nodes-base.if",
"position": [
580,
2100
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8f546fac-c14d-40f8-9fd0-7c431e1ae7f8",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.confidence }}",
"rightValue": 0.89
}
]
}
},
"typeVersion": 2.2
}
],
"pinData": {
"New Contact in Hubpost (OAuth2)": [
{
"appId": 7851008,
"eventId": 1468606353,
"portalId": 46194715,
"sourceId": "userId:60775145",
"contactId": 126603412869,
"changeFlag": "CREATED",
"occurredAt": 1748880900273,
"changeSource": "CRM_UI",
"attemptNumber": 0,
"subscriptionId": 3713763,
"subscriptionType": "contact.creation"
}
],
"New Contact in Hubpost (Private App)": [
{
"body": [
{
"appId": 10626375,
"eventId": 3048592825,
"objectId": 126603412869,
"portalId": 23861635,
"sourceId": "25200",
"changeFlag": "CREATED",
"occurredAt": 1746526735728,
"changeSource": "INTEGRATION",
"attemptNumber": 0,
"subscriptionId": 3429387,
"subscriptionType": "contact.creation"
}
],
"query": {},
"params": {},
"headers": {
"host": "hostmetric.app.n8n.cloud",
"accept": "*/*",
"cf-ray": "93b7bc86b08cd695-IAD",
"cdn-loop": "cloudflare; loops=1; subreqs=1",
"cf-ew-via": "15",
"cf-worker": "n8n.cloud",
"x-real-ip": "54.174.62.144",
"cf-visitor": "{\"scheme\":\"https\"}",
"user-agent": "HubSpot Connect 2.0 (http://dev.hubspot.com/) (namespace: webhooks-nio-http-client) - WebhooksExecutorDaemon-executor",
"cf-ipcountry": "US",
"content-type": "application/json",
"x-is-trusted": "yes",
"content-length": "264",
"accept-encoding": "gzip, br",
"x-forwarded-for": "54.174.62.144, 162.158.79.214",
"cf-connecting-ip": "54.174.62.144",
"x-forwarded-host": "hostmetric.app.n8n.cloud",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-forwarded-server": "traefik-prod-users-gwc-36-bc488dfd9-8q4qs",
"x-hubspot-signature": "c9e6138e683ed3092c5e223f3046cab7940dca29417666154796d1cffbfe4e58",
"x-hubspot-signature-v3": "9f5gSQ/tiqplcUzRVIHzK0igKjJYRxqzKraiB7URkIY=",
"x-hubspot-timeout-millis": "10000",
"x-hubspot-request-timestamp": "1746526736409",
"x-hubspot-signature-version": "v1"
},
"webhookUrl": "https://hostmetric.app.n8n.cloud/webhook/overnightleads",
"executionMode": "production"
}
]
},
"connections": {
"If": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "Not matched route",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "Not matched route",
"type": "main",
"index": 0
}
]
]
},
"If2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "Not matched route",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
},
{
"node": "Judge the accuracy of scraped data",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Prepare the scraped output for Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "If2",
"type": "main",
"index": 0
}
],
[
{
"node": "If1",
"type": "main",
"index": 0
}
],
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"HubSpot": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "HubSpot",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Process each leads one by one",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Process each leads one by one",
"type": "main",
"index": 0
}
]
]
},
"Scraper AI Agent": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Not matched route": {
"main": [
[
{
"node": "Update the status of the record",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Scraper AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Filter the leads that needs enrichment",
"type": "main",
"index": 0
}
]
]
},
"Bright Data MCP Client": {
"ai_tool": [
[
{
"node": "Scraper AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"No Operation, do nothing": {
"main": [
[
{
"node": "Set Desired Confidence Score",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Update row_id and status": {
"main": [
[
{
"node": "Add record if the confidence score is below 85%",
"type": "main",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "Scraper AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Check the confidence score": {
"main": [
[
{
"node": "Override the record if the confidence score is equal or greater than 85%",
"type": "main",
"index": 0
},
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Update row_id and status",
"type": "main",
"index": 0
},
{
"node": "Update the status of the original record",
"type": "main",
"index": 0
}
]
]
},
"Extract the AI results only": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Space requests by 5 seconds": {
"main": [
[
{
"node": "Just to make the connection neat",
"type": "main",
"index": 0
}
]
]
},
"Set Desired Confidence Score": {
"main": [
[
{
"node": "Update the Hubspot Contact",
"type": "main",
"index": 0
}
]
]
},
"Process each leads one by one": {
"main": [
[],
[
{
"node": "Remove unneccessary fields for the prompt",
"type": "main",
"index": 0
}
]
]
},
"New Contact in Hubpost (OAuth2)": {
"main": [
[
{
"node": "HubSpot",
"type": "main",
"index": 0
}
]
]
},
"Update the status of the record": {
"main": [
[
{
"node": "Space requests by 5 seconds",
"type": "main",
"index": 0
}
]
]
},
"Just to make the connection neat": {
"main": [
[
{
"node": "Process each leads one by one",
"type": "main",
"index": 0
}
]
]
},
"Judge the accuracy of scraped data": {
"main": [
[
{
"node": "Extract the AI results only",
"type": "main",
"index": 0
}
]
]
},
"Add confidence score to Google Sheet": {
"main": [
[
{
"node": "Check the confidence score",
"type": "main",
"index": 0
}
]
]
},
"New Contact in Hubpost (Private App)": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Filter the leads that needs enrichment": {
"main": [
[
{
"node": "Process each leads one by one",
"type": "main",
"index": 0
}
]
]
},
"Remove unneccessary fields for the prompt": {
"main": [
[
{
"node": "Scraper AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Prepare the scraped output for Google Sheets": {
"main": [
[
{
"node": "Add confidence score to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Add record if the confidence score is below 85%": {
"main": [
[
{
"node": "Space requests by 5 seconds",
"type": "main",
"index": 0
}
]
]
},
"Override the record if the confidence score is equal or greater than 85%": {
"main": [
[
{
"node": "Space requests by 5 seconds",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
AI个性化多产品邮件营销
基于SMTP轮换的AI个性化多产品邮件营销（GPT-4o/o3-mini）
If
Code
Wait
+16
41 节点Badr
销售
