Extraction de données d'entreprise et calcul de ICP

• •Aucun prérequis spécial, prêt à l'emploi après importation

{
  "id": "Ipc5s7U9UzuqexMI",
  "meta": {
    "instanceId": "28a947b92b197fc2524eaba16e57560338657b2b0b5796300b2f1cedc1d0d355",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract company data and calculate ICP",
  "tags": [],
  "nodes": [
    {
      "id": "bc969415-98e7-4160-ab92-6088ea752265",
      "name": "À la soumission du formulaire",
      "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": "Lorsqu'exécuté par un autre 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": "Fusionner",
      "type": "n8n-nodes-base.merge",
      "position": [
        1320,
        -40
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "602d6957-e88b-4ce0-ba9c-1b665eb5b9fb",
      "name": "Extraire l'url LinkedIn de l'entreprise",
      "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": "Extraire les informations de l'entreprise",
      "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": "Calculer l'ICP",
      "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": "Note adhésive",
      "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": "Note adhésive1",
      "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": "Note adhésive2",
      "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": "Le lien LinkedIn existe-t-il ?",
      "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": "Note adhésive3",
      "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": "Le lien LinkedIn est-il valide ?",
      "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": "Unifier les paramètres",
      "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
          }
        ]
      ]
    }
  }
}