Erweiterte Integration von Website-Formularen in Pipedrive CRM mit internationalem Telefon und WhatsApp

• •Discord Bot Token oder Webhook

{
  "meta": {
    "instanceId": "393ca9e36a1f81b0f643c72792946a5fe5e49eb4864181ba4032e5a408278263"
  },
  "nodes": [
    {
      "id": "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357",
      "name": "Datenverfeinerung",
      "type": "n8n-nodes-base.set",
      "position": [
        -1840,
        1248
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "691e681b-b79e-4372-8afd-bdbaf0881c11",
              "name": "Prenom",
              "type": "string",
              "value": "={{ $json.payload.data['Prénom'] }}"
            },
            {
              "id": "c425fd31-6f20-4bc7-939d-ff3bdf63314e",
              "name": "Nom",
              "type": "string",
              "value": "={{ $json.payload.data.Nom }}"
            },
            {
              "id": "65ee47ca-19e9-490a-b647-0cb383ca21a6",
              "name": "Entreprise",
              "type": "string",
              "value": "={{ $json.payload.data.Entreprise }}"
            },
            {
              "id": "f0b97b9e-f621-42a9-b53e-1a32b277b588",
              "name": "Mail professionnel",
              "type": "string",
              "value": "={{ $json.payload.data['Mail professionnel'] }}"
            },
            {
              "id": "e25cb1ae-0514-485a-b93c-18bdb6ec16ba",
              "name": "Téléphone",
              "type": "string",
              "value": "={{ $json.payload.data['Téléphone pro'] }}"
            },
            {
              "id": "729eb9b0-0a3a-4f38-8fcb-226a6574c9c9",
              "name": "URL du site internet",
              "type": "string",
              "value": "={{ $json.payload.data['URL du site internet'] }}"
            },
            {
              "id": "91c587be-2a62-4dcd-b16e-7c644e0bbcda",
              "name": "Message",
              "type": "string",
              "value": "={{ $json.payload.data.Message }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "de704664-66bd-4d59-a5a7-201de6d6161d",
      "name": "Organisation erstellen",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -912,
        1248
      ],
      "parameters": {
        "name": "={{ $('Data refinement').item.json.Entreprise }}",
        "resource": "organization",
        "additionalFields": {}
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "b6ec98ec-2ab0-420c-828c-2b8432301938",
      "name": "Formular-Trigger",
      "type": "n8n-nodes-base.webflowTrigger",
      "position": [
        -2416,
        1248
      ],
      "webhookId": "53bcc9fa-3e52-451e-800d-8c747b173ff9",
      "parameters": {
        "site": "6825df5b20329ba581df4914"
      },
      "credentials": {
        "webflowOAuth2Api": {
          "id": "CbSzY9RPrUDbhOdg",
          "name": "Growth AI"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "91ceb3e7-1350-4256-be7b-cbeebbcb7722",
      "name": "Organisation suchen",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -1312,
        1248
      ],
      "parameters": {
        "term": "={{ $('Data refinement').item.json.Entreprise }}",
        "limit": 10,
        "resource": "organization",
        "operation": "search",
        "additionalFields": {
          "exactMatch": true
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "78aa5756-4696-4fe3-b8c8-80e8d29fb0ce",
      "name": "Wenn Organisation existiert",
      "type": "n8n-nodes-base.if",
      "position": [
        -1120,
        1248
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a2b14d78-0253-480a-bb37-c64dee0f50dd",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.name }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "d2fc20b3-e4b6-4c96-88ee-21dbe9f4cc2d",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        2656
      ],
      "parameters": {
        "color": 4,
        "width": 1248,
        "height": 768,
        "content": "# Scenario D: New Organization + New Person"
      },
      "typeVersion": 1
    },
    {
      "id": "88474f56-643f-4862-b98b-b9cce056abac",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        1760
      ],
      "parameters": {
        "width": 1248,
        "height": 784,
        "content": "# Scenario C: New Organization + Existing Person"
      },
      "typeVersion": 1
    },
    {
      "id": "a9e02897-ed76-47f0-87ec-c0bfce47f3bc",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        832
      ],
      "parameters": {
        "color": 2,
        "width": 1248,
        "height": 784,
        "content": "# Scenario B: Existing Organization + New Person"
      },
      "typeVersion": 1
    },
    {
      "id": "f969c2c4-0f8a-4b04-9b72-1b6749e193bc",
      "name": "Notiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        -32
      ],
      "parameters": {
        "color": 3,
        "width": 1248,
        "height": 784,
        "content": "# Scenario A: Existing Organization + Existing Person"
      },
      "typeVersion": 1
    },
    {
      "id": "4da77fb9-37aa-42f6-8160-f8287bcf8dd0",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2608,
        1120
      ],
      "parameters": {
        "width": 576,
        "height": 272,
        "content": "# Phase 1: Form Submission Trigger"
      },
      "typeVersion": 1
    },
    {
      "id": "7cb3c91a-6130-496a-a4e1-fcaf366c4f17",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2608,
        1424
      ],
      "parameters": {
        "width": 576,
        "height": 448,
        "content": "### What you do:\nComplete the contact form on the website with your business information\nProvide required details including name, company, email, phone, website URL, and message\nSubmit the form to initiate the automated lead processing\n\n### What the system does:\nReceives form data via Webflow webhook trigger (adaptable to other form platforms)\nCaptures all submitted information including contact details and business context\nInitiates the automated lead processing workflow immediately\nPrepares data for CRM integration and intelligent routing\n\n### Result:\n✅ Lead data captured automatically from any form platform\n✅ Immediate workflow activation upon form submission\n✅ All contact information secured and ready for processing\n✅ No manual data entry required for lead management\n"
      },
      "typeVersion": 1
    },
    {
      "id": "62e80f6d-f201-4efa-8f34-0d7464fa640a",
      "name": "Notiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1984,
        1120
      ],
      "parameters": {
        "color": 2,
        "width": 576,
        "height": 272,
        "content": "# Phase 2: Data Processing and Phone Number Formatting"
      },
      "typeVersion": 1
    },
    {
      "id": "10c7d1e3-0f6a-499c-b9db-dd3007d1026c",
      "name": "Notiz7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1984,
        1424
      ],
      "parameters": {
        "color": 2,
        "width": 576,
        "height": 320,
        "content": "### What the system does:\nExtracts and cleans all form field data into standardized format\nProcesses phone numbers intelligently using advanced international formatting\nDetects country codes automatically from phone number patterns\nFormats phone numbers with proper international prefixes (+33, +1, +44, etc.)\nHandles multiple international formats including French, European, and global numbers\nApplies fallback formatting for unrecognized number patterns\n\n### Result:\n✅ Clean, standardized contact data ready for CRM integration\n✅ International phone numbers properly formatted for WhatsApp messaging\n✅ Consistent data quality across all lead records\n✅ Automatic handling of various phone number formats\n"
      },
      "typeVersion": 1
    },
    {
      "id": "f2b7d25d-22c1-404a-ac84-ae537b03607e",
      "name": "Notiz8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        1120
      ],
      "parameters": {
        "color": 5,
        "width": 576,
        "height": 272,
        "content": "# Phase 3: Organization Discovery and Management"
      },
      "typeVersion": 1
    },
    {
      "id": "065ad4dc-fd70-43e5-a0dc-e23307ca9dc9",
      "name": "Notiz9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        1424
      ],
      "parameters": {
        "color": 5,
        "width": 576,
        "height": 144,
        "content": "### What the system does:\nSearches existing CRM (Pipedrive) for the company name\nUses exact matching to identify existing organizations\nRoutes workflow based on organization existence\nCreates new organization if none exists with matching name"
      },
      "typeVersion": 1
    },
    {
      "id": "d49d1e83-8203-485a-86bc-cf85b3f43020",
      "name": "Notiz10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        -32
      ],
      "parameters": {
        "color": 3,
        "width": 1248,
        "height": 784,
        "content": "# Searches for the person within the known organization\n# Links existing records for deal creation\n# Maintains data consistency across related records"
      },
      "typeVersion": 1
    },
    {
      "id": "022dd480-0b7f-4559-b7d0-04af60c299a4",
      "name": "Notiz11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        832
      ],
      "parameters": {
        "color": 2,
        "width": 1248,
        "height": 784,
        "content": "# Creates new person record linked to existing organization\n# Preserves organizational relationships and history\n# Adds new contact to established company structure"
      },
      "typeVersion": 1
    },
    {
      "id": "3fa4b9de-ca43-4aba-bfc3-f3c5ccfea6ab",
      "name": "Notiz12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        1760
      ],
      "parameters": {
        "width": 1248,
        "height": 784,
        "content": "# Creates new organization for the company\n# Links existing person to new organization structure\n# Handles cases where person exists but company is new\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e6c2a386-62c9-4fb0-a452-dfab5bf47011",
      "name": "Notiz13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        2656
      ],
      "parameters": {
        "color": 4,
        "width": 1248,
        "height": 768,
        "content": "# Creates both organization and person records from scratch\n# Establishes complete new relationship in CRM\n# Sets up full contact and company structure"
      },
      "typeVersion": 1
    },
    {
      "id": "818000c7-9a76-4744-bd93-63737abf18e1",
      "name": "Notiz14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        832
      ],
      "parameters": {
        "color": 7,
        "width": 784,
        "height": 1632,
        "content": "# Phase 4: Person Record Management"
      },
      "typeVersion": 1
    },
    {
      "id": "6fdde360-211b-4194-a8db-ab586b6e6c5e",
      "name": "Notiz16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        2528
      ],
      "parameters": {
        "color": 7,
        "width": 784,
        "height": 384,
        "content": "### What the system does:\nSearches for existing persons by full name within relevant organization\nCreates new person records when no match is found\nUpdates existing records with new information when person exists\nAssociates persons with correct organizations automatically\nMaintains custom properties including lead source tracking\nAdds formatted phone numbers and email addresses\n\n### Result:\n✅ Accurate person record management without duplicates\n✅ Complete contact information captured and updated\n✅ Proper organizational relationships maintained\n✅ Lead source tracking for attribution analysis"
      },
      "typeVersion": 1
    },
    {
      "id": "3412b661-5724-4bad-a86b-8494a199da01",
      "name": "Notiz15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        -208
      ],
      "parameters": {
        "color": 6,
        "width": 2592,
        "height": 3664,
        "content": "# Phase 5: Lead Communication and Engagement Management\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9465a0ef-d701-454f-9211-795a2940335d",
      "name": "Notiz17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        3488
      ],
      "parameters": {
        "color": 6,
        "width": 2592,
        "height": 528,
        "content": "### What the system does:\nAnalyzes form submission for additional context including messages and website URLs\nCreates comprehensive notes attached to deals preserving all submitted information\nAdds website URL references for business context and competitive research\nSends formatted notifications to Discord sales channel with complete lead details\nProvides immediate team alerts for new prospect activity and coordination\nDelivers personalized WhatsApp messages to leads using properly formatted phone numbers\nSends welcome messages acknowledging inquiries and setting follow-up expectations\nUses personalized messaging with lead's actual name for enhanced engagement\nMaintains professional communication standards across all channels\n\n### Result:\n✅ Complete lead context and intelligence preserved in CRM system\n✅ Instant team awareness with structured information sharing\n✅ Immediate, personalized response to every lead inquiry\n✅ Professional first impression via modern messaging channels\n✅ Sales team has access to original inquiry details and website information\n✅ Collaborative lead qualification process enabled across team\n✅ Clear expectations set for Customer Success Manager follow-up\n✅ Enhanced lead engagement and response rates through multi-channel approach\n✅ Fast response time capability maintaining competitive advantage"
      },
      "typeVersion": 1
    },
    {
      "id": "994dbd5f-d5c3-42f2-a5d5-cb24a804ae2c",
      "name": "Internationale Vorwahl",
      "type": "n8n-nodes-base.code",
      "position": [
        -1600,
        1248
      ],
      "parameters": {
        "jsCode": "// Nœud Code n8n pour formater les numéros de téléphone avec indicatifs\n// Copiez ce code dans un nœud \"Code\" de n8n\n\n// Configuration des indicatifs par pays/région\nconst countryPrefixes = {\n  // France\n  'FR': {\n    prefix: '+33',\n    patterns: [\n      /^0[1-9]/,           // 01, 02, 03, 04, 05, 06, 07, 08, 09\n      /^[1-9]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+33${cleaned}`;\n    }\n  },\n  \n  // Pays frontaliers de la France\n  // Belgique\n  'BE': {\n    prefix: '+32',\n    patterns: [\n      /^0[2-9]/,           // 02, 03, 04, etc.\n      /^[2-9]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+32${cleaned}`;\n    }\n  },\n  \n  // Suisse\n  'CH': {\n    prefix: '+41',\n    patterns: [\n      /^0[1-9]/,           // 01, 02, etc.\n      /^[1-9]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+41${cleaned}`;\n    }\n  },\n  \n  // Luxembourg\n  'LU': {\n    prefix: '+352',\n    patterns: [\n      /^[2-9]/,            // Commencent par 2-9 (pas de 0 initial)\n      /^6[0-9]/            // Mobiles commencent par 6\n    ],\n    format: (number) => {\n      return `+352${number}`;\n    }\n  },\n  \n  // Allemagne\n  'DE': {\n    prefix: '+49',\n    patterns: [\n      /^0[1-9]/,           // 01, 02, etc.\n      /^[1-9]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+49${cleaned}`;\n    }\n  },\n  \n  // Espagne\n  'ES': {\n    prefix: '+34',\n    patterns: [\n      /^[67]/,             // Mobiles commencent par 6 ou 7\n      /^[89]/              // Fixes commencent par 8 ou 9\n    ],\n    format: (number) => {\n      return `+34${number}`;\n    }\n  },\n  \n  // Italie\n  'IT': {\n    prefix: '+39',\n    patterns: [\n      /^0[1-9]/,           // Fixes commencent par 0\n      /^3[0-9]/            // Mobiles commencent par 3\n    ],\n    format: (number) => {\n      return `+39${number}`;\n    }\n  },\n  \n  // Portugal\n  'PT': {\n    prefix: '+351',\n    patterns: [\n      /^2[1-9]/,           // Fixes région Lisbonne (21, 22, etc.)\n      /^9[1-6]/,           // Mobiles (91, 92, 93, 96)\n      /^[89][0-9]/         // Autres fixes\n    ],\n    format: (number) => {\n      return `+351${number}`;\n    }\n  },\n  \n  // Pays francophones d'Afrique du Nord\n  // Maroc\n  'MA': {\n    prefix: '+212',\n    patterns: [\n      /^0[5-7]/,           // 05, 06, 07\n      /^[5-7]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+212${cleaned}`;\n    }\n  },\n  \n  // Algérie\n  'DZ': {\n    prefix: '+213',\n    patterns: [\n      /^0[1-9]/,           // 01, 02, etc.\n      /^[5-7]/             // Mobiles 5, 6, 7\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+213${cleaned}`;\n    }\n  },\n  \n  // Tunisie\n  'TN': {\n    prefix: '+216',\n    patterns: [\n      /^[2-5]/,            // Fixes régionaux (20, 21, 22, etc.)\n      /^[9]/               // Mobiles commencent par 9\n    ],\n    format: (number) => {\n      return `+216${number}`;\n    }\n  },\n  \n  // Autres pays (conservés)\n  // Canada\n  'CA': {\n    prefix: '+1',\n    patterns: [\n      /^1[0-9]{10}$/,      // 1 + 10 chiffres\n      /^[0-9]{10}$/        // 10 chiffres sans le 1\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^1/, '');\n      return `+1${cleaned}`;\n    }\n  },\n  \n  // États-Unis\n  'US': {\n    prefix: '+1',\n    patterns: [\n      /^1[0-9]{10}$/,      // 1 + 10 chiffres\n      /^[0-9]{10}$/        // 10 chiffres sans le 1\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^1/, '');\n      return `+1${cleaned}`;\n    }\n  },\n  \n  // Royaume-Uni\n  'GB': {\n    prefix: '+44',\n    patterns: [\n      /^0[1-9]/,           // 01, 02, etc.\n      /^[1-9]/             // Sans le 0 initial\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+44${cleaned}`;\n    }\n  },\n\n  // Pays asiatiques et du Moyen-Orient\n  // Qatar\n  'QA': {\n    prefix: '+974',\n    patterns: [\n      /^[3567]/,           // Mobiles commencent par 3, 5, 6, 7\n      /^4[0-9]/            // Fixes commencent par 4\n    ],\n    format: (number) => {\n      return `+974${number}`;\n    }\n  },\n\n  // Maldives\n  'MV': {\n    prefix: '+960',\n    patterns: [\n      /^[79]/,             // Mobiles commencent par 7 ou 9\n      /^3[0-9]/            // Fixes commencent par 3\n    ],\n    format: (number) => {\n      return `+960${number}`;\n    }\n  },\n\n  // Pakistan\n  'PK': {\n    prefix: '+92',\n    patterns: [\n      /^0[1-9]/,           // Fixes avec 0 initial\n      /^3[0-9]/            // Mobiles commencent par 3\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+92${cleaned}`;\n    }\n  },\n\n  // Inde\n  'IN': {\n    prefix: '+91',\n    patterns: [\n      /^0[1-9]/,           // Fixes avec 0 initial\n      /^[6-9]/             // Mobiles commencent par 6, 7, 8, 9\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+91${cleaned}`;\n    }\n  },\n\n  // Hong Kong\n  'HK': {\n    prefix: '+852',\n    patterns: [\n      /^[2-3]/,            // Fixes commencent par 2 ou 3\n      /^[5-9]/             // Mobiles commencent par 5, 6, 9\n    ],\n    format: (number) => {\n      return `+852${number}`;\n    }\n  },\n\n  // Corée du Sud\n  'KR': {\n    prefix: '+82',\n    patterns: [\n      /^0[1-9]/,           // Fixes avec 0 initial\n      /^1[0-9]/            // Mobiles commencent par 1\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+82${cleaned}`;\n    }\n  },\n\n  // Japon\n  'JP': {\n    prefix: '+81',\n    patterns: [\n      /^0[1-9]/,           // Fixes avec 0 initial\n      /^[789][0-9]/        // Mobiles commencent par 7, 8, 9\n    ],\n    format: (number) => {\n      let cleaned = number.replace(/^0/, '');\n      return `+81${cleaned}`;\n    }\n  }\n};\n\n/**\n * Nettoie un numéro de téléphone en supprimant tous les caractères non numériques\n * @param {string} phoneNumber - Numéro de téléphone brut\n * @returns {string} - Numéro nettoyé\n */\nfunction cleanPhoneNumber(phoneNumber) {\n  if (!phoneNumber || typeof phoneNumber !== 'string') {\n    return '';\n  }\n  \n  // Supprimer tous les caractères non numériques sauf le + au début\n  let cleaned = phoneNumber.trim();\n  \n  // Si le numéro commence déjà par +, on le garde tel quel\n  if (cleaned.startsWith('+')) {\n    return cleaned.replace(/[^\\d+]/g, '');\n  }\n  \n  // Sinon, supprimer tous les caractères non numériques\n  return cleaned.replace(/[^\\d]/g, '');\n}\n\n/**\n * Détecte le pays et formate le numéro de téléphone\n * @param {string} phoneNumber - Numéro de téléphone nettoyé\n * @returns {Object} - Objet avec le numéro formaté et les informations du pays\n */\nfunction detectAndFormatPhoneNumber(phoneNumber) {\n  // Si le numéro commence déjà par +, on considère qu'il est déjà formaté\n  if (phoneNumber.startsWith('+')) {\n    return {\n      formatted: phoneNumber,\n      detected_country: 'Already formatted',\n      confidence: 'high'\n    };\n  }\n  \n  // Parcourir chaque pays pour trouver une correspondance\n  for (const [countryCode, config] of Object.entries(countryPrefixes)) {\n    for (const pattern of config.patterns) {\n      if (pattern.test(phoneNumber)) {\n        return {\n          formatted: config.format(phoneNumber),\n          detected_country: countryCode,\n          confidence: 'high',\n          original: phoneNumber\n        };\n      }\n    }\n  }\n  \n  // Si aucun pattern ne correspond, essayer de deviner par la longueur\n  const length = phoneNumber.length;\n  \n  // Longueurs typiques par défaut (France comme fallback pour l'Europe)\n  if (length === 10 && phoneNumber.startsWith('0')) {\n    return {\n      formatted: countryPrefixes.FR.format(phoneNumber),\n      detected_country: 'FR',\n      confidence: 'medium',\n      original: phoneNumber,\n      reason: 'Fallback: 10 digits starting with 0 (assumed French)'\n    };\n  }\n  \n  if (length === 9 && !phoneNumber.startsWith('0')) {\n    return {\n      formatted: `+33${phoneNumber}`,\n      detected_country: 'FR',\n      confidence: 'low',\n      original: phoneNumber,\n      reason: 'Fallback: 9 digits without 0 (assumed French mobile)'\n    };\n  }\n  \n  // Si on ne peut pas détecter, retourner le numéro original avec un avertissement\n  return {\n    formatted: phoneNumber,\n    detected_country: 'Unknown',\n    confidence: 'none',\n    original: phoneNumber,\n    warning: 'Could not detect country, returned original number'\n  };\n}\n\n// Code principal du nœud n8n\nconst items = $input.all();\nconst processedItems = [];\n\nfor (const item of items) {\n  try {\n    // Récupérer le numéro de téléphone depuis l'objet spécifié\n    const rawPhoneNumber = $input.first().json['Téléphone'];\n    \n    if (!rawPhoneNumber) {\n      processedItems.push({\n        ...item,\n        json: {\n          ...item.json,\n          phone_formatted: '+330000000000'\n        }\n      });\n      continue;\n    }\n    \n    // Nettoyer et formater le numéro\n    const cleanedNumber = cleanPhoneNumber(rawPhoneNumber);\n    \n    if (!cleanedNumber) {\n      processedItems.push({\n        ...item,\n        json: {\n          ...item.json,\n          phone_formatted: '+330000000000'\n        }\n      });\n      continue;\n    }\n    \n    // Détecter et formater\n    const result = detectAndFormatPhoneNumber(cleanedNumber);\n    \n    // Ajouter seulement le numéro formaté à l'item\n    processedItems.push({\n      ...item,\n      json: {\n        ...item.json,\n        // Numéro formaté avec indicatif\n        phone_formatted: result.formatted\n      }\n    });\n    \n  } catch (error) {\n    // En cas d'erreur, retourner le numéro par défaut\n    processedItems.push({\n      ...item,\n      json: {\n        ...item.json,\n        phone_formatted: '+330000000000'\n      }\n    });\n  }\n}\n\nreturn processedItems;\n\n// Exemple de ce que vous obtiendrez en sortie :\n/*\n{\n  \"phone_formatted\": \"+33612345678\"\n}\n\n// En cas d'erreur ou numéro non trouvé :\n{\n  \"phone_formatted\": \"+330000000000\"\n}\n*/"
      },
      "typeVersion": 2
    },
    {
      "id": "dcd04de8-4352-41cf-a245-32a0795ad0e8",
      "name": "Person suchen Szenario C & D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -240,
        2240
      ],
      "parameters": {
        "term": "={{ $('Data refinement').item.json.Prenom }} {{ $('Data refinement').item.json.Nom }}",
        "limit": 10,
        "resource": "person",
        "operation": "search",
        "additionalFields": {
          "exactMatch": true
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "executeOnce": false,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "73ddab8a-2301-40cf-a613-8fe10baeba32",
      "name": "Wenn Person existiert Szenario C & D",
      "type": "n8n-nodes-base.if",
      "position": [
        16,
        2240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a2b14d78-0253-480a-bb37-c64dee0f50dd",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.name }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "aa3f2a32-5c17-4790-965a-f18a887c9ee2",
      "name": "Person erstellen Szenario D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        384,
        2768
      ],
      "parameters": {
        "name": "={{ $('Data refinement').item.json.Prenom }} {{ $('Data refinement').item.json.Nom }}",
        "resource": "person",
        "additionalFields": {
          "email": [
            "={{ $('Data refinement').item.json['Mail professionnel'] }}"
          ],
          "phone": [],
          "org_id": "={{ $('Create Organization').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0cd3c69b-384a-4eff-afec-52fd03add7ec",
      "name": "Deal erstellen Szenario D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        704,
        2768
      ],
      "parameters": {
        "title": "={{ $('Data refinement').item.json.Entreprise }} - Lead",
        "person_id": "={{ $('Create a person Scenario D').item.json.id }}",
        "associateWith": "person",
        "additionalFields": {}
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3e33dc33-8365-4113-9846-394fab72dc29",
      "name": "Wenn Nachricht Szenario D",
      "type": "n8n-nodes-base.if",
      "position": [
        1152,
        2704
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "6c99e1a3-364d-46d8-97c2-beffdc4048b2",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json.Message }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "8f64bd92-c925-4832-9096-010985431561",
      "name": "Nachricht notieren Szenario D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1376,
        2704
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json.Message }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario D').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2442bc7d-93af-4ddb-81d2-b4af1992369e",
      "name": "Wenn URL Szenario D",
      "type": "n8n-nodes-base.if",
      "position": [
        1152,
        2896
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "536bcc29-bcaf-4b40-8395-136eeba12491",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "495e1826-ddcb-43eb-b550-42661d8d6e26",
      "name": "URL notieren Szenario D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1376,
        2896
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json.payload.data['URL du site internet'] }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario D').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1d439cef-9282-47da-ab7a-7cb4a296fcb3",
      "name": "Team benachrichtigen Szenario D",
      "type": "n8n-nodes-base.discord",
      "position": [
        1152,
        3056
      ],
      "webhookId": "c8b277a4-ce7e-455e-9ed7-b207426dc7f4",
      "parameters": {
        "content": "=🚨 NOUVELLE DEMANDE DE CONTACT (formulaire)🚨\n\nPrénom : {{ $('Data refinement').item.json.Prenom }}\n\nNom : {{ $('Data refinement').item.json.Nom }}\n\nEntreprise : {{ $('Data refinement').item.json.Entreprise }}\n\nMail : {{ $('Data refinement').item.json['Mail professionnel'] }}\n\nTéléphone : {{ $('Data refinement').item.json['Téléphone'] }}\n\nURL : {{ $('Data refinement').item.json.payload.data['URL du site internet'] }}\n\nMessage : {{ $('Data refinement').item.json.Message }}",
        "guildId": {
          "__rl": true,
          "mode": "list",
          "value": "1377297267014504520",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520",
          "cachedResultName": "Growth AI"
        },
        "options": {},
        "resource": "message",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "1380469490139009106",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520/1380469490139009106",
          "cachedResultName": "🤑-nouveaux-prospects"
        }
      },
      "credentials": {
        "discordBotApi": {
          "id": "pnY6XafKnApsBts5",
          "name": "Bender Growth AI"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "20154343-6928-4c75-b473-44fbc8b3ab24",
      "name": "Nachricht senden Szenario D",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1376,
        3056
      ],
      "webhookId": "56f0f58b-c818-4151-a993-d1061bb81a3f",
      "parameters": {
        "textBody": "=Hello {{ $('Data refinement').item.json.Prenom }},\n\nHere is how you can transform you days into an amazing journey...",
        "operation": "send",
        "phoneNumberId": "752773604591912",
        "additionalFields": {},
        "recipientPhoneNumber": "={{ $('international dialing code').item.json.phone_formatted }}"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "jcnpyvSgT2JMrgFR",
          "name": "WhatsApp Growth Ai"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "90cb6fcc-8e31-4d7f-9c48-08db3cbc4ed6",
      "name": "Person aktualisieren Szenario D",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1152,
        3232
      ],
      "parameters": {
        "personId": "={{ $('Create a person Scenario D').item.json.id }}",
        "resource": "person",
        "operation": "update",
        "updateFields": {
          "phone": [
            "={{ $('Data refinement').item.json['Téléphone'] }}"
          ]
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "08038dd4-5867-476c-8a98-78c4f6fb0c11",
      "name": "Deal erstellen Szenario C",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        688,
        2128
      ],
      "parameters": {
        "title": "={{ $('Data refinement').item.json.Entreprise }} - Lead",
        "person_id": "={{ $('Search Person Scenario C & D').item.json.id }}",
        "associateWith": "person",
        "additionalFields": {}
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "70210f12-f793-4947-a493-011e73ae5ed5",
      "name": "Wenn Nachricht Szenario C",
      "type": "n8n-nodes-base.if",
      "position": [
        1152,
        1776
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "6c99e1a3-364d-46d8-97c2-beffdc4048b2",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json.Message }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "5839114f-261d-48ef-a693-2120a719834d",
      "name": "Nachricht notieren Szenario C",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1376,
        1776
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json.Message }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario C').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0ee6cfa5-c4e3-40ad-bc13-6d4913013645",
      "name": "Wenn URL Szenario C",
      "type": "n8n-nodes-base.if",
      "position": [
        1152,
        2000
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "536bcc29-bcaf-4b40-8395-136eeba12491",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "3ef82172-e694-473b-b355-27f0a8540ff7",
      "name": "URL notieren Szenario C",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1392,
        1984
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json['URL du site internet'] }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario C').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2f547ba7-6a30-4f4d-b8f0-43333fcdcc7d",
      "name": "Team benachrichtigen Szenario C",
      "type": "n8n-nodes-base.discord",
      "position": [
        1152,
        2160
      ],
      "webhookId": "c8b277a4-ce7e-455e-9ed7-b207426dc7f4",
      "parameters": {
        "content": "=🚨 NOUVELLE DEMANDE DE CONTACT (formulaire)🚨\n\nPrénom : {{ $('Data refinement').item.json.Prenom }}\n\nNom : {{ $('Data refinement').item.json.Nom }}\n\nEntreprise : {{ $('Data refinement').item.json.Entreprise }}\n\nMail : {{ $('Data refinement').item.json['Mail professionnel'] }}\n\nTéléphone : {{ $('Data refinement').item.json['Téléphone'] }}\n\nURL : {{ $('Data refinement').item.json['URL du site internet'] }}\n\nMessage : {{ $('Data refinement').item.json.Message }}",
        "guildId": {
          "__rl": true,
          "mode": "list",
          "value": "1377297267014504520",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520",
          "cachedResultName": "Growth AI"
        },
        "options": {},
        "resource": "message",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "1380469490139009106",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520/1380469490139009106",
          "cachedResultName": "🤑-nouveaux-prospects"
        }
      },
      "credentials": {
        "discordBotApi": {
          "id": "pnY6XafKnApsBts5",
          "name": "Bender Growth AI"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "b2584b2b-8f18-4b7c-a246-e082615531b1",
      "name": "Nachricht senden Szenario C",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1392,
        2160
      ],
      "webhookId": "56f0f58b-c818-4151-a993-d1061bb81a3f",
      "parameters": {
        "textBody": "=Hello {{ $('Data refinement').item.json.Prenom }},\n\nHere is how you can transform you days into an amazing journey...",
        "operation": "send",
        "phoneNumberId": "752773604591912",
        "additionalFields": {},
        "recipientPhoneNumber": "={{ $('international dialing code').item.json.phone_formatted }}"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "jcnpyvSgT2JMrgFR",
          "name": "WhatsApp Growth Ai"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0c344cee-2a83-43ea-9e33-f146bf11bf90",
      "name": "Person aktualisieren Szenario C",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1152,
        2368
      ],
      "parameters": {
        "personId": "={{ $('Search Person Scenario C & D').item.json.id }}",
        "resource": "person",
        "operation": "update",
        "updateFields": {
          "phone": [
            "={{ $('international dialing code').item.json.phone_formatted }}"
          ],
          "customProperties": {
            "property": [
              {
                "name": "c17f379e66fb0fa2c7e6ddfd986f7aa581086dd4",
                "value": "Growth Ai"
              }
            ]
          }
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2630a20f-54c7-4db8-86fa-64f274ed776a",
      "name": "Person suchen Szenario A & B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -240,
        992
      ],
      "parameters": {
        "term": "={{ $('Data refinement').item.json.Prenom }} {{ $('Data refinement').item.json.Nom }}",
        "resource": "person",
        "operation": "search",
        "additionalFields": {
          "exactMatch": true
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "executeOnce": false,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "e45f6fdc-7016-4996-a024-b793f5dbe79a",
      "name": "Wenn Person existiert Szenario A & B",
      "type": "n8n-nodes-base.if",
      "position": [
        0,
        992
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a2b14d78-0253-480a-bb37-c64dee0f50dd",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.name }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "ab7bfd6e-b0f1-45e9-bf26-a252abd0e46b",
      "name": "Person erstellen Szenario B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        384,
        1168
      ],
      "parameters": {
        "name": "={{ $('Data refinement').item.json.Prenom }} {{ $('Data refinement').item.json.Nom }}",
        "resource": "person",
        "additionalFields": {
          "email": [
            "={{ $('Data refinement').item.json['Mail professionnel'] }}"
          ],
          "phone": [],
          "org_id": "={{ $('Search an organization').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "baededf0-8b8d-4236-8eaf-164689c9b6f7",
      "name": "Deal erstellen Szenario B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        688,
        1168
      ],
      "parameters": {
        "title": "={{ $('Data refinement').item.json.Entreprise }} - Lead",
        "person_id": "={{ $('Create a person Scenario B').item.json.id }}",
        "associateWith": "person",
        "additionalFields": {}
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "141ee09b-1723-41de-98bc-d5778ece5d73",
      "name": "Wenn Nachricht Szenario B",
      "type": "n8n-nodes-base.if",
      "position": [
        1136,
        896
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "6c99e1a3-364d-46d8-97c2-beffdc4048b2",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json.Message }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "9d7d46df-cc34-4217-bcda-7ab0c0e14241",
      "name": "Nachricht notieren Szenario B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1360,
        880
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json.Message }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario B').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ef96c292-4ca0-4d59-a73c-9cc475c877ea",
      "name": "Wenn URL Szenario B",
      "type": "n8n-nodes-base.if",
      "position": [
        1136,
        1072
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "536bcc29-bcaf-4b40-8395-136eeba12491",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0d7cbbce-2843-4bca-8f56-1f6fa04748f5",
      "name": "URL notieren Szenario B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1360,
        1072
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json['URL du site internet'] }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario B').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0828af19-07cf-464c-b00c-e891c0415a56",
      "name": "Team benachrichtigen Szenario B",
      "type": "n8n-nodes-base.discord",
      "position": [
        1136,
        1264
      ],
      "webhookId": "c8b277a4-ce7e-455e-9ed7-b207426dc7f4",
      "parameters": {
        "content": "=🚨 NOUVELLE DEMANDE DE CONTACT (formulaire)🚨\n\nPrénom : {{ $('Data refinement').item.json.Prenom }}\n\nNom : {{ $('Data refinement').item.json.Nom }}\n\nEntreprise : {{ $('Data refinement').item.json.Entreprise }}\n\nMail : {{ $('Data refinement').item.json['Mail professionnel'] }}\n\nTéléphone : {{ $('Data refinement').item.json['Téléphone'] }}\n\nURL : {{ $('Data refinement').item.json.payload.data['URL du site internet'] }}\n\nMessage : {{ $('Data refinement').item.json.Message }}",
        "guildId": {
          "__rl": true,
          "mode": "list",
          "value": "1377297267014504520",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520",
          "cachedResultName": "Growth AI"
        },
        "options": {},
        "resource": "message",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "1380469490139009106",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520/1380469490139009106",
          "cachedResultName": "🤑-nouveaux-prospects"
        }
      },
      "credentials": {
        "discordBotApi": {
          "id": "pnY6XafKnApsBts5",
          "name": "Bender Growth AI"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "1aba00fc-e30e-47f0-9f27-8aef6640ff09",
      "name": "Nachricht senden Szenario B",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1360,
        1264
      ],
      "webhookId": "56f0f58b-c818-4151-a993-d1061bb81a3f",
      "parameters": {
        "textBody": "=Hello {{ $('Data refinement').item.json.Prenom }},\n\nHere is how you can transform you days into an amazing journey...",
        "operation": "send",
        "phoneNumberId": "752773604591912",
        "additionalFields": {},
        "recipientPhoneNumber": "={{ $('international dialing code').item.json.phone_formatted }}"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "jcnpyvSgT2JMrgFR",
          "name": "WhatsApp Growth Ai"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f0e98d2a-a148-4d78-8d32-650d3208c66a",
      "name": "Person aktualisieren Szenario B",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1136,
        1456
      ],
      "parameters": {
        "personId": "={{ $('Create a person Scenario B').item.json.id }}",
        "resource": "person",
        "operation": "update",
        "updateFields": {
          "phone": [
            "={{ $('international dialing code').item.json.phone_formatted }}"
          ]
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "fa978fb6-6a5f-40e7-bd54-2fc929a61e07",
      "name": "Deal erstellen Szenario A",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        704,
        224
      ],
      "parameters": {
        "title": "={{ $('Data refinement').item.json.Entreprise }} - Lead ",
        "person_id": "={{ $('Search Person Scenario A & B').item.json.id }}",
        "associateWith": "person",
        "additionalFields": {}
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "beb9bd6d-c829-4bdd-b570-0597c89dce24",
      "name": "Wenn Nachricht Szenario A",
      "type": "n8n-nodes-base.if",
      "position": [
        1136,
        64
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "6c99e1a3-364d-46d8-97c2-beffdc4048b2",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json.Message }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1df56ecf-0e15-4dd5-b03f-3d892cfe6710",
      "name": "Nachricht notieren Szenario A",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1360,
        64
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json.Message }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario A').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f928b70c-2951-4fb8-ace6-c1a91f084921",
      "name": "Wenn URL Szenario A",
      "type": "n8n-nodes-base.if",
      "position": [
        1136,
        240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "536bcc29-bcaf-4b40-8395-136eeba12491",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "a2921fe2-5d45-422f-ad01-756ba12410cf",
      "name": "URL notieren Szenario A",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1360,
        240
      ],
      "parameters": {
        "content": "={{ $('Data refinement').item.json['URL du site internet'] }}",
        "resource": "note",
        "additionalFields": {
          "deal_id": "={{ $('Create Deal Scenario A').item.json.id }}"
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2fb83600-8924-4712-be6b-bc654858bc39",
      "name": "Team benachrichtigen Szenario A",
      "type": "n8n-nodes-base.discord",
      "position": [
        1136,
        400
      ],
      "webhookId": "c8b277a4-ce7e-455e-9ed7-b207426dc7f4",
      "parameters": {
        "content": "=🚨 NOUVELLE DEMANDE DE CONTACT (formulaire)🚨\n\nPrénom : {{ $('Data refinement').item.json.Prenom }}\n\nNom : {{ $('Data refinement').item.json.Nom }}\n\nEntreprise : {{ $('Data refinement').item.json.Entreprise }}\n\nMail : {{ $('Data refinement').item.json['Mail professionnel'] }}\n\nTéléphone : {{ $('Data refinement').item.json['Téléphone'] }}\n\nURL : {{ $('Data refinement').item.json.payload.data['URL du site internet'] }}\n\nMessage : {{ $('Data refinement').item.json.Message }}",
        "guildId": {
          "__rl": true,
          "mode": "list",
          "value": "1377297267014504520",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520",
          "cachedResultName": "Growth AI"
        },
        "options": {},
        "resource": "message",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "1380469490139009106",
          "cachedResultUrl": "https://discord.com/channels/1377297267014504520/1380469490139009106",
          "cachedResultName": "🤑-nouveaux-prospects"
        }
      },
      "credentials": {
        "discordBotApi": {
          "id": "pnY6XafKnApsBts5",
          "name": "Bender Growth AI"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "56d73440-031e-4204-bf8d-62bb860235d1",
      "name": "Nachricht senden Szenario A",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1360,
        400
      ],
      "webhookId": "56f0f58b-c818-4151-a993-d1061bb81a3f",
      "parameters": {
        "textBody": "=Hello {{ $('Data refinement').item.json.Prenom }},\n\nHere is how you can transform you days into an amazing journey...",
        "operation": "send",
        "phoneNumberId": "752773604591912",
        "additionalFields": {},
        "recipientPhoneNumber": "={{ $('international dialing code').item.json.phone_formatted }}"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "jcnpyvSgT2JMrgFR",
          "name": "WhatsApp Growth Ai"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3ef4dd6e-4712-422e-a716-e58acd338204",
      "name": "Person aktualisieren Szenario A",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        1136,
        576
      ],
      "parameters": {
        "personId": "={{ $('Search Person Scenario A & B').item.json.id }}",
        "resource": "person",
        "operation": "update",
        "updateFields": {
          "phone": [
            "={{ $('international dialing code').item.json.phone_formatted }}"
          ],
          "customProperties": {
            "property": [
              {
                "name": "c17f379e66fb0fa2c7e6ddfd986f7aa581086dd4",
                "value": "Growth Ai"
              }
            ]
          }
        }
      },
      "credentials": {
        "pipedriveApi": {
          "id": "i6m1kGabR1OKHcuL",
          "name": "Pipedrive"
        }
      },
      "typeVersion": 1
    }
  ],
  "pinData": {
    "Form Trigger": [
      {
        "payload": {
          "id": "68b9d1a1d76875f049e5f0cc",
          "data": {
            "Nom": "Vaccarizi",
            "Message": "test",
            "Prénom": "Allan",
            "Entreprise": "Growth AI",
            "Téléphone pro": "0760762438",
            "Mail professionnel": "allan@growth-ai.fr",
            "URL du site internet": "agence-n8n.com"
          },
          "name": "Formulaire de contact",
          "formId": "688b54011dc104dda0fd6c2e",
          "pageId": "6825df5c20329ba581df4a27",
          "schema": [],
          "siteId": "6825df5b20329ba581df4914",
          "submittedAt": "2025-09-04T17:51:29.315Z",
          "formElementId": "2ae14dd8-eaf6-16be-e556-3949bccd583a",
          "publishedPath": "/"
        },
        "triggerType": "form_submission"
      }
    ]
  },
  "connections": {
    "b6ec98ec-2ab0-420c-828c-2b8432301938": {
      "main": [
        [
          {
            "node": "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357": {
      "main": [
        [
          {
            "node": "994dbd5f-d5c3-42f2-a5d5-cb24a804ae2c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f928b70c-2951-4fb8-ace6-c1a91f084921": {
      "main": [
        [
          {
            "node": "a2921fe2-5d45-422f-ad01-756ba12410cf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ef96c292-4ca0-4d59-a73c-9cc475c877ea": {
      "main": [
        [
          {
            "node": "0d7cbbce-2843-4bca-8f56-1f6fa04748f5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0ee6cfa5-c4e3-40ad-bc13-6d4913013645": {
      "main": [
        [
          {
            "node": "3ef82172-e694-473b-b355-27f0a8540ff7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2442bc7d-93af-4ddb-81d2-b4af1992369e": {
      "main": [
        [
          {
            "node": "495e1826-ddcb-43eb-b550-42661d8d6e26",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de704664-66bd-4d59-a5a7-201de6d6161d": {
      "main": [
        [
          {
            "node": "dcd04de8-4352-41cf-a245-32a0795ad0e8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "beb9bd6d-c829-4bdd-b570-0597c89dce24": {
      "main": [
        [
          {
            "node": "1df56ecf-0e15-4dd5-b03f-3d892cfe6710",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "141ee09b-1723-41de-98bc-d5778ece5d73": {
      "main": [
        [
          {
            "node": "9d7d46df-cc34-4217-bcda-7ab0c0e14241",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "70210f12-f793-4947-a493-011e73ae5ed5": {
      "main": [
        [
          {
            "node": "5839114f-261d-48ef-a693-2120a719834d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3e33dc33-8365-4113-9846-394fab72dc29": {
      "main": [
        [
          {
            "node": "8f64bd92-c925-4832-9096-010985431561",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fa978fb6-6a5f-40e7-bd54-2fc929a61e07": {
      "main": [
        [
          {
            "node": "beb9bd6d-c829-4bdd-b570-0597c89dce24",
            "type": "main",
            "index": 0
          },
          {
            "node": "f928b70c-2951-4fb8-ace6-c1a91f084921",
            "type": "main",
            "index": 0
          },
          {
            "node": "2fb83600-8924-4712-be6b-bc654858bc39",
            "type": "main",
            "index": 0
          },
          {
            "node": "3ef4dd6e-4712-422e-a716-e58acd338204",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "baededf0-8b8d-4236-8eaf-164689c9b6f7": {
      "main": [
        [
          {
            "node": "141ee09b-1723-41de-98bc-d5778ece5d73",
            "type": "main",
            "index": 0
          },
          {
            "node": "ef96c292-4ca0-4d59-a73c-9cc475c877ea",
            "type": "main",
            "index": 0
          },
          {
            "node": "0828af19-07cf-464c-b00c-e891c0415a56",
            "type": "main",
            "index": 0
          },
          {
            "node": "f0e98d2a-a148-4d78-8d32-650d3208c66a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "08038dd4-5867-476c-8a98-78c4f6fb0c11": {
      "main": [
        [
          {
            "node": "70210f12-f793-4947-a493-011e73ae5ed5",
            "type": "main",
            "index": 0
          },
          {
            "node": "0ee6cfa5-c4e3-40ad-bc13-6d4913013645",
            "type": "main",
            "index": 0
          },
          {
            "node": "2f547ba7-6a30-4f4d-b8f0-43333fcdcc7d",
            "type": "main",
            "index": 0
          },
          {
            "node": "0c344cee-2a83-43ea-9e33-f146bf11bf90",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0cd3c69b-384a-4eff-afec-52fd03add7ec": {
      "main": [
        [
          {
            "node": "3e33dc33-8365-4113-9846-394fab72dc29",
            "type": "main",
            "index": 0
          },
          {
            "node": "2442bc7d-93af-4ddb-81d2-b4af1992369e",
            "type": "main",
            "index": 0
          },
          {
            "node": "1d439cef-9282-47da-ab7a-7cb4a296fcb3",
            "type": "main",
            "index": 0
          },
          {
            "node": "90cb6fcc-8e31-4d7f-9c48-08db3cbc4ed6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "78aa5756-4696-4fe3-b8c8-80e8d29fb0ce": {
      "main": [
        [
          {
            "node": "2630a20f-54c7-4db8-86fa-64f274ed776a",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "de704664-66bd-4d59-a5a7-201de6d6161d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "91ceb3e7-1350-4256-be7b-cbeebbcb7722": {
      "main": [
        [
          {
            "node": "78aa5756-4696-4fe3-b8c8-80e8d29fb0ce",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2fb83600-8924-4712-be6b-bc654858bc39": {
      "main": [
        [
          {
            "node": "56d73440-031e-4204-bf8d-62bb860235d1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0828af19-07cf-464c-b00c-e891c0415a56": {
      "main": [
        [
          {
            "node": "1aba00fc-e30e-47f0-9f27-8aef6640ff09",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2f547ba7-6a30-4f4d-b8f0-43333fcdcc7d": {
      "main": [
        [
          {
            "node": "b2584b2b-8f18-4b7c-a246-e082615531b1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1d439cef-9282-47da-ab7a-7cb4a296fcb3": {
      "main": [
        [
          {
            "node": "20154343-6928-4c75-b473-44fbc8b3ab24",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab7bfd6e-b0f1-45e9-bf26-a252abd0e46b": {
      "main": [
        [
          {
            "node": "baededf0-8b8d-4236-8eaf-164689c9b6f7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aa3f2a32-5c17-4790-965a-f18a887c9ee2": {
      "main": [
        [
          {
            "node": "0cd3c69b-384a-4eff-afec-52fd03add7ec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "994dbd5f-d5c3-42f2-a5d5-cb24a804ae2c": {
      "main": [
        [
          {
            "node": "91ceb3e7-1350-4256-be7b-cbeebbcb7722",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2630a20f-54c7-4db8-86fa-64f274ed776a": {
      "main": [
        [
          {
            "node": "e45f6fdc-7016-4996-a024-b793f5dbe79a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dcd04de8-4352-41cf-a245-32a0795ad0e8": {
      "main": [
        [
          {
            "node": "73ddab8a-2301-40cf-a613-8fe10baeba32",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e45f6fdc-7016-4996-a024-b793f5dbe79a": {
      "main": [
        [
          {
            "node": "fa978fb6-6a5f-40e7-bd54-2fc929a61e07",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ab7bfd6e-b0f1-45e9-bf26-a252abd0e46b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "73ddab8a-2301-40cf-a613-8fe10baeba32": {
      "main": [
        [
          {
            "node": "08038dd4-5867-476c-8a98-78c4f6fb0c11",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "aa3f2a32-5c17-4790-965a-f18a887c9ee2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}