국제 전화 및 WhatsApp 지원을 포함한 웹사이트 양식에서 Pipedrive CRM으로의 고급 통합
고급
이것은Miscellaneous, Multimodal AI분야의자동화 워크플로우로, 62개의 노드를 포함합니다.주로 If, Set, Code, Discord, WhatsApp 등의 노드를 사용하며. 网站表单로Pipedrive CRM의高级통합，支持国际电话및WhatsApp
사전 요구사항
- •Discord Bot Token 또는 Webhook
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"meta": {
"instanceId": "393ca9e36a1f81b0f643c72792946a5fe5e49eb4864181ba4032e5a408278263"
},
"nodes": [
{
"id": "fe4e1bc8-20fa-4a68-905d-ec3ddfac1357",
"name": "데이터 정제",
"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": "조직 생성",
"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": "폼 트리거",
"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": "조직 검색",
"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": "조직 존재 여부 확인",
"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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트",
"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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "스티키 노트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": "국제 전화 코드",
"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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 D URL 여부 확인",
"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": "시나리오 D URL 노트",
"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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 C URL 여부 확인",
"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": "시나리오 C URL 노트",
"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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 B URL 여부 확인",
"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": "시나리오 B URL 노트",
"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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 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": "시나리오 A URL 여부 확인",
"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": "시나리오 A URL 노트",
"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": "시나리오 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": "시나리오 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": "시나리오 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
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 기타, 멀티모달 AI
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
Google 광고 캠페인 리포트 자동 생성至 Google 스프레드시트 (Airtable 고객 관리 포함)
Google 광고 캠페인 보고서 자동 생성로 Google 스프레드시트 (Airtable 고객 관리 포함)
If
Code
Wait
+
If
Code
Wait
31 노드Growth AI
기타
Discord 및 Google 뉴스용 Claude 4 AI 분석을 통한 자동화된 뉴스 모니터링
Discord 및 Google 뉴스를 위한 Claude 4 AI 분석을 포함한 자동화된 뉴스 모니터링
Code
Discord
Aggregate
+
Code
Discord
Aggregate
30 노드Growth AI
기타
경쟁사 콘텐츠 격차 분석기: 자동화된 웹사이트 주제 매핑
Gemini AI, Apify, Google Sheets를 사용한 경쟁사 콘텐츠 격차 분석
If
Set
Code
+
If
Set
Code
30 노드Mychel Garzon
기타
부동산 검색기 크롤러 도우미
PropertyFinder.ae, OpenRouter 및 SerpAPI를 사용하여 AI로 부동산 질문에 답변
If
Set
Code
+
If
Set
Code
18 노드George Zargaryan
기타
X 트윗 및 Meta Threads 게시器
Late API 및 Google Sheets를 사용하여 플랫폼 최적화 콘텐츠를 X 및 Threads에 자동 게시
If
Set
Code
+
If
Set
Code
20 노드Fariez
소셜 미디어
HTTP Last-Modified 확인을 사용하여 Google Sheets에서 채용 공고 만료 및 새로고침 알림 가져오기
Google Sheets, HTTP 확인 및 Gmail을 통한 채용 공고 만료 알림 자동화
If
Set
Code
+
If
Set
Code
19 노드WeblineIndia
인사
