Extraktion-von-Unternehmensinformationen-von-LinkedIn

• •KI-Service API Key (z.B. OpenAI, Anthropic)

{
  "id": "yWtpgGwGgspx1A1W",
  "meta": {
    "instanceId": "28a947b92b197fc2524eaba16e57560338657b2b0b5796300b2f1cedc1d0d355",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract LinkedIn Company Information",
  "tags": [],
  "nodes": [
    {
      "id": "cc28eede-9e0b-450f-9637-8bf45aa4046a",
      "name": "Bei Formularübermittlung",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        40
      ],
      "webhookId": "5a5f0133-0b83-4839-bcfb-53499390b99a",
      "parameters": {
        "options": {},
        "formTitle": "Company information",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Company's LinkedIn URL",
              "placeholder": "https://www.linkedin.com/company/airtop-ai/",
              "requiredField": true
            },
            {
              "fieldLabel": "Airtop Profile (connected to Linkedin)",
              "requiredField": true
            }
          ]
        },
        "formDescription": "=This Airtop Studio automation simplifies LinkedIn data extraction by automatically providing structured, reliable, and easily actionable data—saving significant effort, reducing errors, and enabling fast analysis and decision-making."
      },
      "typeVersion": 2.2
    },
    {
      "id": "2f698c15-0513-49ef-842f-250d7cb10b6a",
      "name": "Bei Ausführung durch einen anderen Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        0,
        240
      ],
      "parameters": {
        "workflowInputs": {
          "values": [
            {
              "name": "company_linkedin"
            },
            {
              "name": "airtop_profile"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "dabdf295-fad9-4069-9408-82d56f1c7ed8",
      "name": "Parameter vereinheitlichen",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        140
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f4bd4165-2af4-413b-8c47-dbdadda687f0",
              "name": "company_linkedin",
              "type": "string",
              "value": "={{ $json.company_linkedin || $json[\"Company's LinkedIn URL\"] }}"
            },
            {
              "id": "eeb0f94d-750b-407d-a94c-d7aa9a1782f3",
              "name": "airtop_profile",
              "type": "string",
              "value": "={{ $json.airtop_profile || $json[\"Airtop Profile (connected to Linkedin)\"] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "49b490b3-2449-49b2-9447-c789f3c14161",
      "name": "Unternehmensinformationen extrahieren",
      "type": "n8n-nodes-base.airtop",
      "position": [
        440,
        140
      ],
      "parameters": {
        "url": "={{ $json.company_linkedin }}",
        "prompt": "=# LinkedIn Company Analysis Prompt\n\nExtract and analyze the following information from the provided LinkedIn company page. Present the results in a structured JSON format.\n\n## Required Data Points\n\n### 1. Company Identity\n- Full company name (including suffixes like Inc., LLC, etc.)\n- Brand tagline/headline (directly under company name)\n- Global headquarters location \n- Company description (full \"About\" section text)\n- Primary website URL (excluding social media links)\n\n### 2. Company Scale\n- Current employee count (from LinkedIn \"X employees\" metric)\n- Employee range bracket: [0-9], [10-150], [150+]\n\n### 3. Business Classification\nEvaluate the following characteristics based on company description, recent posts, and featured content:\n\n#### Automation Agency Status\n- Boolean (true/false) classification\n- Criteria for \"true\":\n  * Company explicitly offers automation services to clients\n  * Core business model involves developing/implementing automations\n  * Primary revenue from automation consulting/development\n\n#### AI Implementation Level\nClassify as [Low/Medium/High] based on:\n- Low: No evidence of AI/automation/scraping usage\n- Medium: Uses AI/automation tools or mentions them as supplementary capabilities\n- High: Core business involves AI development, automation creation, or data harvesting services\n\n### 4. Technical Sophistication\nEvaluate overall technical capabilities as [Basic/Intermediate/Advanced/Expert] based on:\n- Technology stack mentioned\n- Technical job postings\n- Products/services complexity\n- Engineering team size\n- Technical achievements highlighted\n\n### 5. Investment Profile\nIf available, document:\n- Most recent funding round\n- Total funding amount\n- Key investors\n- Last funding date\nMark as \"Not publicly disclosed\" if information unavailable\n\n## Output Format\nReturn data in the following JSON structure, with all fields required, make sure the response contains only the json.\n\n{\n  \"company_profile\": {\n    \"name\": string,\n    \"tagline\": string,\n    \"location\": {\n      \"city\": string,\n      \"state\": string,\n      \"country\": string\n    },\n    \"overview\": string,\n    \"website\": string\n  },\n  \"scale\": {\n    \"employee_count\": number,\n    \"size_bracket\": string\n  },\n  \"classification\": {\n    \"is_automation_agency\": boolean,\n    \"ai_focus_level\": string,\n    \"technical_tier\": string\n  },\n  \"funding\": {\n    \"latest_round\": string,\n    \"total_raised\": string,\n    \"investors\": [string],\n    \"last_updated\": string\n  }\n}",
        "resource": "extraction",
        "operation": "query",
        "profileName": "={{ $json.airtop_profile }}",
        "sessionMode": "new",
        "additionalFields": {
          "outputSchema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"company_profile\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"name\": {\n          \"type\": \"string\",\n          \"description\": \"Full company name including suffixes like Inc., LLC, etc.\"\n        },\n        \"tagline\": {\n          \"type\": \"string\",\n          \"description\": \"Brand tagline or headline directly under company name.\"\n        },\n        \"location\": {\n          \"type\": \"object\",\n          \"properties\": {\n            \"city\": {\n              \"type\": \"string\"\n            },\n            \"state\": {\n              \"type\": \"string\"\n            },\n            \"country\": {\n              \"type\": \"string\"\n            }\n          },\n          \"required\": [\n            \"city\",\n            \"state\",\n            \"country\"\n          ],\n          \"additionalProperties\": false,\n          \"description\": \"Global headquarters location.\"\n        },\n        \"overview\": {\n          \"type\": \"string\",\n          \"description\": \"Full 'About' section text of the company.\"\n        },\n        \"website\": {\n          \"type\": \"string\",\n          \"description\": \"Primary website URL excluding social media links.\"\n        }\n      },\n      \"required\": [\n        \"name\",\n        \"tagline\",\n        \"location\",\n        \"overview\",\n        \"website\"\n      ],\n      \"additionalProperties\": false\n    },\n    \"scale\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"employee_count\": {\n          \"type\": \"integer\",\n          \"description\": \"Current employee count from LinkedIn 'X employees' metric.\"\n        },\n        \"size_bracket\": {\n          \"type\": \"string\",\n          \"description\": \"Employee range bracket.\"\n        }\n      },\n      \"required\": [\n        \"employee_count\",\n        \"size_bracket\"\n      ],\n      \"additionalProperties\": false\n    },\n    \"classification\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"is_automation_agency\": {\n          \"type\": \"boolean\",\n          \"description\": \"Boolean classification if the company is an automation agency.\"\n        },\n        \"ai_focus_level\": {\n          \"type\": \"string\",\n          \"description\": \"AI implementation level based on company activities.\"\n        },\n        \"technical_tier\": {\n          \"type\": \"string\",\n          \"description\": \"Overall technical capabilities.\"\n        }\n      },\n      \"required\": [\n        \"is_automation_agency\",\n        \"ai_focus_level\",\n        \"technical_tier\"\n      ],\n      \"additionalProperties\": false\n    },\n    \"funding\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"latest_round\": {\n          \"type\": \"string\",\n          \"description\": \"Most recent funding round.\"\n        },\n        \"total_raised\": {\n          \"type\": \"string\",\n          \"description\": \"Total funding amount.\"\n        },\n        \"investors\": {\n          \"type\": \"array\",\n          \"items\": {\n            \"type\": \"string\"\n          },\n          \"description\": \"Key investors.\"\n        },\n        \"last_updated\": {\n          \"type\": \"string\",\n          \"description\": \"Last funding date.\"\n        }\n      },\n      \"required\": [\n        \"latest_round\",\n        \"total_raised\",\n        \"investors\",\n        \"last_updated\"\n      ],\n      \"additionalProperties\": false\n    }\n  },\n  \"required\": [\n    \"company_profile\",\n    \"scale\",\n    \"classification\",\n    \"funding\"\n  ],\n  \"additionalProperties\": false,\n  \"$schema\": \"http://json-schema.org/draft-07/schema#\"\n}"
        }
      },
      "credentials": {
        "airtopApi": {
          "id": "Yi4YPNnovLVUjFn5",
          "name": "Airtop Official Org"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "baeb6e4d-da47-4503-a2f9-234ad7aec245",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -60
      ],
      "parameters": {
        "width": 400,
        "height": 460,
        "content": "## Input Parameters\nRun this workflow using a form or from another workflow"
      },
      "typeVersion": 1
    },
    {
      "id": "7e884f82-249b-4d2e-bbbf-a7391d9fe7b4",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        360,
        -60
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 460,
        "content": "## Extract company information from LinkedIn"
      },
      "typeVersion": 1
    },
    {
      "id": "cc01b24b-5d27-4500-bb1d-abea5dd67b45",
      "name": "Haftnotiz7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        -580
      ],
      "parameters": {
        "width": 700,
        "height": 1480,
        "content": "README\n\n# Automating LinkedIn Company Data Extraction\n\n## Use Case\n\nThis automation extracts detailed company insights from a LinkedIn company page, including identity, scale, classification, and funding data. Ideal for investors, sales teams, and market researchers.\n\n## What This Automation Does\n\nThis automation accepts the following inputs:\n\n- **Company's LinkedIn URL**: The public LinkedIn page URL of the company.\n- **Airtop Profile (connected to LinkedIn)**: Your [Airtop Profile](https://portal.airtop.ai/browser-profiles) authenticated on LinkedIn.\n\nIt then extracts and returns structured data with:\n\n### 1. Company Identity\n- Full name\n- Tagline\n- Headquarters location (city, state, country)\n- About section\n- Website\n\n### 2. Company Scale\n- Current employee count\n- Employee size bracket: [0-9], [10-150], [150+]\n\n### 3. Business Classification\n- Is the company an automation agency? (true/false)\n- AI implementation level: Low / Medium / High\n- Technical sophistication: Basic / Intermediate / Advanced / Expert\n\n### 4. Funding Profile\n- Most recent funding round\n- Total amount raised\n- Key investors\n- Last funding update date\n\n## How It Works\n\n1. Creates an Airtop session using the provided profile.\n2. Navigates to the company LinkedIn page.\n3. Executes an Airtop query to extract data.\n4. Outputs the result in a standardized JSON schema.\n\n## Setup Requirements\n\n1. [Airtop API Key](https://portal.airtop.ai/api-keys)\n2. A [LinkedIn-authenticated Airtop Profile](https://portal.airtop.ai/browser-profiles)\n\n## Next Steps\n\n- **Feed into CRM**: Enrich your accounts with detailed LinkedIn data.\n- **Prioritize Leads**: Use classification and funding data to prioritize outreach.\n- **Combine with People Data**: Integrate with individual-level enrichment for full context.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "2173abea-5684-4111-92a9-4c538fa14edc",
      "name": "Ausgabe zuordnen",
      "type": "n8n-nodes-base.set",
      "position": [
        660,
        140
      ],
      "parameters": {
        "mode": "raw",
        "options": {},
        "jsonOutput": "={{ $json.data.modelResponse }}\n"
      },
      "typeVersion": 3.4
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d90f923d-0b38-4b5f-b404-c89a6f811d74",
  "connections": {
    "dabdf295-fad9-4069-9408-82d56f1c7ed8": {
      "main": [
        [
          {
            "node": "49b490b3-2449-49b2-9447-c789f3c14161",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cc28eede-9e0b-450f-9637-8bf45aa4046a": {
      "main": [
        [
          {
            "node": "dabdf295-fad9-4069-9408-82d56f1c7ed8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "49b490b3-2449-49b2-9447-c789f3c14161": {
      "main": [
        [
          {
            "node": "2173abea-5684-4111-92a9-4c538fa14edc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2f698c15-0513-49ef-842f-250d7cb10b6a": {
      "main": [
        [
          {
            "node": "dabdf295-fad9-4069-9408-82d56f1c7ed8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}