| {
|
| "nodes": [
|
| {
|
| "parameters": {
|
| "pollTimes": {
|
| "item": [
|
| {
|
| "mode": "everyMinute"
|
| }
|
| ]
|
| },
|
| "documentId": {
|
| "__rl": true,
|
| "value": "1udZ65_L2Hf79RxvUn7NY9SMsninRzr6UHE3RW5nRQ2U",
|
| "mode": "list"
|
| },
|
| "sheetName": {
|
| "__rl": true,
|
| "value": 1392151344,
|
| "mode": "list"
|
| },
|
| "options": {}
|
| },
|
| "id": "sheet-trigger-1",
|
| "name": "SalonTrigger",
|
| "type": "n8n-nodes-base.googleSheetsTrigger",
|
| "typeVersion": 1,
|
| "position": [
|
| 0,
|
| -96
|
| ],
|
| "credentials": {
|
| "googleSheetsTriggerOAuth2Api": {
|
| "id": "qruBDoP6sPGfIyzX",
|
| "name": "Google Sheets Trigger account"
|
| }
|
| }
|
| },
|
| {
|
| "parameters": {
|
| "pollTimes": {
|
| "item": [
|
| {
|
| "mode": "everyMinute"
|
| }
|
| ]
|
| },
|
| "documentId": {
|
| "__rl": true,
|
| "value": "1dljqIuz_i7WxQ39ykymY6xsujC0dzwJLvvJGcmMAJzA",
|
| "mode": "list"
|
| },
|
| "sheetName": {
|
| "__rl": true,
|
| "value": 1392151344,
|
| "mode": "list"
|
| },
|
| "options": {}
|
| },
|
| "id": "sheet-trigger-2",
|
| "name": "ClinicTrigger",
|
| "type": "n8n-nodes-base.googleSheetsTrigger",
|
| "typeVersion": 1,
|
| "position": [
|
| 0,
|
| 112
|
| ],
|
| "credentials": {
|
| "googleSheetsTriggerOAuth2Api": {
|
| "id": "qruBDoP6sPGfIyzX",
|
| "name": "Google Sheets Trigger account"
|
| }
|
| }
|
| },
|
| {
|
| "parameters": {
|
| "jsCode": "const items = $input.all();const validItems = [];for (let item of items) { let phone = item.json['Phone'] || ''; let salon = item.json['SalonName'] || ''; let clinic = item.json['ClinicName'] || ''; let intention = item.json['IntentionLevel'] || ''; if (!phone.trim() && !salon.trim() && !clinic.trim()) continue; if (intention !== 'RequestDocs' && intention !== 'SendDocs' && intention !== 'G') continue; let clean = phone.replace(/[^0-9]/g, ''); let company = salon || clinic || 'Unknown'; validItems.push({ json: { ...item.json, formatted_phone: clean, unified_company: company, unified_lastName: (item.json['LastName'] || '').trim() || 'Manager', unified_firstName: (item.json['FirstName'] || '').trim() || '', unified_email: (item.json['Email'] || '').trim() || '', unified_zip: (item.json['Zip'] || '').trim() || '', unified_addr: (item.json['Address'] || '').trim() || '', unified_todo: 'Intention: ' + intention, unified_state: item.json['State'] || '', unified_city: item.json['City'] || '' } });}return validItems;"
|
| },
|
| "id": "data-format",
|
| "name": "DataFormat",
|
| "type": "n8n-nodes-base.code",
|
| "typeVersion": 2,
|
| "position": [
|
| 256,
|
| 0
|
| ]
|
| },
|
| {
|
| "parameters": {
|
| "operation": "getAll",
|
| "returnAll": true,
|
| "options": {
|
| "conditionsUi": {
|
| "conditionValues": [
|
| {
|
| "field": "campaign__c",
|
| "value": "TargetCampaign"
|
| }
|
| ]
|
| }
|
| }
|
| },
|
| "id": "sf-fetch-campaign",
|
| "name": "SFFetchCampaign",
|
| "type": "n8n-nodes-base.salesforce",
|
| "typeVersion": 1,
|
| "position": [
|
| 480,
|
| 0
|
| ],
|
| "credentials": {
|
| "salesforceOAuth2Api": {
|
| "id": "VWs1rwBJyiCM1cYc",
|
| "name": "Salesforce account"
|
| }
|
| }
|
| },
|
| {
|
| "parameters": {
|
| "jsCode": "const sheetItem = $(\"DataFormat\").item.json;const sfLeads = $input.all();let matchFound = false;let targetLeadId = null;for (let lead of sfLeads) { const sfEmail = lead.json.Email || ''; const sfPhone = lead.json.Phone || ''; if ((sheetItem.unified_email && sheetItem.unified_email === sfEmail) || (sheetItem.formatted_phone && sheetItem.formatted_phone === sfPhone)) { matchFound = true; targetLeadId = lead.json.Id; break; }}return [{ json: { ...sheetItem, matchFound: matchFound, targetLeadId: targetLeadId } }];"
|
| },
|
| "id": "safe-join-check",
|
| "name": "SafeJoinCheck",
|
| "type": "n8n-nodes-base.code",
|
| "typeVersion": 2,
|
| "position": [
|
| 704,
|
| 0
|
| ]
|
| },
|
| {
|
| "parameters": {
|
| "conditions": {
|
| "options": {
|
| "caseSensitive": true,
|
| "leftValue": "",
|
| "typeValidation": "strict",
|
| "version": 2
|
| },
|
| "conditions": [
|
| {
|
| "id": "is-match",
|
| "leftValue": "={{ $json.matchFound }}",
|
| "rightValue": "true",
|
| "operator": {
|
| "type": "boolean",
|
| "operation": "true"
|
| }
|
| }
|
| ],
|
| "combinator": "and"
|
| },
|
| "options": {}
|
| },
|
| "id": "check-match",
|
| "name": "IsMatch",
|
| "type": "n8n-nodes-base.if",
|
| "typeVersion": 2.2,
|
| "position": [
|
| 928,
|
| 0
|
| ]
|
| },
|
| {
|
| "parameters": {
|
| "operation": "update",
|
| "leadId": "={{ $json.targetLeadId }}",
|
| "updateFields": {
|
| "email": "={{ $json.unified_email }}",
|
| "postalCode": "={{ $json.unified_zip }}",
|
| "street": "={{ $json.unified_addr }}"
|
| }
|
| },
|
| "id": "sf-update-safe",
|
| "name": "SFUpdate",
|
| "type": "n8n-nodes-base.salesforce",
|
| "typeVersion": 1,
|
| "position": [
|
| 1152,
|
| -96
|
| ],
|
| "credentials": {
|
| "salesforceOAuth2Api": {
|
| "id": "VWs1rwBJyiCM1cYc",
|
| "name": "Salesforce account"
|
| }
|
| }
|
| },
|
| {
|
| "parameters": {
|
| "company": "={{ $json.unified_company }}",
|
| "lastname": "={{ $json.unified_lastName }}",
|
| "additionalFields": {
|
| "city": "={{ $json.unified_city }}",
|
| "email": "={{ $json.unified_email }}",
|
| "phone": "={{ $json.formatted_phone }}",
|
| "postalCode": "={{ $json.unified_zip }}",
|
| "state": "={{ $json.unified_state }}",
|
| "street": "={{ $json.unified_addr }}"
|
| }
|
| },
|
| "id": "sf-create-safe",
|
| "name": "SFCreate",
|
| "type": "n8n-nodes-base.salesforce",
|
| "typeVersion": 1,
|
| "position": [
|
| 1152,
|
| 112
|
| ],
|
| "credentials": {
|
| "salesforceOAuth2Api": {
|
| "id": "VWs1rwBJyiCM1cYc",
|
| "name": "Salesforce account"
|
| }
|
| }
|
| },
|
| {
|
| "parameters": {
|
| "operation": "addToCampaign",
|
| "leadId": "={{ $json.targetLeadId || $json.id }}",
|
| "campaignId": "701RB00001FY6jOYAT",
|
| "options": {}
|
| },
|
| "id": "sf-campaign-final",
|
| "name": "SFCampaignFinal",
|
| "type": "n8n-nodes-base.salesforce",
|
| "typeVersion": 1,
|
| "position": [
|
| 1504,
|
| 0
|
| ],
|
| "credentials": {
|
| "salesforceOAuth2Api": {
|
| "id": "VWs1rwBJyiCM1cYc",
|
| "name": "Salesforce account"
|
| }
|
| },
|
| "continueOnFail": true
|
| },
|
| {
|
| "parameters": {},
|
| "type": "n8n-nodes-base.merge",
|
| "typeVersion": 3.2,
|
| "position": [
|
| 1344,
|
| 0
|
| ],
|
| "id": "merge-results",
|
| "name": "MergeResults"
|
| }
|
| ],
|
| "connections": {
|
| "SalonTrigger": {
|
| "main": [
|
| [
|
| {
|
| "node": "DataFormat",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "ClinicTrigger": {
|
| "main": [
|
| [
|
| {
|
| "node": "DataFormat",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "DataFormat": {
|
| "main": [
|
| [
|
| {
|
| "node": "SFFetchCampaign",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "SFFetchCampaign": {
|
| "main": [
|
| [
|
| {
|
| "node": "SafeJoinCheck",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "SafeJoinCheck": {
|
| "main": [
|
| [
|
| {
|
| "node": "IsMatch",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "IsMatch": {
|
| "main": [
|
| [
|
| {
|
| "node": "SFUpdate",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ],
|
| [
|
| {
|
| "node": "SFCreate",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "SFUpdate": {
|
| "main": [
|
| [
|
| {
|
| "node": "MergeResults",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| },
|
| "SFCreate": {
|
| "main": [
|
| [
|
| {
|
| "node": "MergeResults",
|
| "type": "main",
|
| "index": 1
|
| }
|
| ]
|
| ]
|
| },
|
| "MergeResults": {
|
| "main": [
|
| [
|
| {
|
| "node": "SFCampaignFinal",
|
| "type": "main",
|
| "index": 0
|
| }
|
| ]
|
| ]
|
| }
|
| }
|
| }
|