{ "edges": [ { "to": "11299f52-3b08-4dfd-914d-8f1b66aab0f9", "from": "25df1e67-074a-45ac-ae71-2ab7e9a9402d", "toPort": "0", "fromPort": "0" }, { "to": "2849660f-3a62-4b38-89f5-0448132a87ab", "from": "2f882148-e21e-4bf1-9b80-a2afc9f0b412", "toPort": "0", "fromPort": "0" }, { "to": "34cb1516-8de5-458d-9e12-09857222a2e3", "from": "2849660f-3a62-4b38-89f5-0448132a87ab", "toPort": "0", "fromPort": "0" }, { "to": "9e86dafa-f911-471d-aceb-4bc771583208", "from": "346181e4-83cf-4298-a52b-2d0a059ab2b6", "toPort": "0", "fromPort": "0" }, { "to": "2d5f7114-7492-4cdb-8ebd-1f87e28a5004", "from": "9e40a771-ab28-46d8-aceb-b85631594d85", "toPort": "0", "fromPort": "0" }, { "to": "25df1e67-074a-45ac-ae71-2ab7e9a9402d", "from": "9e86dafa-f911-471d-aceb-4bc771583208", "toPort": "0", "fromPort": "0" }, { "to": "7c520ebd-ec1f-4a68-8b78-d1244b2167f2", "from": "9e86dafa-f911-471d-aceb-4bc771583208", "toPort": "0", "fromPort": "1" }, { "to": "7c520ebd-ec1f-4a68-8b78-d1244b2167f2", "from": "11299f52-3b08-4dfd-914d-8f1b66aab0f9", "toPort": "0", "fromPort": "0" }, { "to": "8ae1d958-892c-409c-9d93-5f27351f1876", "from": "2d5f7114-7492-4cdb-8ebd-1f87e28a5004", "toPort": "0", "fromPort": "0" }, { "to": "9e40a771-ab28-46d8-aceb-b85631594d85", "from": "34cb1516-8de5-458d-9e12-09857222a2e3", "toPort": "0", "fromPort": "1" }, { "to": "346181e4-83cf-4298-a52b-2d0a059ab2b6", "from": "24c94632-0ff1-4dbb-9016-8cb3a443a08b", "toPort": "0", "fromPort": "0" }, { "to": "9e86dafa-f911-471d-aceb-4bc771583208", "from": "24c94632-0ff1-4dbb-9016-8cb3a443a08b", "toPort": "0", "fromPort": "0" }, { "to": "24c94632-0ff1-4dbb-9016-8cb3a443a08b", "from": "8ae1d958-892c-409c-9d93-5f27351f1876", "toPort": "0", "fromPort": "0" }, { "to": "34cb1516-8de5-458d-9e12-09857222a2e3", "from": "7c520ebd-ec1f-4a68-8b78-d1244b2167f2", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "2d5f7114-7492-4cdb-8ebd-1f87e28a5004", "name": "Normalize Data", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "// Handle both single-item and bulk webhook payloads\nconst d = Array.isArray($json.body)\n ? $json.body[$itemIndex]\n : $json.body ?? $json;\n\n// Hard validation\nif (!d || !d.order_id) {\n throw new Error('Invalid input: order data missing');\n}\n\nreturn {\n order_id: d.order_id,\n customer_email: d.customer_email,\n order_value: Number(d.order_value ?? 0),\n currency: d.currency,\n refund_count_30d: Number(d.refund_count_30d ?? 0),\n refund_count_lifetime: Number(d.refund_count_lifetime ?? 0),\n account_age_days: Number(d.account_age_days ?? 0),\n billing_country: d.billing_country,\n shipping_country: d.shipping_country,\n country_mismatch: d.billing_country !== d.shipping_country,\n risk_processed: d.risk_processed,\n rowNumber: Number(d.rowNumber),\n source: d.source,\n triggeredAt: d.triggeredAt\n};\n" }, "position": [ 2544, 3184 ] }, { "id": "24c94632-0ff1-4dbb-9016-8cb3a443a08b", "name": "Parse AI Output", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "let aiRaw;\nlet ai;\n\n// 1️⃣ Extract AI response\nconst aiText = $json.output?.[0]?.content?.[0]?.text;\nif (!aiText) {\n throw new Error('AI response missing');\n}\n\naiRaw = aiText\n .replace(/```json/gi, '')\n .replace(/```/g, '')\n .trim();\n\nai = JSON.parse(aiRaw);\n\n// 2️⃣ Normalize AI fields\nconst riskLevel = (\n ai.risk_level ||\n ai.risk_class ||\n ai.risk_classification ||\n ''\n).toUpperCase();\n\nconst drivers =\n ai.key_risk_drivers ||\n ai.drivers ||\n [];\n\n// 3️⃣ Get ORIGINAL item using paired index\nconst original = $items(\"Normalize Data\")[0].json;\n\n// 4️⃣ Return merged object\nreturn {\n // 🔹 ORIGINAL DATA\n order_id: original.order_id,\n customer_email: original.customer_email,\n rowNumber: original.rowNumber,\n order_value: `${original.order_value} ${original.currency}`,\n\n // 🔹 AI OUTPUT\n risk_score: Number(ai.risk_score ?? 0),\n risk_level: riskLevel,\n risk_drivers: Array.isArray(drivers) ? drivers.join(', ') : '',\n recommendation_action:\n ai.recommended_action ||\n ai.recommended_preventive_action ||\n '',\n\n // 🔹 META\n ai_model_used: 'openai'\n};\n" }, "position": [ 3296, 3184 ] }, { "id": "9e86dafa-f911-471d-aceb-4bc771583208", "name": "IF High Risk", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 1, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "64952035-93fa-459a-9478-08b851767e4d", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{$json.risk_level}}", "rightValue": "HIGH" } ] } }, "position": [ 4032, 3168 ] }, { "id": "11299f52-3b08-4dfd-914d-8f1b66aab0f9", "name": "Email Finance", "type": "integration", "params": { "message": "=

