丰富公司数据
中级
这是一个Sales领域的自动化工作流，包含 13 个节点。主要使用 Set, Filter, Aggregate, FormTrigger, ExecuteWorkflow 等节点。 使用Airtop和Hubspot丰富公司数据
前置要求
- •无特殊前置要求，导入即可使用
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "bB1VfLkZ793CWekn",
"meta": {
"instanceId": "28a947b92b197fc2524eaba16e57560338657b2b0b5796300b2f1cedc1d0d355",
"templateCredsSetupCompleted": true
},
"name": "丰富公司数据",
"tags": [],
"nodes": [
{
"id": "40a24c05-6a12-4f60-b70c-03354e0a5152",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
960,
0
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData",
"destinationFieldName": ""
},
"typeVersion": 1
},
{
"id": "0365d1ef-a48f-4e04-8f50-ef731faa07bf",
"name": "公司信息",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
760,
0
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "Ipc5s7U9UzuqexMI",
"cachedResultName": "AIRTOP — Extract company data and calculate ICP"
},
"workflowInputs": {
"value": {
"Company domain": "={{ $json[\"Company domain\"] }}",
"Company LinkedIn": "={{ $json[\"Company LinkedIn\"] }}",
"Airtop Profile (connected to Linkedin)": "={{ $json[\"Airtop Profile (connected to Linkedin)\"] }}"
},
"schema": [
{
"id": "Company domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Company domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Airtop Profile (connected to Linkedin)",
"type": "string",
"display": true,
"required": false,
"displayName": "Airtop Profile (connected to Linkedin)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company LinkedIn",
"type": "string",
"display": true,
"required": false,
"displayName": "Company LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "409bf870-a1d3-433d-b0dd-46643a09d337",
"name": "保存公司到 Hubspot",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1400,
0
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "I5o15J4MI1P1GRjh",
"cachedResultName": "AIRTOP — Upsert company in Hubspot"
},
"workflowInputs": {
"value": {
"city": "={{ $json.city }}",
"name": "={{ $json.name }}",
"state": "={{ $json.state }}",
"country": "={{ $json.country }}",
"tagline": "={{ $json.tagline }}",
"website": "={{ $json.website }}",
"linkedin": "={{ $json.linkedin }}",
"icp_score": "={{ $json.icp_score }}",
"company_domain": "={{ $json.company_domain }}",
"employee_count": "={{ $json.employee_count }}",
"company_profile": "={{ $json.company_profile }}"
},
"schema": [
{
"id": "company_profile",
"type": "string",
"display": true,
"required": false,
"displayName": "company_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_domain",
"type": "string",
"display": true,
"required": false,
"displayName": "company_domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tagline",
"type": "string",
"display": true,
"required": false,
"displayName": "tagline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_count",
"type": "number",
"display": true,
"required": false,
"displayName": "employee_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "icp_score",
"type": "number",
"display": true,
"required": false,
"displayName": "icp_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "state",
"type": "string",
"display": true,
"required": false,
"displayName": "state",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "b0563618-a702-49f0-89ae-3af16d255851",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-200
],
"parameters": {
"color": 4,
"width": 220,
"height": 460,
"content": "## 仅保留企业邮箱"
},
"typeVersion": 1
},
{
"id": "e0633395-62e4-433e-a231-450f4286a083",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-200
],
"parameters": {
"color": 5,
"width": 220,
"height": 460,
"content": "## 检索公司信息"
},
"typeVersion": 1
},
{
"id": "a7f17a76-df9f-4fe8-8ea4-ff3be9ba1311",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-200
],
"parameters": {
"color": 6,
"width": 640,
"height": 460,
"content": "## 在 Hubspot 中保存信息"
},
"typeVersion": 1
},
{
"id": "6e797623-203d-409c-85b6-740a4ebde4c4",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
80,
-100
],
"webhookId": "d66867c0-c996-4836-bbd6-932c26823a83",
"parameters": {
"options": {},
"formTitle": "New contact signup",
"formFields": {
"values": [
{
"fieldLabel": "Airtop Profile (connected to Linkedin)",
"requiredField": true
},
{
"fieldLabel": "Company domain",
"requiredField": true
},
{
"fieldLabel": "Company LinkedIn"
}
]
},
"formDescription": "This automation searches for the contact's company and enriches the data accordingly"
},
"typeVersion": 2.2
},
{
"id": "7fffe483-4e4e-4524-89cf-dbb83f430619",
"name": "当被其他工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
80,
100
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "Airtop Profile (connected to Linkedin)"
},
{
"name": "Company domain"
},
{
"name": "Company LinkedIn"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "fe563760-4e3b-4fdc-ba94-d09c28a8da33",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
40,
-200
],
"parameters": {
"width": 400,
"height": 460,
"content": "## 输入参数"
},
"typeVersion": 1
},
{
"id": "de64f719-7467-4a38-8f03-4bedacc89b4e",
"name": "统一参数",
"type": "n8n-nodes-base.set",
"position": [
300,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "0033e14d-e1cc-45c8-a450-de8d60a33312",
"name": "Airtop Profile (connected to Linkedin)",
"type": "string",
"value": "={{ $json[\"Airtop Profile (connected to Linkedin)\"] }}"
},
{
"id": "f40df649-186c-4238-b331-00072a568683",
"name": "Company domain",
"type": "string",
"value": "={{ $json[\"Company domain\"] }}"
},
{
"id": "a855ff32-db29-4ef8-8a12-4db96ff84f67",
"name": "Company LinkedIn",
"type": "string",
"value": "={{ $json[\"Company LinkedIn\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1535a9d6-f0e9-4546-819f-5dad8519a55d",
"name": "映射信息",
"type": "n8n-nodes-base.set",
"position": [
1180,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d7709bb5-d093-4c3a-a081-ed555bcb4c8b",
"name": "company_profile",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.overview }}"
},
{
"id": "21ca7ea6-fb8c-4927-a0f1-9c2f66585627",
"name": "city",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.location.city }}"
},
{
"id": "f96d0cdf-52b0-466f-8202-4126659faba7",
"name": "company_domain",
"type": "string",
"value": "={{ $('Is corporate email?').item.json[\"Company domain\"] }}"
},
{
"id": "589b7797-7d80-4d15-9036-6fbe5490acc0",
"name": "name",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.name }}"
},
{
"id": "bc8d3dd6-61f5-4acf-9a51-0f2f8007517b",
"name": "country",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.location.country }}"
},
{
"id": "77f1dc98-ebde-47fa-91d1-85916e2b7b31",
"name": "tagline",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.tagline }}"
},
{
"id": "19565667-c14a-47ef-8a61-63d9cc600005",
"name": "employee_count",
"type": "number",
"value": "={{ $json[\"\"][0].scale.employee_count }}"
},
{
"id": "4493276c-313f-4981-80d2-e5c81aba0134",
"name": "icp_score",
"type": "number",
"value": "={{ $json[\"\"][2].icp_company_score }}"
},
{
"id": "5bf90342-4919-4330-bf82-2c47419980bd",
"name": "linkedin",
"type": "string",
"value": "={{ $json[\"\"][1].company_linkedin }}"
},
{
"id": "1a1b6850-c7ea-4060-8f97-a4b8410efc4f",
"name": "state",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.location.state }}"
},
{
"id": "d927bce2-823a-4e3c-80d9-b04bddaf440a",
"name": "website",
"type": "string",
"value": "={{ $json[\"\"][0].company_profile.website }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d3083a33-1a65-41e2-9458-d3563cecc110",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
-600
],
"parameters": {
"width": 860,
"height": 1140,
"content": "自述文件"
},
"typeVersion": 1
},
{
"id": "4e5348ba-c285-4068-9d90-17bed5c752c4",
"name": "是企业邮箱吗？",
"type": "n8n-nodes-base.filter",
"position": [
520,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b42f06fe-5708-4e22-8202-7585230bbabb",
"operator": {
"type": "string",
"operation": "notRegex"
},
"leftValue": "={{ $json[\"Company domain\"] }}",
"rightValue": "=\\b(gmail|hotmail|yahoo|outlook|icloud|aol|protonmail|live|msn|ya)\\b"
},
{
"id": "5128b950-9f99-419b-b34b-223382f2d4f2",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json[\"Company domain\"] }}",
"rightValue": ".edu"
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "jOzgI7as1gGhlZ91",
"executionOrder": "v1"
},
"versionId": "a161b997-14a1-4951-89a6-98fba5fa5d78",
"connections": {
"Aggregate": {
"main": [
[
{
"node": "Map information",
"type": "main",
"index": 0
}
]
]
},
"Company info": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Unify Params": {
"main": [
[
{
"node": "Is corporate email?",
"type": "main",
"index": 0
}
]
]
},
"Map information": {
"main": [
[
{
"node": "Save company Hubspot",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Unify Params",
"type": "main",
"index": 0
}
]
]
},
"Is corporate email?": {
"main": [
[
{
"node": "Company info",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Unify Params",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
丰富人员数据
使用Airtop和Hubspot丰富人员数据并更新CRM
Set
Aggregate
Form Trigger
+3
11 节点Airtop
销售
提取公司数据并计算ICP
使用Airtop提取公司数据并计算ICP评分
If
Set
Merge
+5
13 节点Airtop
销售
提取人员数据并计算ICP
使用Airtop提取人员数据并计算ICP分数
Set
Merge
Filter
+4
12 节点Airtop
销售
获取公司 LinkedIn 页面
使用 Airtop 查找公司 LinkedIn 页面
If
Set
Airtop
+5
16 节点Airtop
销售
LinkedIn个人资料发现与验证
使用Airtop查找并验证LinkedIn个人资料
Set
Airtop
Filter
+3
9 节点Airtop
销售
通过域名验证公司 LinkedIn 页面
使用 Airtop 通过域名验证 LinkedIn 公司页面
Set
Airtop
Filter
+3
9 节点Airtop
销售
工作流信息
难度等级
中级
节点数量13
分类1
节点类型7
作者
Airtop
@cesar-at-airtopAirtop provides an intelligent browser automation API for AI agents, enabling seamless web interaction, including login, navigation, and data extraction from any site, even those with complex authentication - all with natural language instructions.In simple terms, we allow you to automate anything humans can do online, on any site with just words
外部链接
在 n8n.io 查看 →
分享此工作流