アウトプットデータから従業員データを抽出・ICPを算出
中級
これはSales分野の自動化ワークフローで、12個のノードを含みます。主にSet, Merge, Filter, FormTrigger, ExecuteWorkflowなどのノードを使用。 Airtopを使って人員データを抽出し、ICPスコアを計算
前提条件
- •特別な前提条件なし、インポートしてすぐに使用可能
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "UY2lflocNrJbhBkQ",
"meta": {
"instanceId": "28a947b92b197fc2524eaba16e57560338657b2b0b5796300b2f1cedc1d0d355"
},
"name": "Extract person data and calculate ICP",
"tags": [],
"nodes": [
{
"id": "dab22b77-5792-48a8-9827-360b39a1f4d3",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
-40,
40
],
"webhookId": "578979b3-39f8-46cf-89a0-61e8871a468e",
"parameters": {
"options": {},
"formTitle": "Linkedin Profile Extractor",
"formFields": {
"values": [
{
"fieldLabel": "Person Name",
"requiredField": true
},
{
"fieldLabel": "Work Email",
"requiredField": true
},
{
"fieldLabel": "Airtop Profile (connected to Linkedin)",
"requiredField": true
}
]
},
"formDescription": "<h2>Enrich New User's Data</h2>\n<p>This automation adds important information about a customer using name and work email address</p>\n\n<p>The automation requires an Airtop Profile name that is authenticated on Linkedin. Don't have one? Create a free Profile and log-in to X at - <a href=\"https://portal.airtop.ai/browser-profiles\">https://portal.airtop.ai/browser-profiles</a></p>\n"
},
"typeVersion": 2.2
},
{
"id": "c6cbab26-ea9b-4574-aa6c-7f91b8f0302c",
"name": "他のワークフローから実行時",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-40,
240
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "person_name"
},
{
"name": "work_email"
},
{
"name": "Airtop_profile"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "b31a18d5-c85d-4664-95d4-190450cdb6ab",
"name": "パラメータの統一",
"type": "n8n-nodes-base.set",
"position": [
180,
140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e612bf63-72bd-4b61-82c9-786a90b58b7b",
"name": "Person_name",
"type": "string",
"value": "={{ $json[\"Person Name\"] || $json.person_name }}"
},
{
"id": "b8287f93-4ea5-40af-be1b-80ced616ec1a",
"name": "Work_email",
"type": "string",
"value": "={{ $json[\"Work Email\"] || $json.work_email }}"
},
{
"id": "567e5e7d-4efd-4d0a-a93c-6c7aed02c305",
"name": "Airtop_profile",
"type": "string",
"value": "={{ $json[\"Airtop Profile (connected to Linkedin)\"] || $json.Airtop_profile }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0f7dfe34-b88d-4be0-96fd-a54044f332f9",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-40
],
"parameters": {
"width": 660,
"height": 480,
"content": "## Input Parameters\n** Run this workflow using a form or from another workflow"
},
"typeVersion": 1
},
{
"id": "5848a514-c1e5-4265-a771-3e0de46eb1f5",
"name": "人員データの抽出",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1060,
0
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "OGfsyvA3tBbLytSo",
"cachedResultName": "AIRTOP — Extract LinkedIn Profile Information"
},
"workflowInputs": {
"value": {
"Linkedin_URL": "={{ $('Find Person Linkedin URL').item.json.data.modelResponse }}",
"Airtop_profile": "={{ $('Unify Parameters').item.json.Airtop_profile }}"
},
"schema": [
{
"id": "Linkedin_URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Linkedin_URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Airtop_profile",
"type": "string",
"display": true,
"required": false,
"displayName": "Airtop_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "c702cf9a-ccb6-47c0-8af6-4c3b6d76894b",
"name": "Find Person Linkedin URL",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
620,
140
],
"parameters": {
"mode": "each",
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "BTxosiCF2PaCkBWJ",
"cachedResultName": "AIRTOP — LinkedIn Profile Discovery w Verification"
},
"workflowInputs": {
"value": {
"Person_info": "={{ $json.Person_name }} - {{ $json.Work_email }}",
"Airtop_profile": "={{ $json.Airtop_profile }}"
},
"schema": [
{
"id": "Person_info",
"type": "string",
"display": true,
"required": false,
"displayName": "Person_info",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Airtop_profile",
"type": "string",
"display": true,
"required": false,
"displayName": "Airtop_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "db7f2856-4087-4bb7-a955-258b1ba6e96e",
"name": "ICPスコアリング",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1060,
260
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "io8TtPZaVjpZaVrf",
"cachedResultName": "AIRTOP — Person ICP Scoring with Linkedin"
},
"workflowInputs": {
"value": {
"Linkedin_URL": "={{ $('Find Person Linkedin URL').item.json.data.modelResponse }}",
"Airtop_profile": "={{ $('Unify Parameters').item.json.Airtop_profile }}"
},
"schema": [
{
"id": "Linkedin_URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Linkedin_URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Airtop_profile",
"type": "string",
"display": true,
"required": false,
"displayName": "Airtop_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
}
},
"typeVersion": 1.2
},
{
"id": "3aaa689c-aedb-4d40-b7c4-fb50ab805ed1",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
1280,
140
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.1
},
{
"id": "85d13c4c-4ed7-48a4-a3a2-d5d8c0dd90b3",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
-40
],
"parameters": {
"color": 4,
"width": 860,
"height": 480,
"content": "## Enrich Person Data\n** Find Linkedin Profile, extract all information and calculate ICP score"
},
"typeVersion": 1
},
{
"id": "dac0877b-b090-41f8-a1bc-72f9051420f9",
"name": "企業メールか？",
"type": "n8n-nodes-base.filter",
"position": [
400,
140
],
"parameters": {
"options": {
"ignoreCase": true
},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e1d8bcc5-dfd1-466b-acfb-afc7a31f6539",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@gmail.com"
},
{
"id": "92883c4b-0753-40c2-8508-68ac70eb92a9",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@qq.com"
},
{
"id": "4f457d3d-1a88-42bb-a296-abce7ffaba68",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@hotmail."
},
{
"id": "976a267e-ac44-429f-965b-beac68eb5aac",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@proton.me"
},
{
"id": "8a5de40e-d533-444a-b8bf-fbdffde19d89",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@msn."
},
{
"id": "96903481-2bc1-4445-a9c8-240f49551e30",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@yahoo."
},
{
"id": "39c6a4f8-dd44-4809-b530-073755b5a791",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": "@aol."
},
{
"id": "d9ad3a5b-0407-42a2-b5a2-a8ae9735dfcf",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": ".edu"
},
{
"id": "11cdc4db-8f55-4de2-a60e-d41545acce5c",
"operator": {
"type": "string",
"operation": "notEndsWith"
},
"leftValue": "={{ $json.Work_email }}",
"rightValue": ".net"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "49915a61-79d0-492d-ae2b-5281a216f1d8",
"name": "有効なLinkedin URLか？",
"type": "n8n-nodes-base.filter",
"position": [
840,
140
],
"parameters": {
"options": {
"ignoreCase": true
},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c4c7e69b-3823-430f-82e6-83b0ebd0a5e5",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.data.modelResponse }}",
"rightValue": ""
},
{
"id": "340f952e-7922-4597-9a32-6b5c60f79dc7",
"operator": {
"type": "string",
"operation": "notStartsWith"
},
"leftValue": "={{ $json.data.modelResponse }}",
"rightValue": "NA"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6a34a9ec-b2a6-492b-8c26-3898139dd0d7",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-280
],
"parameters": {
"width": 700,
"height": 1040,
"content": "README\n\n# Automating LinkedIn Enrichment and ICP Scoring\n\n## Use Case\n\nThis automation enriches a person’s data using LinkedIn and calculates an Ideal Customer Profile (ICP) score based on their professional presence. It is particularly useful for lead qualification, contact research, and targeted outreach.\n\n## What This Automation Does\n\nThe automation processes the following input parameters:\n\n- **Person Name**: Full name of the individual.\n- **Work Email**: Business email address to validate corporate identity.\n- **Airtop Profile (connected to Linkedin)**: A [LinkedIn-authenticated Airtop Profile](https://portal.airtop.ai/browser-profiles) for enrichment.\n\n## How It Works\n\n1. **Email Filtering**: Checks if the email is corporate (excludes free and personal domains).\n2. **LinkedIn Profile Discovery**: Searches and verifies the correct LinkedIn URL using Airtop.\n3. **Data Enrichment**: Extracts professional details from the LinkedIn profile.\n4. **ICP Scoring**: Calculates an ICP score based on extracted data and profile context.\n5. **Merge Outputs**: Consolidates enriched profile data and ICP results into a single output.\n\n## Setup Requirements\n\n1. [Airtop API Key](https://portal.airtop.ai/api-keys)\n2. An [Airtop Profile](https://portal.airtop.ai/browser-profiles) authenticated on LinkedIn.\n\n## Next Steps\n\n- **Combine with CRM Integration**: Push enriched and scored data into CRMs like HubSpot or Salesforce.\n- **Batch Processing**: Automate for lists of leads using Airtop + n8n or Airtop SDK.\n- **Scoring Customization**: Adjust scoring logic to reflect your ideal customer attributes more precisely.\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9d019e18-0c9e-4fc4-8e2e-27d7154316bc",
"connections": {
"db7f2856-4087-4bb7-a955-258b1ba6e96e": {
"main": [
[
{
"node": "3aaa689c-aedb-4d40-b7c4-fb50ab805ed1",
"type": "main",
"index": 2
}
]
]
},
"b31a18d5-c85d-4664-95d4-190450cdb6ab": {
"main": [
[
{
"node": "dac0877b-b090-41f8-a1bc-72f9051420f9",
"type": "main",
"index": 0
}
]
]
},
"dab22b77-5792-48a8-9827-360b39a1f4d3": {
"main": [
[
{
"node": "b31a18d5-c85d-4664-95d4-190450cdb6ab",
"type": "main",
"index": 0
}
]
]
},
"5848a514-c1e5-4265-a771-3e0de46eb1f5": {
"main": [
[
{
"node": "3aaa689c-aedb-4d40-b7c4-fb50ab805ed1",
"type": "main",
"index": 0
}
]
]
},
"dac0877b-b090-41f8-a1bc-72f9051420f9": {
"main": [
[
{
"node": "c702cf9a-ccb6-47c0-8af6-4c3b6d76894b",
"type": "main",
"index": 0
}
]
]
},
"49915a61-79d0-492d-ae2b-5281a216f1d8": {
"main": [
[
{
"node": "5848a514-c1e5-4265-a771-3e0de46eb1f5",
"type": "main",
"index": 0
},
{
"node": "db7f2856-4087-4bb7-a955-258b1ba6e96e",
"type": "main",
"index": 0
},
{
"node": "3aaa689c-aedb-4d40-b7c4-fb50ab805ed1",
"type": "main",
"index": 1
}
]
]
},
"c702cf9a-ccb6-47c0-8af6-4c3b6d76894b": {
"main": [
[
{
"node": "49915a61-79d0-492d-ae2b-5281a216f1d8",
"type": "main",
"index": 0
}
]
]
},
"c6cbab26-ea9b-4574-aa6c-7f91b8f0302c": {
"main": [
[
{
"node": "b31a18d5-c85d-4664-95d4-190450cdb6ab",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 営業
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
企業データを抽出し、ICPを計算
Airtop を使用して企業データを抽出し、ICP スコアを計算する
If
Set
Merge
+
If
Set
Merge
13 ノードAirtop
営業
企業データを充実させる
AirtopとHubspotを使って会社データを補完する
Set
Filter
Aggregate
+
Set
Filter
Aggregate
13 ノードAirtop
営業
会社のLinkedInページの情報を取得
Airtop を使って企業の LinkedIn ページを検索
If
Set
Airtop
+
If
Set
Airtop
16 ノードAirtop
営業
人物データを豊富にする
AirtopとHubspotを使って人物データを豊富にし、CRMを更新する
Set
Aggregate
Form Trigger
+
Set
Aggregate
Form Trigger
11 ノードAirtop
営業
LinkedInプロフィール発見と検証
AirtopでLinkedInプロフィールを検索し、検証
Set
Airtop
Filter
+
Set
Airtop
Filter
9 ノードAirtop
営業
Overpassリードジェネレーションシステム
OpenStreetMap データを使ってビジネスリードを生成して Google Sheets に保存
If
Set
Code
+
If
Set
Code
27 ノードAkram Kadri
営業
ワークフロー情報
難易度
中級
ノード数12
カテゴリー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で表示 →
このワークフローを共有