Intégration avancée de formulaires de site web vers Pipedrive CRM, avec support pour les numéros de téléphone internationaux et WhatsApp
Avancé
Ceci est unMiscellaneous, Multimodal AIworkflow d'automatisation du domainecontenant 62 nœuds.Utilise principalement des nœuds comme If, Set, Code, Discord, WhatsApp. Intégration avancée des formulaires site web vers Pipedrive CRM, soutien international et WhatsApp
Prérequis
- •Token Bot Discord ou Webhook
Nœuds utilisés (62)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"meta": {
"instanceId": "393ca9e36a1f81b0f643c72792946a5fe5e49eb4864181ba4032e5a408278263"
},
"nodes": [
{
"id": "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357",
"name": "Raffinement des données",
"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": "Créer une organisation",
"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": "Déclencheur de formulaire",
"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": "Rechercher une organisation",
"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 l'organisation 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": "Note adhésive 2",
"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": "Note adhésive 3",
"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": "Note adhésive 4",
"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": "Note adhésive 5",
"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": "Note adhésive",
"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": "Note adhésive 1",
"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": "Note adhésive 6",
"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": "Note adhésive 7",
"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": "Note adhésive 8",
"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": "Note adhésive 9",
"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": "Note adhésive 10",
"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": "Note adhésive 11",
"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": "Note adhésive 12",
"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": "Note adhésive 13",
"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": "Note adhésive 14",
"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": "Note adhésive 16",
"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": "Note adhésive 15",
"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": "Note adhésive 17",
"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": "Indicatif téléphonique international",
"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": "Rechercher une personne Scénario 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": "Si la personne existe Scénario 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": "Créer une personne Scénario 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": "Créer une affaire Scénario 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 message Scénario 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": "Noter le message Scénario 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 Scénario 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": "Noter l'URL Scénario 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": "Notifier l'équipe Scénario 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": "Envoyer un message Scénario 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": "Mettre à jour une personne Scénario 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": "Créer une affaire Scénario 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 message Scénario 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": "Noter le message Scénario 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 Scénario 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": "Noter l'URL Scénario 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": "Notifier l'équipe Scénario 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": "Envoyer un message Scénario 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": "Mettre à jour une personne Scénario 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": "Rechercher une personne Scénario 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": "Si la personne existe Scénario 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": "Créer une personne Scénario 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": "Créer une affaire Scénario 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 message Scénario 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": "Noter le message Scénario 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 Scénario 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": "Noter l'URL Scénario 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": "Notifier l'équipe Scénario 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": "Envoyer un message Scénario 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": "Mettre à jour une personne Scénario 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": "Créer une affaire Scénario 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 message Scénario 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": "Noter le message Scénario 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 Scénario 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": "Noter l'URL Scénario 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": "Notifier l'équipe Scénario 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": "Envoyer un message Scénario 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": "Mettre à jour une personne Scénario 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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Divers, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Génération automatisée de rapports de campagnes Google Ads vers Google Sheets (avec la gestion des clients Airtable)
Génération automatisée des rapports de campagnes Google Ads vers Google Sheets (avec gestion des clients Airtable)
If
Code
Wait
+
If
Code
Wait
31 NœudsGrowth AI
Divers
Surveillance automatisée des actualités avec analyse Claude 4 AI pour Discord et Google News
Surveillance automatisée de l'actualité et analyse avec Claude 4 AI pour Discord et Google News
Code
Discord
Aggregate
+
Code
Discord
Aggregate
30 NœudsGrowth AI
Divers
Analyseur d'écart de contenu concurrentiel : mappage automatisé des thèmes de sites web
Analyser les écarts de contenu concurrentiel avec Gemini AI, Apify et Google Sheets
If
Set
Code
+
If
Set
Code
30 NœudsMychel Garzon
Divers
Assistant scraper pour la recherche de biens immobiliers
Utiliser PropertyFinder.ae, OpenRouter et SerpAPI pour répondre aux questions sur l'immobilier via l'IA
If
Set
Code
+
If
Set
Code
18 NœudsGeorge Zargaryan
Divers
Éditeur de publications X (Twitter) et Meta Threads
Publication automatique de contenu optimisé pour la plateforme sur X et Threads avec Late API et Google Sheets
If
Set
Code
+
If
Set
Code
20 NœudsFariez
Réseaux sociaux
Vérification d'expiration et rafraîchissement des offres d'emploi provenant de Google Sheets en utilisant le contrôle HTTP Last-Modified
Automatisation des rappels pour les offres d'emploi expirées avec Google Sheets, vérifications HTTP et Gmail
If
Set
Code
+
If
Set
Code
19 NœudsWeblineIndia
Ressources Humaines
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds62
Catégorie2
Types de nœuds8
Description de la difficulté
Auteur
Growth AI
@growthaiLiens externes
Voir sur n8n.io →
Partager ce workflow