Extrahiere Firmenberechnungsdaten und berechne ICP

• •Keine besonderen Voraussetzungen, sofort nach Import nutzbar

{
  "id": "Ipc5s7U9UzuqexMI",
  "meta": {
    "instanceId": "28a947b92b197fc2524eaba16e57560338657b2b0b5796300b2f1cedc1d0d355",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract company data and calculate ICP",
  "tags": [],
  "nodes": [
    {
      "id": "bc969415-98e7-4160-ab92-6088ea752265",
      "name": "Bei Formularabgabe",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        -140
      ],
      "webhookId": "201fe976-0e8b-4358-9002-3b322ae25f42",
      "parameters": {
        "options": {},
        "formTitle": "LinkedIn Company Profile Extractor",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Company domain",
              "placeholder": "company.com",
              "requiredField": true
            },
            {
              "fieldLabel": "Airtop Profile (connected to Linkedin)",
              "requiredField": true
            },
            {
              "fieldLabel": "Company LinkedIn"
            }
          ]
        },
        "formDescription": "=<h2>Find Company LinkedIn URL</h2> \n<p>This automation takes a company domain and returns its LinkedIn URL.</p> "
      },
      "typeVersion": 2.2
    },
    {
      "id": "c258f7eb-9e86-41a9-ae23-0bf1b24e6b86",
      "name": "Bei Ausführung durch anderen Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        0,
        60
      ],
      "parameters": {
        "workflowInputs": {
          "values": [
            {
              "name": "Company domain"
            },
            {
              "name": "Airtop Profile (connected to Linkedin)"
            },
            {
              "name": "Company LinkedIn"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "ad5482d7-93a9-491b-81bf-9111476a000a",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        1320,
        -40
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "602d6957-e88b-4ce0-ba9c-1b665eb5b9fb",
      "name": "Unternehmens-LinkedIn-URL extrahieren",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        620,
        40
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "JuW1Q92YSk4ErvvC",
          "cachedResultName": "AIRTOP — Company LinkedIn"
        },
        "workflowInputs": {
          "value": {
            "Company domain": "={{ $('Unify Params').item.json.company_domain }}",
            "Airtop Profile (connected to Linkedin)": "={{ $('Unify Params').item.json.airtop_profile }}"
          },
          "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
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "604abdb8-3932-49e7-9a25-0338b3b0b496",
      "name": "Unternehmensinformationen extrahieren",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        1120,
        -160
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "yWtpgGwGgspx1A1W",
          "cachedResultName": "AIRTOP — Extract LinkedIn Company Information"
        },
        "workflowInputs": {
          "value": {
            "airtop_profile": "={{ $('Unify Params').item.json.airtop_profile }}",
            "company_linkedin": "={{ $json.company_linkedin }}"
          },
          "schema": [
            {
              "id": "company_linkedin",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "company_linkedin",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "airtop_profile",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "airtop_profile",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "98ce1d1a-00db-4875-b8f6-8d57435dda3c",
      "name": "ICP berechnen",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        1120,
        60
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "CYDemwO42LTGiiPR",
          "cachedResultName": "AIRTOP — Company ICP scoring"
        },
        "workflowInputs": {
          "value": {
            "airtop_profile": "={{ $('Unify Params').item.json.airtop_profile }}",
            "company_linkedin": "={{ $json.company_linkedin }}"
          },
          "schema": [
            {
              "id": "company_linkedin",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "company_linkedin",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "airtop_profile",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "airtop_profile",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": true
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2d1b8c05-cba5-4c93-8418-ce0e8585c5a0",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -240
      ],
      "parameters": {
        "width": 440,
        "height": 460,
        "content": "## Input Parameters\nRun this workflow using a form or from another workflow"
      },
      "typeVersion": 1
    },
    {
      "id": "6e7f3e1c-ebb2-4367-8090-59fc6a25ca43",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -240
      ],
      "parameters": {
        "color": 4,
        "width": 500,
        "height": 460,
        "content": "## Enrich Company Data\nExtract all information and calculate ICP score"
      },
      "typeVersion": 1
    },
    {
      "id": "ce7271c5-9580-4ca4-8092-c5c0f4697e1e",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -240
      ],
      "parameters": {
        "color": 5,
        "width": 540,
        "height": 460,
        "content": "## Find Company LinkedIn URL\nIf the link isn't found on the page, search for it externally"
      },
      "typeVersion": 1
    },
    {
      "id": "7a9c617e-eb50-4e9c-b34f-3401c840e658",
      "name": "LinkedIn-Link vorhanden?",
      "type": "n8n-nodes-base.if",
      "position": [
        440,
        -40
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "2fdc9590-6755-45b9-bfce-69275d04e414",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.company_linkedin }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6107d9a7-e216-4cda-bfdd-4b4df4fbf0d2",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -940,
        -580
      ],
      "parameters": {
        "width": 860,
        "height": 1200,
        "content": "README\n\n# Automating Company Data Enrichment and ICP Calculation\n\n## Use Case\n\nThis automation identifies a company's LinkedIn profile, extracts key business data, and calculates an ICP (Ideal Customer Profile) score to qualify and enrich company records. It is perfect for sales teams, data enrichment pipelines, and CRM integrations.\n\n## What This Automation Does\n\n### Input Parameters\n\n- **Company domain**: The company's website domain (e.g., `example.com`).\n- **Airtop Profile (connected to LinkedIn)**: Your [Airtop Profile](https://portal.airtop.ai/browser-profiles) authenticated for LinkedIn.\n- **Company LinkedIn** *(optional)*: If already known, skips search.\n\n### Output Includes\n\n- Verified LinkedIn company URL (if not provided)\n- Company profile (name, tagline, website, location, about)\n- Scale metrics (employee count and bracket)\n- Classification (automation agency status, AI focus, technical level)\n- ICP score with justifications\n- Structured JSON object with all values merged\n\n## How It Works\n\n1. **LinkedIn Detection**: If not provided, attempts to locate the LinkedIn URL using website scraping or search.\n2. **Data Extraction**: Uses Airtop to gather structured data from the company’s LinkedIn profile.\n3. **ICP Scoring**: Applies a scoring rubric based on AI/tech orientation, scale, agency status, and geography.\n4. **Merge Results**: All data components are merged into a unified output.\n\n## Setup Requirements\n\n1. [Airtop API Key](https://portal.airtop.ai/api-keys)\n2. [Airtop Profile](https://portal.airtop.ai/browser-profiles) with LinkedIn authentication\n\n## Next Steps\n\n- **Combine with Person Enrichment**: Pair with workflows that enrich individuals tied to the company.\n- **Sync to CRM**: Connect the output to your CRM for record enrichment or scoring fields.\n- **Adjust ICP Scoring Logic**: Modify the rubric for your organization's ICP model."
      },
      "typeVersion": 1
    },
    {
      "id": "653010d1-8c28-4610-aa8a-8acb7df5c4af",
      "name": "Ist gültiger LinkedIn-Link?",
      "type": "n8n-nodes-base.filter",
      "position": [
        800,
        -100
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "55e08410-2042-4a1f-b833-06bf79afc964",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.company_linkedin }}",
              "rightValue": "linkedin.com/company"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "e2b80e65-7143-4f5a-85a1-11a5722bdad1",
      "name": "Parameter vereinheitlichen",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        -40
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f7e835ee-9c35-4461-83fa-23dbcea60e95",
              "name": "company_domain",
              "type": "string",
              "value": "={{ $json[\"Company domain\"] }}"
            },
            {
              "id": "fc73097b-1fae-4897-a951-70871366401d",
              "name": "airtop_profile",
              "type": "string",
              "value": "={{ $json[\"Airtop Profile (connected to Linkedin)\"] }}"
            },
            {
              "id": "9de7678e-d26f-4457-b7c3-159e6a3ec5ae",
              "name": "company_linkedin",
              "type": "string",
              "value": "={{ $json[\"Company LinkedIn\"] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "78ab0589-075f-4788-96be-c39968a569e1",
  "connections": {
    "98ce1d1a-00db-4875-b8f6-8d57435dda3c": {
      "main": [
        [
          {
            "node": "ad5482d7-93a9-491b-81bf-9111476a000a",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "e2b80e65-7143-4f5a-85a1-11a5722bdad1": {
      "main": [
        [
          {
            "node": "7a9c617e-eb50-4e9c-b34f-3401c840e658",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bc969415-98e7-4160-ab92-6088ea752265": {
      "main": [
        [
          {
            "node": "e2b80e65-7143-4f5a-85a1-11a5722bdad1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7a9c617e-eb50-4e9c-b34f-3401c840e658": {
      "main": [
        [
          {
            "node": "653010d1-8c28-4610-aa8a-8acb7df5c4af",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "602d6957-e88b-4ce0-ba9c-1b665eb5b9fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "653010d1-8c28-4610-aa8a-8acb7df5c4af": {
      "main": [
        [
          {
            "node": "604abdb8-3932-49e7-9a25-0338b3b0b496",
            "type": "main",
            "index": 0
          },
          {
            "node": "ad5482d7-93a9-491b-81bf-9111476a000a",
            "type": "main",
            "index": 1
          },
          {
            "node": "98ce1d1a-00db-4875-b8f6-8d57435dda3c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "604abdb8-3932-49e7-9a25-0338b3b0b496": {
      "main": [
        [
          {
            "node": "ad5482d7-93a9-491b-81bf-9111476a000a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "602d6957-e88b-4ce0-ba9c-1b665eb5b9fb": {
      "main": [
        [
          {
            "node": "653010d1-8c28-4610-aa8a-8acb7df5c4af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c258f7eb-9e86-41a9-ae23-0bf1b24e6b86": {
      "main": [
        [
          {
            "node": "e2b80e65-7143-4f5a-85a1-11a5722bdad1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}