n8n for InsurTech SaaS Vendors: 5 Automations for NAIC, State DOI, TCPA, NY DFS, and HIPAA Compliance
InsurTech SaaS vendors sit at the intersection of insurance regulation, data privacy law, and consumer protection enforcement. The TCPA creates $500–$1,500 in statutory damages per auto-dialed call made without prior exp
InsurTech SaaS vendors sit at the intersection of insurance regulation, data privacy law, and consumer protection enforcement. The TCPA creates $500–$1,500 in statutory damages per auto-dialed call made without prior express written consent — no actual harm required, no cure period, class actions routine. NY DFS 23 NYCRR 500.17(a) runs a 72-hour notification clock from discovery of a cybersecurity event to the Superintendent's desk. Health insurers face dual HIPAA covered entity obligations alongside NAIC Model Law compliance. Every third-party SaaS in your automation stack is a §500.11 vendor requiring a documented security review.
This article delivers 5 production-ready n8n workflow JSON templates for InsurTech SaaS vendors. Import any workflow at Settings → n8n API → Import workflow or via the n8n CLI.
InsurTech Customer Tiers
| Tier | Description |
|---|---|
P&C_INSURANCE_PLATFORM |
Commercial P&C carriers, MGA platforms, excess & surplus lines SaaS |
HEALTH_INSURANCE_SAAS |
Health plan admin, claims processing, enrollment platforms, TPA SaaS |
LIFE_INSURANCE_TECH_VENDOR |
Life/annuity recordkeeping, illustration SaaS, in-force policy platforms |
INSURANCE_ANALYTICS_SAAS |
Underwriting analytics, catastrophe modeling, fraud detection SaaS |
MGU_DELEGATED_AUTHORITY_PLATFORM |
Managing general underwriter SaaS, program admin platforms |
CLAIMS_MANAGEMENT_SAAS |
Claims intake, triage, payment automation, subrogation SaaS |
INSURTECH_STARTUP |
Embedded insurance platforms, digital carrier infrastructure, API-first InsurTech |
Compliance Flags
| Flag | Regulation | Fastest Clock |
|---|---|---|
TCPA_OUTBOUND_CALLER |
47 USC §227 TCPA | Immediate — $500–$1,500/call class action exposure |
NY_DFS_23_NYCRR_500_SUBJECT |
NY DFS 23 NYCRR §500 | 72 hours — cyber incident notification §500.17(a) |
HIPAA_HEALTH_PLAN_COVERED |
HIPAA 45 CFR §164 | 60 days — PHI breach notification §164.408 |
GLBA_PRIVACY_APPLICABLE |
GLBA 16 CFR §314 | 30 days — breach notification FTC Safeguards §314.6 |
FCRA_CREDIT_REPORTING_USER |
15 USC §1681m FCRA | 5 biz days — adverse action notice §1681m |
STATE_DOI_LICENSED |
State Insurance Codes | 10–30 biz days — market conduct exam response |
NAIC_MODEL_AUDIT_ANNUAL |
NAIC Model Audit Rule | Annual financial statement audit |
Workflow 1: InsurTech Customer Onboarding Drip
Segments new customers by insurance tier, injects active compliance flags, sends a 3-touch drip sequence (Day 0 welcome + TCPA/NAIC action items → Day 3 consent vault guide → Day 7 incident pipeline activation). Notifies the CSM on Slack with the customer's NY DFS §500.11 vendor registration requirement.
{
"name": "InsurTech Customer Onboarding Drip",
"nodes": [
{
"id": "n1",
"name": "Trigger: New InsurTech Customer",
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 4,
"position": [
0,
0
],
"parameters": {
"documentId": "INSERT_SHEET_ID",
"sheetName": "InsurTech Customers",
"event": "rowAdded"
}
},
{
"id": "n2",
"name": "Code: Tier & Flag Inject",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
220,
0
],
"parameters": {
"jsCode": "const row = $input.first().json;\nconst tier = row.tier || 'INSURTECH_STARTUP';\nconst flags = [];\nif (row.hipaa_health_plan === 'true') flags.push('HIPAA_HEALTH_PLAN_COVERED');\nif (row.ny_dfs_subject === 'true') flags.push('NY_DFS_23_NYCRR_500_SUBJECT');\nif (row.glba_applicable === 'true') flags.push('GLBA_PRIVACY_APPLICABLE');\nif (row.tcpa_caller === 'true') flags.push('TCPA_OUTBOUND_CALLER');\nif (row.fcra_user === 'true') flags.push('FCRA_CREDIT_REPORTING_USER');\nif (row.state_doi_licensed === 'true') flags.push('STATE_DOI_LICENSED');\nif (row.naic_audit_required === 'true') flags.push('NAIC_MODEL_AUDIT_ANNUAL');\nconst clockMap = {\n TCPA_OUTBOUND_CALLER: 'Immediate $500-$1,500/call (47 USC 227)',\n NY_DFS_23_NYCRR_500_SUBJECT: '72h cyber incident notification (500.17(a))',\n HIPAA_HEALTH_PLAN_COVERED: '60-day PHI breach (45 CFR 164.408)',\n GLBA_PRIVACY_APPLICABLE: '30-day breach notification (16 CFR 314.6)',\n FCRA_CREDIT_REPORTING_USER: '5 biz day adverse action (15 USC 1681m)',\n STATE_DOI_LICENSED: '10-30 biz day market conduct exam response',\n NAIC_MODEL_AUDIT_ANNUAL: 'Annual financial statement audit (NAIC MAR)'\n};\nreturn [{ json: { ...row, tier, flags: flags.join(','), compliance_context: flags.map(f => clockMap[f]).filter(Boolean).join(' | ') } }];"
}
},
{
"id": "n3",
"name": "Gmail: Day 0 Welcome",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
440,
0
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "={{$json.email}}",
"subject": "Welcome to [YourPlatform] \u2014 Your Compliance Setup Checklist",
"emailType": "html",
"message": "<p>Hi {{$json.first_name}},</p><p>Welcome. Your tier: <strong>{{$json.tier}}</strong>.</p><p>Active compliance clocks: {{$json.compliance_context}}</p><p>First 72 hours:<br>- NY DFS 500.17(a): confirm cyber incident escalation contact<br>- TCPA: upload prior express written consent records to your Postgres vault<br>- HIPAA (if applicable): confirm PHI endpoints are HIPAA-compliant</p><p>Onboarding guide: <a href='https://docs.yourplatform.com/start'>Get started</a></p>"
}
},
{
"id": "n4",
"name": "Slack: CSM DM",
"type": "n8n-nodes-base.slack",
"typeVersion": 2,
"position": [
440,
220
],
"parameters": {
"resource": "message",
"operation": "post",
"channel": "#cs-insurtech",
"text": "New InsurTech customer: {{$json.company_name}} ({{$json.tier}}). Flags: {{$json.flags}}. CSM action: confirm NAIC audit schedule and NY DFS vendor registration at 500.11."
}
},
{
"id": "n5",
"name": "Wait: 3 Days",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
660,
0
],
"parameters": {
"amount": 3,
"unit": "days"
}
},
{
"id": "n6",
"name": "Gmail: Day 3 TCPA & NAIC",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
880,
0
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "={{$json.email}}",
"subject": "Day 3: Your TCPA Consent Vault & NAIC Compliance Checklist",
"emailType": "html",
"message": "<p>Hi {{$json.first_name}},</p><p>Two items that cannot wait:</p><ol><li><strong>TCPA (47 USC 227)</strong>: Every auto-dialed call without prior express written consent carries $500-$1,500 in statutory damages. Class action exposure per call, no harm required. Confirm consent records are in your self-hosted Postgres vault \u2014 not a cloud table owned by a vendor.</li><li><strong>NAIC MDR</strong>: If you process annual financial statements for admitted carriers, your audit calendar should already be set. Your deadline workflow activates today.</li></ol>"
}
},
{
"id": "n7",
"name": "Wait: 4 Days",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
1100,
0
],
"parameters": {
"amount": 4,
"unit": "days"
}
},
{
"id": "n8",
"name": "Gmail: Day 7 Incident Pipeline",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
1320,
0
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "={{$json.email}}",
"subject": "Day 7: Activate Your NY DFS and HIPAA Incident Pipelines",
"emailType": "html",
"message": "<p>Hi {{$json.first_name}},</p><p>Last onboarding step: activate your incident response pipelines.</p><ul><li><strong>NY DFS 500.17(a)</strong>: 72-hour clock starts at discovery. Your pipeline should fire the moment your SIEM fires \u2014 not when compliance reviews the ticket.</li><li><strong>HIPAA OCR</strong>: 60-day clock for breaches affecting 500+ individuals. Automate the breach log entry at detection.</li><li><strong>GLBA FTC Safeguards 314.6</strong>: 30-day breach notification to FTC and affected customers.</li></ul><p>All 5 workflow templates: <a href='https://stripeai.gumroad.com'>stripeai.gumroad.com</a></p>"
}
},
{
"id": "n9",
"name": "Sheets: Mark Complete",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1540,
0
],
"parameters": {
"resource": "spreadsheet",
"operation": "update",
"documentId": "INSERT_SHEET_ID",
"sheetName": "InsurTech Customers",
"columns": {
"mappingMode": "defineBelow",
"value": {
"onboarding_status": "complete",
"onboarding_completed_at": "={{new Date().toISOString()}}"
}
}
}
}
],
"connections": {
"Trigger: New InsurTech Customer": {
"main": [
[
{
"node": "Code: Tier & Flag Inject",
"type": "main",
"index": 0
}
]
]
},
"Code: Tier & Flag Inject": {
"main": [
[
{
"node": "Gmail: Day 0 Welcome",
"type": "main",
"index": 0
},
{
"node": "Slack: CSM DM",
"type": "main",
"index": 0
}
]
]
},
"Gmail: Day 0 Welcome": {
"main": [
[
{
"node": "Wait: 3 Days",
"type": "main",
"index": 0
}
]
]
},
"Wait: 3 Days": {
"main": [
[
{
"node": "Gmail: Day 3 TCPA & NAIC",
"type": "main",
"index": 0
}
]
]
},
"Gmail: Day 3 TCPA & NAIC": {
"main": [
[
{
"node": "Wait: 4 Days",
"type": "main",
"index": 0
}
]
]
},
"Wait: 4 Days": {
"main": [
[
{
"node": "Gmail: Day 7 Incident Pipeline",
"type": "main",
"index": 0
}
]
]
},
"Gmail: Day 7 Incident Pipeline": {
"main": [
[
{
"node": "Sheets: Mark Complete",
"type": "main",
"index": 0
}
]
]
}
}
}
Why self-hosted n8n: TCPA consent records and HIPAA PHI must stay within your network boundary. Routing them through a cloud automation vendor's infrastructure adds a subprocessor to your GLBA Safeguards Rule inventory and a TPSP to your NY DFS §500.11 register.
Workflow 2: InsurTech Regulatory API Health Monitor
Polls 5 regulatory endpoints every 3 minutes: State DOI portal, NAIC OFR filing API, NY DFS portal, HIPAA audit log API, GLBA Safeguards API. Uses $getWorkflowStaticData to deduplicate alerts — only fires Slack when an endpoint transitions from UP to DOWN/DEGRADED. Logs every event to a Sheets SLA ledger for exam-ready audit trails.
{
"name": "InsurTech Regulatory API Health Monitor",
"nodes": [
{
"id": "n1",
"name": "Schedule: Every 3 Minutes",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "*/3 * * * *"
}
]
}
}
},
{
"id": "n2",
"name": "Code: Load Endpoints",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
220,
0
],
"parameters": {
"jsCode": "const prev = $getWorkflowStaticData('global').endpointStatus || {};\nconst endpoints = [\n { name: 'state_doi_portal_api', url: 'INSERT_DOI_URL', regulation: 'State DOI Market Conduct 36B' },\n { name: 'naic_ofr_filing_api', url: 'INSERT_NAIC_URL', regulation: 'NAIC Model Audit Rule Annual' },\n { name: 'ny_dfs_portal_api', url: 'INSERT_NYDFS_URL', regulation: 'NY DFS 23 NYCRR 500' },\n { name: 'hipaa_audit_log_api', url: 'INSERT_HIPAA_URL', regulation: 'HIPAA 164.312(b) Audit Controls' },\n { name: 'glba_safeguards_api', url: 'INSERT_GLBA_URL', regulation: 'GLBA Safeguards Rule 16 CFR 314' }\n];\nreturn endpoints.map(e => ({ json: { ...e, prev_status: prev[e.name] || 'UP' } }));"
}
},
{
"id": "n3",
"name": "HTTP: Health Check",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
440,
0
],
"parameters": {
"url": "={{$json.url}}",
"method": "GET",
"timeout": 8000,
"options": {
"response": {
"response": {
"fullResponse": true
}
}
}
}
},
{
"id": "n4",
"name": "Code: Classify & Dedup",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
660,
0
],
"parameters": {
"jsCode": "const items = $input.all();\nconst staticData = $getWorkflowStaticData('global');\nstaticData.endpointStatus = staticData.endpointStatus || {};\nconst alerts = [];\nfor (const item of items) {\n const { name, regulation, prev_status } = item.json;\n const sc = item.json.statusCode || 0;\n const rt = item.json.responseTime || 9999;\n let status = 'UP';\n if (sc === 0 || sc >= 500) status = 'DOWN';\n else if (sc >= 400 || rt > 3000) status = 'DEGRADED';\n if (status !== 'UP' && prev_status === 'UP') {\n alerts.push({ json: { name, regulation, status, statusCode: sc, responseTime: rt } });\n }\n staticData.endpointStatus[name] = status;\n}\nreturn alerts.length > 0 ? alerts : [{ json: { allHealthy: true } }];"
}
},
{
"id": "n5",
"name": "IF: Degraded?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
880,
0
],
"parameters": {
"conditions": {
"options": {},
"conditions": [
{
"leftValue": "={{$json.allHealthy}}",
"operator": {
"type": "boolean",
"operation": "notTrue"
}
}
]
}
}
},
{
"id": "n6",
"name": "Slack: #compliance-ops",
"type": "n8n-nodes-base.slack",
"typeVersion": 2,
"position": [
1100,
0
],
"parameters": {
"resource": "message",
"operation": "post",
"channel": "#compliance-ops",
"text": "INSURTECH API ALERT: {{$json.name}} is {{$json.status}} (HTTP {{$json.statusCode}}, {{$json.responseTime}}ms). Regulation: {{$json.regulation}}. Investigate \u2014 regulatory filing windows may be at risk."
}
},
{
"id": "n7",
"name": "Sheets: SLA Log",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1320,
0
],
"parameters": {
"resource": "spreadsheet",
"operation": "append",
"documentId": "INSERT_SHEET_ID",
"sheetName": "API SLA Log",
"columns": {
"mappingMode": "defineBelow",
"value": {
"ts": "={{new Date().toISOString()}}",
"endpoint": "={{$json.name}}",
"status": "={{$json.status}}",
"code": "={{$json.statusCode}}",
"ms": "={{$json.responseTime}}",
"regulation": "={{$json.regulation}}"
}
}
}
}
],
"connections": {
"Schedule: Every 3 Minutes": {
"main": [
[
{
"node": "Code: Load Endpoints",
"type": "main",
"index": 0
}
]
]
},
"Code: Load Endpoints": {
"main": [
[
{
"node": "HTTP: Health Check",
"type": "main",
"index": 0
}
]
]
},
"HTTP: Health Check": {
"main": [
[
{
"node": "Code: Classify & Dedup",
"type": "main",
"index": 0
}
]
]
},
"Code: Classify & Dedup": {
"main": [
[
{
"node": "IF: Degraded?",
"type": "main",
"index": 0
}
]
]
},
"IF: Degraded?": {
"main": [
[
{
"node": "Slack: #compliance-ops",
"type": "main",
"index": 0
}
],
[]
]
},
"Slack: #compliance-ops": {
"main": [
[
{
"node": "Sheets: SLA Log",
"type": "main",
"index": 0
}
]
]
}
}
}
Why self-hosted n8n: State DOI portals and NAIC filing systems return sensitive certificate and financial data. NY DFS §500.11 requires documented controls over third-party service providers with access to nonpublic information — a cloud automation platform that processes your DOI portal credentials is itself a §500.11 TPSP.
Workflow 3: NAIC / DOI / TCPA / NY DFS Compliance Deadline Tracker
Runs weekdays at 8 AM against a Sheets deadline registry. Classifies each item into OVERDUE / CRITICAL (≤7 days) / URGENT (≤21 days) / WARNING (≤60 days). Fires Slack to #compliance-critical for CRITICAL/OVERDUE; routes all others to the owner's Gmail.
12 deadline types covered:
| Type | Regulation | Window |
|---|---|---|
NAIC_MODEL_AUDIT_ANNUAL |
NAIC Model Audit Rule | Annual |
STATE_DOI_ANNUAL_STATEMENT |
State Insurance Code | Annual (March 1 / April 1) |
NY_DFS_CYBERSECURITY_ANNUAL_CERT |
23 NYCRR §500.17(b) | February 15 |
GLBA_SAFEGUARDS_ANNUAL_REVIEW |
16 CFR §314.4 | Annual |
HIPAA_ANNUAL_RISK_ASSESSMENT |
45 CFR §164.308(a)(1) | Annual |
TCPA_CONSENT_AUDIT_ANNUAL |
47 USC §227 + FCC rules | Annual internal |
FCRA_ADVERSE_ACTION_REVIEW |
15 USC §1681m | Annual process review |
NAIC_ORSA_ANNUAL |
NAIC ORSA Guidance Manual | Annual (>$500M DWP) |
STATE_DOI_MARKET_CONDUCT_RESPONSE |
NAIC Market Reg. Handbook | 10–30 biz days |
NY_DFS_PENETRATION_TEST |
23 NYCRR §500.05 | Annual/biennial |
NAIC_DATA_SECURITY_MODEL_LAW |
NAIC Insurance Data Security Model Law | State-by-state |
SOC2_TYPE2_RENEWAL |
AICPA SOC 2 | Annual |
{
"name": "NAIC / DOI / TCPA / NY DFS Compliance Deadline Tracker",
"nodes": [
{
"id": "n1",
"name": "Schedule: Weekdays 8AM",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * 1-5"
}
]
}
}
},
{
"id": "n2",
"name": "Sheets: Load Deadlines",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
220,
0
],
"parameters": {
"resource": "spreadsheet",
"operation": "getAll",
"documentId": "INSERT_SHEET_ID",
"sheetName": "InsurTech Deadlines"
}
},
{
"id": "n3",
"name": "Code: Classify Urgency",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
440,
0
],
"parameters": {
"jsCode": "const today = new Date();\nreturn $input.all().filter(i => i.json.deadline_type && i.json.due_date).map(item => {\n const due = new Date(item.json.due_date);\n const daysLeft = Math.ceil((due - today) / 86400000);\n let urgency = 'NOTICE';\n if (daysLeft < 0) urgency = 'OVERDUE';\n else if (daysLeft <= 7) urgency = 'CRITICAL';\n else if (daysLeft <= 21) urgency = 'URGENT';\n else if (daysLeft <= 60) urgency = 'WARNING';\n return { json: { ...item.json, daysLeft, urgency } };\n}).filter(i => i.json.urgency !== 'NOTICE');"
}
},
{
"id": "n4",
"name": "IF: CRITICAL/OVERDUE?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
660,
0
],
"parameters": {
"conditions": {
"options": {},
"conditions": [
{
"leftValue": "={{$json.urgency}}",
"operator": {
"type": "string",
"operation": "equals"
},
"rightValue": "CRITICAL"
},
{
"leftValue": "={{$json.urgency}}",
"operator": {
"type": "string",
"operation": "equals"
},
"rightValue": "OVERDUE"
}
],
"combinator": "OR"
}
}
},
{
"id": "n5",
"name": "Slack: #compliance-critical",
"type": "n8n-nodes-base.slack",
"typeVersion": 2,
"position": [
880,
0
],
"parameters": {
"resource": "message",
"operation": "post",
"channel": "#compliance-critical",
"text": "INSURTECH DEADLINE {{$json.urgency}}: {{$json.deadline_type}} \u2014 {{$json.daysLeft}} days left. Citation: {{$json.regulation_citation}}. Owner: {{$json.owner_email}}. Due: {{$json.due_date}}."
}
},
{
"id": "n6",
"name": "Gmail: Owner Alert",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
880,
220
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "={{$json.owner_email}}",
"subject": "[{{$json.urgency}}] {{$json.deadline_type}} \u2014 {{$json.daysLeft}} days",
"emailType": "html",
"message": "<p>Compliance deadline reminder: <strong>{{$json.deadline_type}}</strong><br>Status: <strong>{{$json.urgency}}</strong> \u2014 {{$json.daysLeft}} days remaining<br>Citation: {{$json.regulation_citation}}<br>Action: {{$json.action_required}}</p>"
}
}
],
"connections": {
"Schedule: Weekdays 8AM": {
"main": [
[
{
"node": "Sheets: Load Deadlines",
"type": "main",
"index": 0
}
]
]
},
"Sheets: Load Deadlines": {
"main": [
[
{
"node": "Code: Classify Urgency",
"type": "main",
"index": 0
}
]
]
},
"Code: Classify Urgency": {
"main": [
[
{
"node": "IF: CRITICAL/OVERDUE?",
"type": "main",
"index": 0
}
]
]
},
"IF: CRITICAL/OVERDUE?": {
"main": [
[
{
"node": "Slack: #compliance-critical",
"type": "main",
"index": 0
}
],
[
{
"node": "Gmail: Owner Alert",
"type": "main",
"index": 0
}
]
]
}
}
}
Workflow 4: InsurTech Incident & TCPA Alert Pipeline
Webhook-triggered. Returns 200 ACK immediately to avoid timeout. Routes 8 incident types to the correct Slack channel, emails CEO + Legal with CISO BCC, and appends to an audit log.
8 incident types and SLAs:
| Incident | SLA | Regulation |
|---|---|---|
TCPA_UNSOLICITED_AUTODIALING |
Immediate — $500–$1,500/call, class action | 47 USC §227(b)(3) |
NY_DFS_CYBERSECURITY_INCIDENT |
72 hours to DFS Superintendent | 23 NYCRR §500.17(a) |
HIPAA_PHI_BREACH_OVER_500 |
60 days OCR + immediate media notice | 45 CFR §164.408/406 |
GLBA_DATA_BREACH_NOTIFICATION |
30 days FTC + affected customers | 16 CFR §314.6 |
STATE_DOI_MARKET_CONDUCT_NOTICE |
10–30 biz days (state-specific) | NAIC Market Reg. Handbook |
FCRA_ADVERSE_ACTION_FAILURE |
Immediate — $100–$1,000/violation | 15 USC §1681n/o |
NAIC_ORSA_DISCREPANCY |
30 days before annual filing | NAIC ORSA Manual |
DATA_BREACH_POLICY_INFORMATION |
72h NY DFS concurrent + 60d HIPAA if PHI | §500.17 + §164.408 |
{
"name": "InsurTech Incident & TCPA Alert Pipeline",
"nodes": [
{
"id": "n1",
"name": "Webhook: Incident Event",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"parameters": {
"httpMethod": "POST",
"path": "insurtech-incident",
"responseMode": "responseNode"
}
},
{
"id": "n2",
"name": "Respond: 200 ACK",
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1,
"position": [
220,
220
],
"parameters": {
"respondWith": "text",
"responseBody": "accepted"
}
},
{
"id": "n3",
"name": "Code: Classify Incident",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
440,
0
],
"parameters": {
"jsCode": "const evt = $input.first().json.body || $input.first().json;\nconst incidentMap = {\n TCPA_UNSOLICITED_AUTODIALING: { sla: 'IMMEDIATE \u2014 $500-$1,500/call statutory damages (47 USC 227(b)(3)); treble for willful', channel: '#legal-urgent', severity: 'CRITICAL' },\n NY_DFS_CYBERSECURITY_INCIDENT: { sla: '72h to DFS Superintendent \u2014 23 NYCRR 500.17(a)', channel: '#compliance-critical', severity: 'CRITICAL' },\n HIPAA_PHI_BREACH_OVER_500: { sla: '60 days OCR + immediate media notice \u2014 45 CFR 164.408/164.406', channel: '#compliance-critical', severity: 'CRITICAL' },\n GLBA_DATA_BREACH_NOTIFICATION: { sla: '30 days FTC Safeguards Rule \u2014 16 CFR 314.6', channel: '#compliance-ops', severity: 'HIGH' },\n STATE_DOI_MARKET_CONDUCT_NOTICE: { sla: '10-30 biz days (state-specific)', channel: '#compliance-ops', severity: 'HIGH' },\n FCRA_ADVERSE_ACTION_FAILURE: { sla: 'Immediate \u2014 $100-$1,000/violation + class action (15 USC 1681n/o)', channel: '#legal-urgent', severity: 'CRITICAL' },\n NAIC_ORSA_DISCREPANCY: { sla: '30 days before annual ORSA filing', channel: '#compliance-ops', severity: 'HIGH' },\n DATA_BREACH_POLICY_INFORMATION: { sla: '72h NY DFS concurrent + 60d HIPAA if PHI involved', channel: '#compliance-critical', severity: 'CRITICAL' }\n};\nconst cfg = incidentMap[evt.incident_type] || { sla: 'Unknown \u2014 escalate to CCO', channel: '#compliance-ops', severity: 'MEDIUM' };\nreturn [{ json: { ...evt, ...cfg } }];"
}
},
{
"id": "n4",
"name": "Slack: Incident Channel",
"type": "n8n-nodes-base.slack",
"typeVersion": 2,
"position": [
660,
0
],
"parameters": {
"resource": "message",
"operation": "post",
"channel": "={{$json.channel}}",
"text": "INSURTECH INCIDENT [{{$json.severity}}]: {{$json.incident_type}}\\nSLA: {{$json.sla}}\\nReporter: {{$json.reporter_email}}\\nDescription: {{$json.description}}"
}
},
{
"id": "n5",
"name": "Gmail: CEO + Legal BCC CISO",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
880,
0
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "={{$json.ceo_email}}",
"bcc": "={{$json.legal_email}},={{$json.ciso_email}}",
"subject": "[{{$json.severity}}] InsurTech Incident: {{$json.incident_type}}",
"emailType": "html",
"message": "<p>Incident: <strong>{{$json.incident_type}}</strong></p><p>SLA: <strong>{{$json.sla}}</strong></p><p>Description: {{$json.description}}</p><p>Reported: {{new Date().toISOString()}}</p><p>Assign incident commander immediately.</p>"
}
},
{
"id": "n6",
"name": "Sheets: Incident Log",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1100,
0
],
"parameters": {
"resource": "spreadsheet",
"operation": "append",
"documentId": "INSERT_SHEET_ID",
"sheetName": "Incident Log",
"columns": {
"mappingMode": "defineBelow",
"value": {
"ts": "={{new Date().toISOString()}}",
"incident_type": "={{$json.incident_type}}",
"severity": "={{$json.severity}}",
"sla": "={{$json.sla}}",
"reporter": "={{$json.reporter_email}}",
"description": "={{$json.description}}"
}
}
}
}
],
"connections": {
"Webhook: Incident Event": {
"main": [
[
{
"node": "Respond: 200 ACK",
"type": "main",
"index": 0
},
{
"node": "Code: Classify Incident",
"type": "main",
"index": 0
}
]
]
},
"Code: Classify Incident": {
"main": [
[
{
"node": "Slack: Incident Channel",
"type": "main",
"index": 0
}
]
]
},
"Slack: Incident Channel": {
"main": [
[
{
"node": "Gmail: CEO + Legal BCC CISO",
"type": "main",
"index": 0
}
]
]
},
"Gmail: CEO + Legal BCC CISO": {
"main": [
[
{
"node": "Sheets: Incident Log",
"type": "main",
"index": 0
}
]
]
}
}
}
Workflow 5: Weekly InsurTech KPI Dashboard
Runs Monday 8 AM. Pulls active customers, new customers, MRR, and new MRR from one Postgres query; pulls TCPA incidents, NY DFS cyber events, HIPAA breaches, open incidents, and critical deadlines from a second. Merges, computes MRR week-over-week via $getWorkflowStaticData, builds an HTML table, emails CEO + CCO with CISO BCC, and posts a one-liner to #weekly-kpi.
{
"name": "Weekly InsurTech KPI Dashboard",
"nodes": [
{
"id": "n1",
"name": "Schedule: Monday 8AM",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * 1"
}
]
}
}
},
{
"id": "n2",
"name": "Postgres: Platform Metrics",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
220,
0
],
"parameters": {
"operation": "executeQuery",
"query": "SELECT COUNT(DISTINCT customer_id) AS active_customers, COUNT(DISTINCT CASE WHEN created_at >= NOW() - INTERVAL '7 days' THEN customer_id END) AS new_this_week, SUM(mrr_usd) AS total_mrr, SUM(CASE WHEN created_at >= NOW() - INTERVAL '7 days' THEN mrr_usd ELSE 0 END) AS new_mrr FROM insurtech_accounts WHERE status = 'active'"
}
},
{
"id": "n3",
"name": "Postgres: Compliance Events",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
220,
220
],
"parameters": {
"operation": "executeQuery",
"query": "SELECT COUNT(CASE WHEN incident_type='NY_DFS_CYBERSECURITY_INCIDENT' AND created_at>=NOW()-INTERVAL '7 days' THEN 1 END) AS ny_dfs_incidents, COUNT(CASE WHEN incident_type='TCPA_UNSOLICITED_AUTODIALING' AND created_at>=NOW()-INTERVAL '7 days' THEN 1 END) AS tcpa_incidents, COUNT(CASE WHEN incident_type='HIPAA_PHI_BREACH_OVER_500' AND created_at>=NOW()-INTERVAL '7 days' THEN 1 END) AS hipaa_breaches, COUNT(CASE WHEN status='OPEN' THEN 1 END) AS open_incidents, COUNT(CASE WHEN urgency IN ('CRITICAL','OVERDUE') THEN 1 END) AS critical_deadlines FROM incident_log WHERE created_at>=NOW()-INTERVAL '7 days'"
}
},
{
"id": "n4",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 3,
"position": [
440,
0
],
"parameters": {
"mode": "combine",
"combinationMode": "multiplex"
}
},
{
"id": "n5",
"name": "Code: Build HTML Report",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
660,
0
],
"parameters": {
"jsCode": "const staticData = $getWorkflowStaticData('global');\nconst d = $input.first().json;\nconst prevMrr = staticData.prevMrr || d.total_mrr;\nconst mrrWoW = prevMrr > 0 ? (((d.total_mrr - prevMrr) / prevMrr) * 100).toFixed(1) : '0.0';\nstaticData.prevMrr = d.total_mrr;\nconst html = '<h2>InsurTech Platform Weekly Report</h2><table border=\"1\" cellpadding=\"6\" style=\"border-collapse:collapse\"><tr><th>Metric</th><th>Value</th><th>WoW</th></tr><tr><td>Active Customers</td><td>' + d.active_customers + '</td><td>-</td></tr><tr><td>New Customers</td><td>' + d.new_this_week + '</td><td>-</td></tr><tr><td>Total MRR</td><td>$' + Number(d.total_mrr||0).toLocaleString() + '</td><td>' + mrrWoW + '%</td></tr></table><h3>Compliance Scorecard (7d)</h3><table border=\"1\" cellpadding=\"6\" style=\"border-collapse:collapse\"><tr><th>Flag</th><th>Count</th></tr><tr><td>TCPA Incidents</td><td>' + (d.tcpa_incidents||0) + '</td></tr><tr><td>NY DFS Cyber Incidents</td><td>' + (d.ny_dfs_incidents||0) + '</td></tr><tr><td>HIPAA Breaches >500</td><td>' + (d.hipaa_breaches||0) + '</td></tr><tr><td>Open Incidents</td><td>' + (d.open_incidents||0) + '</td></tr><tr><td>Critical Deadlines</td><td>' + (d.critical_deadlines||0) + '</td></tr></table>';\nreturn [{ json: { ...d, html, mrrWoW } }];"
}
},
{
"id": "n6",
"name": "Gmail: CEO + CCO BCC CISO",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2,
"position": [
880,
0
],
"parameters": {
"resource": "message",
"operation": "send",
"sendTo": "INSERT_CEO_EMAIL",
"bcc": "INSERT_CCO_EMAIL,INSERT_CISO_EMAIL",
"subject": "Weekly InsurTech Platform Report",
"emailType": "html",
"message": "={{$json.html}}"
}
},
{
"id": "n7",
"name": "Slack: #weekly-kpi",
"type": "n8n-nodes-base.slack",
"typeVersion": 2,
"position": [
880,
220
],
"parameters": {
"resource": "message",
"operation": "post",
"channel": "#weekly-kpi",
"text": "Weekly InsurTech: {{$json.active_customers}} customers | MRR ${{$json.total_mrr}} ({{$json.mrrWoW}}% WoW) | TCPA incidents: {{$json.tcpa_incidents||0}} | NY DFS cyber: {{$json.ny_dfs_incidents||0}} | Open incidents: {{$json.open_incidents||0}}"
}
}
],
"connections": {
"Schedule: Monday 8AM": {
"main": [
[
{
"node": "Postgres: Platform Metrics",
"type": "main",
"index": 0
},
{
"node": "Postgres: Compliance Events",
"type": "main",
"index": 0
}
]
]
},
"Postgres: Platform Metrics": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Postgres: Compliance Events": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Code: Build HTML Report",
"type": "main",
"index": 0
}
]
]
},
"Code: Build HTML Report": {
"main": [
[
{
"node": "Gmail: CEO + CCO BCC CISO",
"type": "main",
"index": 0
},
{
"node": "Slack: #weekly-kpi",
"type": "main",
"index": 0
}
]
]
}
}
}
Why InsurTech Teams Self-Host n8n
| Requirement | Cloud n8n / Zapier / Make | Self-Hosted n8n |
|---|---|---|
| TCPA consent records in vendor-controlled table | TCPA exposure if breach | Postgres INSERT-only in your perimeter |
| NY DFS §500.11 TPSP inventory | Automation vendor = §500.11 entry requiring annual review | Eliminated — n8n runs inside your boundary |
| GLBA Safeguards §314.4 subprocessor controls | NPI transits vendor infrastructure | NPI never leaves your network |
| HIPAA BAA for health insurers | Requires BAA negotiation + shared-cloud PHI exposure | PHI stays in VPC — BAA question eliminated |
| NAIC ORSA model risk data | Proprietary reserving assumptions exit network | Actuarial data stays behind firewall |
| SOC 2 CC9.2 TPSP scope | Automation vendor added to SOC 2 review | n8n removed from scope |
Get the Full Workflow Pack
All 5 InsurTech workflows — plus 10 more n8n templates for SaaS teams — are available at stripeai.gumroad.com. Individual templates from $12. Bundle of 15 at $97.
Tags: #n8n #insurtech #automation #compliance #tcpa #nydfs #hipaa #naic
Originally published by Dev.to Security. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.