ウェブフォームからPipedrive CRMへの高度な統合、国際電話やWhatsAppもサポート
上級
これはMiscellaneous, Multimodal AI分野の自動化ワークフローで、62個のノードを含みます。主にIf, Set, Code, Discord, WhatsAppなどのノードを使用。 Webフォームから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": "URLの場合 シナリオD",
"type": "n8n-nodes-base.if",
"position": [
1152,
2896
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "536bcc29-bcaf-4b40-8395-136eeba12491",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "495e1826-ddcb-43eb-b550-42661d8d6e26",
"name": "URLを付箋 シナリオ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": "チームへメッセージ シナリオ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": "URLの場合 シナリオC",
"type": "n8n-nodes-base.if",
"position": [
1152,
2000
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "536bcc29-bcaf-4b40-8395-136eeba12491",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3ef82172-e694-473b-b355-27f0a8540ff7",
"name": "URLを付箋 シナリオ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": "チームへメッセージ シナリオ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": "URLの場合 シナリオB",
"type": "n8n-nodes-base.if",
"position": [
1136,
1072
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "536bcc29-bcaf-4b40-8395-136eeba12491",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0d7cbbce-2843-4bca-8f56-1f6fa04748f5",
"name": "URLを付箋 シナリオ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": "チームへメッセージ シナリオ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": "URLの場合 シナリオA",
"type": "n8n-nodes-base.if",
"position": [
1136,
240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "536bcc29-bcaf-4b40-8395-136eeba12491",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Data refinement').item.json['URL du site internet'] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a2921fe2-5d45-422f-ad01-756ba12410cf",
"name": "URLを付箋 シナリオ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": "チームへメッセージ シナリオ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
その他
自動ニュース監視とClaude 4 AIアナリティクス、DiscordとGoogleニュースへ
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
ソーシャルメディア
Googleスheetsからの仕事の公開の期限切れチェックと再通知のためにHTTP Last-Modifiedを使用
Google Sheets、HTTP チェック、Gmail を使った求人情報掲載期限の自動提醒
If
Set
Code
+
If
Set
Code
19 ノードWeblineIndia
人事