High Refund / Chargeback Risk Detected

The following transaction has been flagged as HIGH RISK by the Smart Refund Risk Detector.

Order ID: {{ $('Log Result').item.json.order_id }}
Customer Email: {{ $('Log Result').item.json.customer_email }}
Order Value: {{ $('Normalize Data').item.json.order_value }}{{ $('Normalize Data').item.json.currency }}
Risk Score: {{ $('IF High Risk').item.json.risk_score }} / 100
Risk Level: {{ $('IF High Risk').item.json.risk_level }}

Key Risk Drivers:
{{ $('IF High Risk').item.json.risk_drivers }}

Recommended Action:
{{ $('IF High Risk').item.json.recommendation_action }}

Generated automatically by Smart Refund Risk Detector (n8n)
Evaluated at {{new Date().toISOString()}}

", "service": "gmail", "subject": "=🚨 High Refund / Chargeback Risk – Order {{ $('Parse AI Output').item.json.order_id }}", "operation": "read", "additionalFields": { "ccList": [ "user@example.com" ], "toList": [ "user@example.com" ] } }, "position": [ 4464, 3072 ] }, { "id": "346181e4-83cf-4298-a52b-2d0a059ab2b6", "name": "Log Result", "type": "integration", "params": { "columns": { "value": { "order_id": "={{ $json.order_id }}", "logged_at": "={{ (() => { const d = new Date(Date.now() + (5*60+30)*60000); const p = n => String(n).padStart(2,'0'); return `${p(d.getDate())}-${p(d.getMonth()+1)}-${String(d.getFullYear()).slice(-2)} ${p(d.getHours())}:${p(d.getMinutes())}:${p(d.getSeconds())} IST`; })() }}\n", "risk_level": "={{ $json.risk_level }}", "risk_score": "={{ $json.risk_score }}", "risk_drivers": "={{ $json.risk_drivers }}", "customer_email": "={{ $json.customer_email }}", "recommendation_action": "={{ $json.recommendation_action }}" }, "schema": [ { "id": "log_id", "type": "string", "display": true, "removed": true, "required": false, "displayName": "log_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "logged_at", "type": "string", "display": true, "required": false, "displayName": "logged_at", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "order_id", "type": "string", "display": true, "required": false, "displayName": "order_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "customer_email", "type": "string", "display": true, "required": false, "displayName": "customer_email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "risk_score", "type": "string", "display": true, "required": false, "displayName": "risk_score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "risk_level", "type": "string", "display": true, "required": false, "displayName": "risk_level", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "risk_drivers", "type": "string", "display": true, "required": false, "displayName": "risk_drivers", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "recommendation_action", "type": "string", "display": true, "required": false, "displayName": "recommendation_action", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "ai_model_used", "type": "string", "display": true, "removed": true, "required": false, "displayName": "ai_model_used", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": 1528462871, "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 3664, 3056 ] }, { "id": "7c520ebd-ec1f-4a68-8b78-d1244b2167f2", "name": "Update row in sheet", "type": "integration", "params": { "columns": { "value": { "row_number": "={{ $('Normalize Data').item.json.rowNumber }}", "risk_processed": "TRUE" }, "schema": [ { "id": "order_id", "type": "string", "display": true, "removed": true, "required": false, "displayName": "order_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "customer_email", "type": "string", "display": true, "removed": true, "required": false, "displayName": "customer_email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "order_value", "type": "string", "display": true, "removed": true, "required": false, "displayName": "order_value", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "currency", "type": "string", "display": true, "removed": true, "required": false, "displayName": "currency", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "refund_count_30d", "type": "string", "display": true, "removed": true, "required": false, "displayName": "refund_count_30d", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "refund_count_lifetime", "type": "string", "display": true, "removed": true, "required": false, "displayName": "refund_count_lifetime", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "account_age_days", "type": "string", "display": true, "removed": true, "required": false, "displayName": "account_age_days", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "billing_country", "type": "string", "display": true, "removed": true, "required": false, "displayName": "billing_country", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "shipping_country", "type": "string", "display": true, "removed": true, "required": false, "displayName": "shipping_country", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "created_at", "type": "string", "display": true, "removed": true, "required": false, "displayName": "created_at", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "risk_processed", "type": "string", "display": true, "required": false, "displayName": "risk_processed", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "row_number", "type": "number", "display": true, "removed": false, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "row_number" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "__rl": true, "mode": "list", "value": "your-sheet-value", "cachedResultUrl": "", "cachedResultName": "" }, "documentId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "position": [ 4864, 3184 ] }, { "id": "9e40a771-ab28-46d8-aceb-b85631594d85", "name": "DEDUPE CHECK", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "fc6221f6-d207-477f-9883-747f46bdad7c", "operator": { "type": "string", "operation": "equals" }, "leftValue": "={{ String($json.risk_processed).toUpperCase() }}", "rightValue": "FALSE" } ] } }, "position": [ 2240, 3184 ] }, { "id": "34cb1516-8de5-458d-9e12-09857222a2e3", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 1936, 3168 ] }, { "id": "2849660f-3a62-4b38-89f5-0448132a87ab", "name": "Split Out", "type": "passthrough", "params": { "mode": "splitOut", "field": "=body", "options": {}, "fieldToSplitOut": "=body" }, "position": [ 1616, 3168 ] }, { "id": "8ae1d958-892c-409c-9d93-5f27351f1876", "name": "Message a model2", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "chatgpt-4o-latest", "cachedResultName": "CHATGPT-4O-LATEST" }, "options": {}, "provider": "openai", "responses": { "values": [ { "role": "system", "content": "=You are a senior Risk Analytics Specialist supporting an enterprise e-commerce platform.\n\nYour responsibility is to assess refund and chargeback risk using transaction-level data, customer behavior patterns, and conservative professional judgment.\n\nYou must:\n- Apply risk assessment practices consistent with large-scale e-commerce and payment operations\n- Avoid over-flagging legitimate customer activity\n- Ensure decisions are explainable, proportional, and consistent\n- Follow the requested JSON schema strictly\n- Always return valid, machine-readable JSON suitable for automated downstream processing\n" }, { "content": "=Assess the refund or chargeback risk for the transaction described below.\n\nEvaluation standards:\n- Assign a numeric risk score as an INTEGER between 0 and 100 (digits only, no words, no decimals)\n- Classify risk strictly as one of: LOW, MEDIUM, HIGH (uppercase only)\n- Use conservative scoring aligned with enterprise fraud, refunds, and chargeback policies\n- A single refund event alone must NOT result in a HIGH risk classification\n- Country mismatch alone must NOT result in a HIGH risk classification\n- Assign HIGH risk ONLY when multiple strong indicators are present\n- Recommend ONE clear, concise, actionable preventive step suitable for operations or finance teams\n\nTransaction details:\nOrder ID: {{$json.order_id}}\nOrder Value: {{$json.order_value}} {{$json.currency}}\nRefunds in last 30 days: {{$json.refund_count_30d}}\nRefunds lifetime: {{$json.refund_count_lifetime}}\nAccount age (days): {{$json.account_age_days}}\nBilling country: {{$json.billing_country}}\nShipping country: {{$json.shipping_country}}\nCountry mismatch: {{$json.billing_country !== $json.shipping_country}}\n\nSTRICT OUTPUT RULES (MANDATORY):\n- Output ONLY a valid JSON object\n- Do NOT include markdown, code fences, comments, or explanatory text\n- Do NOT spell numbers using words (e.g., \"forty five\" is INVALID)\n- All numeric fields MUST be numbers (e.g., 45)\n- Use double quotes for all keys and string values\n- Use the exact structure below with NO extra fields\n\nRequired JSON structure:\n{\n \"risk_score\": 45,\n \"risk_level\": \"LOW\",\n \"key_risk_drivers\": [\"example driver\"],\n \"recommended_preventive_action\": \"example action\"\n}\n" } ] }, "builtInTools": {} }, "position": [ 2832, 3184 ] }, { "id": "25df1e67-074a-45ac-ae71-2ab7e9a9402d", "name": "Discord1", "type": "integration", "params": { "content": "=🚨 HIGH REFUND / CHARGEBACK RISK DETECTED\n\n🧾 Order ID: {{ $json.order_id }}\n📧 Customer: {{ $json.customer_email }}\n💰 Order Value: {{ $json.order_value }}\n📊 Risk Score: {{$json.risk_score}} / 100\n⚠️ Risk Level: {{$json.risk_level}}\n\n🧠 Key Risk Drivers:\n{{$json.risk_drivers}}\n\n✅ Recommended Action:\n{{ $json.recommendation_action }}\n\n⏱️ Evaluated at: {{new Date().toISOString()}}\n", "options": {}, "service": "discord", "operation": "read", "authentication": "webhook" }, "position": [ 4256, 3072 ] }, { "id": "2f882148-e21e-4bf1-9b80-a2afc9f0b412", "name": "Webhook1", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "refund-risk", "options": {}, "httpMethod": "POST" }, "position": [ 1296, 3168 ] } ] }

Detect and score refund risk with Webhook, OpenAI and Google Sheets