Integración avanzada de formularios web a Pipedrive CRM, con soporte para números de teléfono internacionales y WhatsApp

• •Bot Token de Discord o Webhook

{
  "meta": {
    "instanceId": "393ca9e36a1f81b0f643c72792946a5fe5e49eb4864181ba4032e5a408278263"
  },
  "nodes": [
    {
      "id": "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357",
      "name": "Refinamiento de Datos",
      "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": "Crear Organización",
      "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": "Activador de Formulario",
      "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": "Buscar una organización",
      "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": "Si la Organización existe",
      "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": "Nota Adhesiva2",
      "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": "Nota Adhesiva3",
      "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": "Nota Adhesiva4",
      "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": "Nota Adhesiva5",
      "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": "Nota Adhesiva",
      "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": "Nota Adhesiva1",
      "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": "Nota Adhesiva6",
      "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": "Nota Adhesiva7",
      "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": "Nota Adhesiva8",
      "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": "Nota Adhesiva9",
      "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": "Nota Adhesiva10",
      "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": "Nota Adhesiva11",
      "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": "Nota Adhesiva12",
      "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": "Nota Adhesiva13",
      "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": "Nota Adhesiva14",
      "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": "Nota Adhesiva16",
      "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": "Nota Adhesiva15",
      "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": "Nota Adhesiva17",
      "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": "código de marcación internacional",
      "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": "Buscar Persona Escenario C y 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": "Si la Persona existe Escenario C y 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": "Crear una persona Escenario 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": "Crear Acuerdo Escenario 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": "Si mensaje Escenario 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": "Nota mensaje Escenario 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": "Si URL Escenario 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": "Nota URL Escenario 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": "Mensaje al equipo Escenario 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": "Enviar mensaje Escenario 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": "Actualizar una persona Escenario 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": "Crear Acuerdo Escenario 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": "Si mensaje Escenario 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": "Nota mensaje Escenario 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": "Si URL Escenario 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": "Nota URL Escenario 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": "Mensaje al equipo Escenario 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": "Enviar mensaje Escenario 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": "Actualizar una persona Escenario 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": "Buscar Persona Escenario A y 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": "Si la Persona existe Escenario A y 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": "Crear una persona Escenario 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": "Crear Acuerdo Escenario 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": "Si mensaje Escenario 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": "Nota mensaje Escenario 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": "Si URL Escenario 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": "Nota URL Escenario 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": "Mensaje al equipo Escenario 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": "Enviar mensaje Escenario 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": "Actualizar una persona Escenario 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": "Crear Acuerdo Escenario 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": "Si mensaje Escenario 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": "Nota mensaje Escenario 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": "Si URL Escenario 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": "Nota URL Escenario 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": "Mensaje al equipo Escenario 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": "Enviar mensaje Escenario 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": "Actualizar una persona Escenario 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
          }
        ]
      ]
    }
  }
}