n8n for TelecomTech SaaS Vendors: 5 Automations for FCC CPNI, TCPA, and CALEA Compliance
If you sell SaaS into telecom — carriers, MVNOs, VoIP platforms, UCaaS, messaging APIs — you inherit a compliance stack most SaaS vendors never touch: FCC CPNI (47 CFR §222), CALEA, E-911 (Kari's Law), TCPA (47 CFR §64.1
If you sell SaaS into telecom — carriers, MVNOs, VoIP platforms, UCaaS, messaging APIs — you inherit a compliance stack most SaaS vendors never touch: FCC CPNI (47 CFR §222), CALEA, E-911 (Kari's Law), TCPA (47 CFR §64.1200), and STIR/SHAKEN attestation requirements.
The problem with cloud iPaaS (Zapier, Make) in this stack: subscriber call detail records, location data, and lawful intercept assistance capability cannot safely flow through third-party cloud automation platforms without creating FCC CPNI §222(c)(1) unauthorized disclosure risk and CALEA §103(b)(2) compliance exposure.
Self-hosted n8n eliminates the third-party data egress problem. Every workflow below runs inside your VPC. Here are 5 that TelecomTech SaaS vendors actually need.
1. Telecom Customer Onboarding Drip (Tier + Compliance-Flag Segmented)
Telecom customers span seven tiers with very different compliance profiles. One generic onboarding sequence breaks trust fast.
Customer tiers: ENTERPRISE_TELECOM_CARRIER · REGIONAL_TELECOM_CARRIER · MVNO_PLATFORM · VOIP_SAAS_VENDOR · UCaaS_PLATFORM · TELECOM_API_PROVIDER · MESSAGING_SAAS_VENDOR
Compliance flags: FCC_CPNI_HOLDER · CALEA_COVERED_ENTITY · E911_OBLIGATION · TCPA_COVERED_SENDER · STIR_SHAKEN_REQUIRED · GDPR_EU_COMMS_DATA · SOC2_REQUIRED
{
"name": "Telecom Customer Onboarding Drip",
"nodes": [
{
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"parameters": {
"path": "telecom-onboard",
"httpMethod": "POST"
},
"position": [
100,
300
]
},
{
"name": "Parse Customer",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const d = $input.first().json; const tiers = ['ENTERPRISE_TELECOM_CARRIER','REGIONAL_TELECOM_CARRIER','MVNO_PLATFORM','VOIP_SAAS_VENDOR','UCaaS_PLATFORM','TELECOM_API_PROVIDER','MESSAGING_SAAS_VENDOR']; const flags = ['FCC_CPNI_HOLDER','CALEA_COVERED_ENTITY','E911_OBLIGATION','TCPA_COVERED_SENDER','STIR_SHAKEN_REQUIRED','GDPR_EU_COMMS_DATA','SOC2_REQUIRED']; const tier = tiers.includes(d.tier) ? d.tier : 'MESSAGING_SAAS_VENDOR'; const compliance = (d.compliance_flags || []).filter(f => flags.includes(f)); const isCpni = compliance.includes('FCC_CPNI_HOLDER'); const isCalea = compliance.includes('CALEA_COVERED_ENTITY'); const isE911 = compliance.includes('E911_OBLIGATION'); const isTcpa = compliance.includes('TCPA_COVERED_SENDER'); const isEnterprise = ['ENTERPRISE_TELECOM_CARRIER','REGIONAL_TELECOM_CARRIER'].includes(tier); let cpniNote = isCpni ? ' Your FCC CPNI annual certification (47 CFR \u00a7222) is pre-configured in your compliance tracker.' : ''; let caleaNote = isCalea ? ' CALEA assistance capability documentation is available in your onboarding portal.' : ''; let e911Note = isE911 ? \" Kari's Law E-911 routing health monitor is active for your account.\" : ''; return [{json: {tier, compliance, isCpni, isCalea, isE911, isTcpa, isEnterprise, cpniNote, caleaNote, e911Note, email: d.email, company: d.company, name: d.contact_name || 'Team', accountId: d.account_id}}];"
},
"position": [
300,
300
]
},
{
"name": "Gmail Day 0",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "={{ $json.email }}",
"subject": "={{ 'Welcome to FlowKit \u2014 your n8n instance is ready, ' + $json.company }}",
"message": "={{ 'Hi ' + $json.name + ',\\n\\nYour self-hosted n8n workspace is live.' + $json.cpniNote + $json.caleaNote + $json.e911Note + '\\n\\nWe will check in on Day 3 with your first compliance workflow walkthrough.\\n\\nFlowKit Team' }}"
},
"position": [
550,
300
]
},
{
"name": "Log to Sheets",
"type": "n8n-nodes-base.googleSheets",
"parameters": {
"operation": "append",
"spreadsheetId": "YOUR_SHEET_ID",
"range": "Onboarding!A:H",
"dataMode": "autoMap"
},
"position": [
750,
300
]
},
{
"name": "Wait 3 Days",
"type": "n8n-nodes-base.wait",
"parameters": {
"amount": 3,
"unit": "days"
},
"position": [
950,
300
]
},
{
"name": "Gmail Day 3",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "={{ $json.email }}",
"subject": "={{ 'Day 3: Your CPNI + TCPA compliance workflows \u2014 ' + $json.company }}",
"message": "={{ 'Hi ' + $json.name + ',\\n\\nDay 3 check-in. Today we walk through your FCC CPNI \u00a7222 annual certification workflow and your TCPA consent audit pipeline.\\n\\nBoth are pre-built in your n8n instance. Book a 20-min walkthrough: https://calendly.com/flowkit/telecom-onboard\\n\\nFlowKit Team' }}"
},
"position": [
1150,
300
]
},
{
"name": "Wait 4 Days",
"type": "n8n-nodes-base.wait",
"parameters": {
"amount": 4,
"unit": "days"
},
"position": [
1350,
300
]
},
{
"name": "Gmail Day 7",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "={{ $json.email }}",
"subject": "={{ 'Day 7: STIR/SHAKEN + E-911 health monitor \u2014 ' + $json.company }}",
"message": "={{ 'Hi ' + $json.name + ',\\n\\nWeek one complete. Your STIR/SHAKEN attestation tracker and E-911 routing health monitor should have run their first cycle.\\n\\nAny alerts? Reply here \u2014 our telecom compliance team will review within 2 business hours.\\n\\nFlowKit Team' }}"
},
"position": [
1550,
300
]
}
],
"connections": {
"Webhook": {
"main": [
[
{
"node": "Parse Customer",
"type": "main",
"index": 0
}
]
]
},
"Parse Customer": {
"main": [
[
{
"node": "Gmail Day 0",
"type": "main",
"index": 0
}
]
]
},
"Gmail Day 0": {
"main": [
[
{
"node": "Log to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Log to Sheets": {
"main": [
[
{
"node": "Wait 3 Days",
"type": "main",
"index": 0
}
]
]
},
"Wait 3 Days": {
"main": [
[
{
"node": "Gmail Day 3",
"type": "main",
"index": 0
}
]
]
},
"Gmail Day 3": {
"main": [
[
{
"node": "Wait 4 Days",
"type": "main",
"index": 0
}
]
]
},
"Wait 4 Days": {
"main": [
[
{
"node": "Gmail Day 7",
"type": "main",
"index": 0
}
]
]
}
}
}
2. Telecom API & Network Health Monitor (CPNI / E-911 / CALEA Service Health)
Five endpoints, polled every 5 minutes. $getWorkflowStaticData tracks state transitions so you only fire an alert when status changes — not on every poll.
| Endpoint | Regulatory Risk |
|---|---|
cpni_data_api |
FCC §222 unauthorized disclosure if DOWN |
e911_routing_api |
Kari's Law §6(a) FCC notification required on failure |
calea_assist_api |
CALEA §103(b)(2) assistance capability obligation |
stir_shaken_api |
FCC gateway blocking risk on STIR/SHAKEN failure |
tcpa_consent_api |
§64.1200(a)(2) prior written consent chain broken |
{
"name": "Telecom API Health Monitor",
"nodes": [
{
"name": "Every 5 Min",
"type": "n8n-nodes-base.scheduleTrigger",
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 5
}
]
}
},
"position": [
100,
300
]
},
{
"name": "Check Endpoints",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const axios = require('axios'); const endpoints = [{name:'cpni_data_api',url:'https://api.internal/cpni/health',reg:'FCC \u00a7222 unauthorized disclosure risk'},{name:'e911_routing_api',url:'https://api.internal/e911/health',reg:\"Kari's Law \u00a76(a) FCC notification required\"},{name:'calea_assist_api',url:'https://api.internal/calea/health',reg:'CALEA \u00a7103(b)(2) assistance capability'},{name:'stir_shaken_api',url:'https://api.internal/stir-shaken/health',reg:'FCC gateway blocking risk'},{name:'tcpa_consent_api',url:'https://api.internal/tcpa-consent/health',reg:'\u00a764.1200(a)(2) consent chain broken'}]; const prev = $getWorkflowStaticData('global'); const results = []; for (const ep of endpoints) { let status = 'DOWN'; let latency = 9999; try { const start = Date.now(); const r = await axios.get(ep.url, {timeout:5000}); latency = Date.now() - start; status = r.status === 200 ? (latency > 3000 ? 'DEGRADED' : 'OK') : 'DOWN'; } catch(e) { status = 'DOWN'; } const prevStatus = prev[ep.name] || 'OK'; prev[ep.name] = status; if (status !== 'OK' && status !== prevStatus) results.push({...ep, status, latency, prevStatus}); } $setWorkflowStaticData('global', prev); return results.map(r => ({json: r}));"
},
"position": [
300,
300
]
},
{
"name": "Has Alerts?",
"type": "n8n-nodes-base.if",
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $input.all().length }}",
"operation": "larger",
"value2": 0
}
]
}
},
"position": [
550,
300
]
},
{
"name": "Slack Alert",
"type": "n8n-nodes-base.slack",
"parameters": {
"channel": "#telecom-ops-alerts",
"text": "={{ '\ud83d\udd34 TELECOM API ALERT: ' + $json.name + ' is ' + $json.status + ' (was ' + $json.prevStatus + ') \u2014 Reg risk: ' + $json.reg }}",
"otherOptions": {}
},
"position": [
750,
200
]
}
],
"connections": {
"Every 5 Min": {
"main": [
[
{
"node": "Check Endpoints",
"type": "main",
"index": 0
}
]
]
},
"Check Endpoints": {
"main": [
[
{
"node": "Has Alerts?",
"type": "main",
"index": 0
}
]
]
},
"Has Alerts?": {
"main": [
[
{
"node": "Slack Alert",
"type": "main",
"index": 0
}
],
[]
]
}
}
}
3. FCC / TCPA / E-911 Compliance Deadline Tracker
Twelve deadline types across the FCC + TCPA + state PSC regulatory stack. Runs weekdays at 08:00 and routes by urgency.
| Deadline Type | Regulation | Fastest Clock |
|---|---|---|
FCC_CPNI_ANNUAL_CERT |
47 CFR §64.2009(e) — March 1 | Annual |
FCC_FORM_499_ANNUAL |
47 CFR §54.711 — April 1 | Annual |
FCC_FORM_499_MID_YEAR |
47 CFR §54.711 — August 1 | Annual |
E911_QUARTERLY_TEST |
Kari's Law / RAY BAUM'S Act | Quarterly |
TCPA_CONSENT_AUDIT |
47 CFR §64.1200 | Quarterly |
STIR_SHAKEN_CERT_RENEWAL |
FCC Order 20-128 | Annual |
CALEA_COMPLIANCE_REVIEW |
47 USC §1002 | Annual |
FCC_ROBOCALL_MITIGATION_CERT |
FCC Docket 17-97 | Annual |
STATE_PSC_TARIFF_RENEWAL |
State regulatory | Varies |
GDPR_ART28_DPA_REVIEW |
GDPR Article 28 | Annual |
SOC2_TYPE2_RENEWAL |
SOC 2 | Annual |
ANNUAL_PENTEST |
Security baseline | Annual |
{
"name": "Telecom Compliance Deadline Tracker",
"nodes": [
{
"name": "Weekdays 8AM",
"type": "n8n-nodes-base.scheduleTrigger",
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * 1-5"
}
]
}
},
"position": [
100,
300
]
},
{
"name": "Get Deadlines",
"type": "n8n-nodes-base.googleSheets",
"parameters": {
"operation": "read",
"spreadsheetId": "YOUR_SHEET_ID",
"range": "TelecomDeadlines!A:F"
},
"position": [
300,
300
]
},
{
"name": "Classify Urgency",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const items = $input.all(); const today = new Date(); const results = []; for (const item of items) { const d = item.json; if (!d.deadline_date || d.alert_sent_date === new Date().toISOString().slice(0,10)) continue; const daysLeft = Math.floor((new Date(d.deadline_date) - today) / 86400000); let urgency = null; if (daysLeft < 0) urgency = 'OVERDUE'; else if (daysLeft <= 4) urgency = 'CRITICAL'; else if (daysLeft <= 14) urgency = 'URGENT'; else if (daysLeft <= 30) urgency = 'WARNING'; else if (daysLeft <= 60) urgency = 'NOTICE'; if (urgency) results.push({json: {...d, daysLeft, urgency}}); } return results;"
},
"position": [
550,
300
]
},
{
"name": "Route by Urgency",
"type": "n8n-nodes-base.switch",
"parameters": {
"dataType": "string",
"value": "={{ $json.urgency }}",
"rules": {
"rules": [
{
"value": "OVERDUE",
"output": 0
},
{
"value": "CRITICAL",
"output": 1
},
{
"value": "URGENT",
"output": 2
},
{
"value": "WARNING",
"output": 3
},
{
"value": "NOTICE",
"output": 4
}
]
}
},
"position": [
750,
300
]
},
{
"name": "Slack OVERDUE",
"type": "n8n-nodes-base.slack",
"parameters": {
"channel": "#compliance-critical",
"text": "={{ '\ud83d\udea8 OVERDUE: ' + $json.deadline_type + ' was due ' + $json.deadline_date + ' (' + Math.abs($json.daysLeft) + ' days ago) \u2014 Owner: ' + $json.owner }}",
"otherOptions": {}
},
"position": [
1000,
100
]
},
{
"name": "Slack CRITICAL",
"type": "n8n-nodes-base.slack",
"parameters": {
"channel": "#compliance-critical",
"text": "={{ '\ud83d\udd34 CRITICAL (\u22644d): ' + $json.deadline_type + ' due ' + $json.deadline_date + ' (' + $json.daysLeft + ' days) \u2014 ' + $json.owner }}",
"otherOptions": {}
},
"position": [
1000,
220
]
},
{
"name": "Gmail URGENT",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "={{ $json.owner_email }}",
"subject": "={{ 'URGENT: ' + $json.deadline_type + ' due in ' + $json.daysLeft + ' days' }}",
"message": "={{ $json.deadline_type + ' is due ' + $json.deadline_date + '. Please complete and update the tracker.' }}"
},
"position": [
1000,
340
]
},
{
"name": "Gmail WARNING",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "={{ $json.owner_email }}",
"subject": "={{ 'Compliance reminder: ' + $json.deadline_type + ' in ' + $json.daysLeft + ' days' }}",
"message": "={{ $json.deadline_type + ' is due ' + $json.deadline_date + '. Plan accordingly.' }}"
},
"position": [
1000,
460
]
}
],
"connections": {
"Weekdays 8AM": {
"main": [
[
{
"node": "Get Deadlines",
"type": "main",
"index": 0
}
]
]
},
"Get Deadlines": {
"main": [
[
{
"node": "Classify Urgency",
"type": "main",
"index": 0
}
]
]
},
"Classify Urgency": {
"main": [
[
{
"node": "Route by Urgency",
"type": "main",
"index": 0
}
]
]
},
"Route by Urgency": {
"main": [
[
{
"node": "Slack OVERDUE",
"type": "main",
"index": 0
}
],
[
{
"node": "Slack CRITICAL",
"type": "main",
"index": 0
}
],
[
{
"node": "Gmail URGENT",
"type": "main",
"index": 0
}
],
[
{
"node": "Gmail WARNING",
"type": "main",
"index": 0
}
],
[]
]
}
}
}
4. CPNI / CALEA / TCPA Incident Pipeline
Eight incident types with SLA clocks derived from the actual regulatory text.
| Incident Type | Fastest Clock | Regulator |
|---|---|---|
CPNI_UNAUTHORIZED_DISCLOSURE |
7 business days (notify FBI/USSS) + 30 days (notify customers) | FCC 47 CFR §64.2011 |
CALEA_LAWFUL_INTERCEPT_FAILURE |
Immediate escalation | FBI/DEA |
E911_CALL_ROUTING_FAILURE |
FCC notification required | Kari's Law §6(a) |
TCPA_REGULATORY_COMPLAINT |
30 days response | FCC/FTC |
STIR_SHAKEN_ATTESTATION_FAILURE |
24h — FCC gateway blocking risk | FCC Order 20-128 |
DATA_BREACH_SUBSCRIBER_PII |
72h state AG + FCC notification | State laws + FCC |
ROBOCALL_MITIGATION_FAILURE |
Traceback response — 24h | FCC Docket 17-97 |
STATE_PSC_ENFORCEMENT_ACTION |
Immediate | State PSC |
{
"name": "Telecom Incident Pipeline",
"nodes": [
{
"name": "Incident Webhook",
"type": "n8n-nodes-base.webhook",
"parameters": {
"path": "telecom-incident",
"httpMethod": "POST"
},
"position": [
100,
300
]
},
{
"name": "Classify & Time",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const d = $input.first().json; const slaMap = {CPNI_UNAUTHORIZED_DISCLOSURE:{hours:168,label:'7 biz-day FBI/USSS + 30d customer notify',reg:'FCC 47 CFR \u00a764.2011',severity:'CRITICAL'},CALEA_LAWFUL_INTERCEPT_FAILURE:{hours:1,label:'Immediate FBI/DEA escalation',reg:'CALEA \u00a7103(b)(2)',severity:'CRITICAL'},E911_CALL_ROUTING_FAILURE:{hours:4,label:'FCC notification required',reg:\"Kari's Law \u00a76(a)\",severity:'CRITICAL'},TCPA_REGULATORY_COMPLAINT:{hours:720,label:'30-day FCC/FTC response',reg:'47 CFR \u00a764.1200',severity:'HIGH'},STIR_SHAKEN_ATTESTATION_FAILURE:{hours:24,label:'FCC gateway blocking risk',reg:'FCC Order 20-128',severity:'HIGH'},DATA_BREACH_SUBSCRIBER_PII:{hours:72,label:'72h state AG + FCC',reg:'State laws + FCC',severity:'CRITICAL'},ROBOCALL_MITIGATION_FAILURE:{hours:24,label:'FCC traceback response',reg:'FCC Docket 17-97',severity:'HIGH'},STATE_PSC_ENFORCEMENT_ACTION:{hours:1,label:'Immediate \u2014 state PSC',reg:'State PSC',severity:'CRITICAL'}}; const sla = slaMap[d.incident_type] || {hours:72,label:'72h default',reg:'Internal',severity:'HIGH'}; const deadline = new Date(Date.now() + sla.hours * 3600000).toISOString(); return [{json: {...d, ...sla, deadline, incidentId: 'TEL-' + Date.now()}}];"
},
"position": [
300,
300
]
},
{
"name": "Log to Postgres",
"type": "n8n-nodes-base.postgres",
"parameters": {
"operation": "executeQuery",
"query": "INSERT INTO telecom_incidents (incident_id, incident_type, severity, sla_deadline, reg_citation, reported_at, account_id) VALUES ('{{ $json.incidentId }}', '{{ $json.incident_type }}', '{{ $json.severity }}', '{{ $json.deadline }}', '{{ $json.reg }}', NOW(), '{{ $json.account_id }}') ON CONFLICT DO NOTHING;"
},
"position": [
550,
300
]
},
{
"name": "Slack Ops Alert",
"type": "n8n-nodes-base.slack",
"parameters": {
"channel": "#telecom-incidents",
"text": "={{ '\ud83d\udea8 ' + $json.severity + ': ' + $json.incident_type + ' | ID: ' + $json.incidentId + ' | SLA: ' + $json.label + ' | Reg: ' + $json.reg + ' | Deadline: ' + $json.deadline }}",
"otherOptions": {}
},
"position": [
750,
300
]
},
{
"name": "Gmail Compliance",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "[email protected]",
"ccList": "[email protected]",
"subject": "={{ '[' + $json.severity + '] Telecom Incident: ' + $json.incident_type + ' \u2014 ' + $json.incidentId }}",
"message": "={{ 'Incident: ' + $json.incident_type + '\\nID: ' + $json.incidentId + '\\nSLA: ' + $json.label + '\\nRegulation: ' + $json.reg + '\\nDeadline: ' + $json.deadline + '\\nAccount: ' + ($json.account_id || 'N/A') }}"
},
"position": [
950,
300
]
}
],
"connections": {
"Incident Webhook": {
"main": [
[
{
"node": "Classify & Time",
"type": "main",
"index": 0
}
]
]
},
"Classify & Time": {
"main": [
[
{
"node": "Log to Postgres",
"type": "main",
"index": 0
}
]
]
},
"Log to Postgres": {
"main": [
[
{
"node": "Slack Ops Alert",
"type": "main",
"index": 0
}
]
]
},
"Slack Ops Alert": {
"main": [
[
{
"node": "Gmail Compliance",
"type": "main",
"index": 0
}
]
]
}
}
}
5. Weekly TelecomTech KPI Dashboard
Monday 08:00. CEO + CTO email. BCC: CISO (closes the governance gap — your board needs to know CPNI incident count and STIR/SHAKEN attestation rate weekly, not quarterly).
{
"name": "Weekly TelecomTech KPI Dashboard",
"nodes": [
{
"name": "Monday 8AM",
"type": "n8n-nodes-base.scheduleTrigger",
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * 1"
}
]
}
},
"position": [
100,
300
]
},
{
"name": "Query Metrics",
"type": "n8n-nodes-base.postgres",
"parameters": {
"operation": "executeQuery",
"query": "SELECT COUNT(*) FILTER (WHERE tier = 'ENTERPRISE_TELECOM_CARRIER') as enterprise_carriers, COUNT(*) FILTER (WHERE tier = 'VOIP_SAAS_VENDOR') as voip_vendors, COUNT(*) FILTER (WHERE tier = 'MESSAGING_SAAS_VENDOR') as messaging_vendors, COUNT(*) as total_accounts, SUM(mrr_usd) as total_mrr, SUM(mrr_usd) - LAG(SUM(mrr_usd)) OVER (ORDER BY DATE_TRUNC('week', created_at)) as mrr_wow FROM telecom_accounts WHERE active = true;"
},
"position": [
300,
300
]
},
{
"name": "Query Compliance",
"type": "n8n-nodes-base.postgres",
"parameters": {
"operation": "executeQuery",
"query": "SELECT COUNT(*) FILTER (WHERE incident_type = 'CPNI_UNAUTHORIZED_DISCLOSURE' AND reported_at >= NOW() - INTERVAL '7 days') as cpni_incidents_7d, COUNT(*) FILTER (WHERE incident_type = 'E911_CALL_ROUTING_FAILURE' AND reported_at >= NOW() - INTERVAL '7 days') as e911_failures_7d, COUNT(*) FILTER (WHERE incident_type = 'TCPA_REGULATORY_COMPLAINT' AND reported_at >= NOW() - INTERVAL '7 days') as tcpa_complaints_7d, COUNT(*) FILTER (WHERE severity = 'CRITICAL' AND status = 'OPEN') as open_critical FROM telecom_incidents;"
},
"position": [
300,
480
]
},
{
"name": "Merge",
"type": "n8n-nodes-base.merge",
"parameters": {
"mode": "combine",
"combinationMode": "mergeByIndex"
},
"position": [
550,
380
]
},
{
"name": "Build Report",
"type": "n8n-nodes-base.code",
"parameters": {
"jsCode": "const m = $input.first().json; const mrr = (m.total_mrr || 0); const wow = (m.mrr_wow || 0); const wowPct = mrr > 0 ? ((wow / mrr) * 100).toFixed(1) : '0.0'; const wowFlag = Math.abs(parseFloat(wowPct)) > 10 ? ' \u26a0\ufe0f' : ''; const cpniFlag = (m.cpni_incidents_7d || 0) > 0 ? ' \ud83d\udea8' : ''; const e911Flag = (m.e911_failures_7d || 0) > 0 ? ' \ud83d\udd34' : ''; const critFlag = (m.open_critical || 0) > 0 ? ' \ud83d\udea8' : ''; const html = `<h2>TelecomTech Weekly KPI \u2014 ${new Date().toISOString().slice(0,10)}</h2><table border='1' cellpadding='6' style='border-collapse:collapse'><tr><th>Metric</th><th>Value</th></tr><tr><td>Enterprise Carriers</td><td>${m.enterprise_carriers || 0}</td></tr><tr><td>VoIP SaaS Vendors</td><td>${m.voip_vendors || 0}</td></tr><tr><td>Messaging SaaS Vendors</td><td>${m.messaging_vendors || 0}</td></tr><tr><td>Total Accounts</td><td>${m.total_accounts || 0}</td></tr><tr><td>MRR</td><td>$${mrr.toLocaleString()} (${wowPct > 0 ? '+' : ''}${wowPct}% WoW${wowFlag})</td></tr><tr><td>CPNI Incidents (7d)${cpniFlag}</td><td>${m.cpni_incidents_7d || 0}</td></tr><tr><td>E-911 Failures (7d)${e911Flag}</td><td>${m.e911_failures_7d || 0}</td></tr><tr><td>TCPA Complaints (7d)</td><td>${m.tcpa_complaints_7d || 0}</td></tr><tr><td>Open Critical Incidents${critFlag}</td><td>${m.open_critical || 0}</td></tr></table>`; return [{json: {...m, html, wowPct}}];"
},
"position": [
800,
380
]
},
{
"name": "Gmail KPI",
"type": "n8n-nodes-base.gmail",
"parameters": {
"operation": "send",
"toList": "[email protected],[email protected]",
"bccList": "[email protected]",
"subject": "={{ 'TelecomTech Weekly KPI \u2014 ' + new Date().toISOString().slice(0,10) }}",
"message": "={{ $json.html }}",
"options": {
"replyTo": "[email protected]"
}
},
"position": [
1050,
380
]
}
],
"connections": {
"Monday 8AM": {
"main": [
[
{
"node": "Query Metrics",
"type": "main",
"index": 0
}
],
[
{
"node": "Query Compliance",
"type": "main",
"index": 0
}
]
]
},
"Query Metrics": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Query Compliance": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Build Report",
"type": "main",
"index": 0
}
]
]
},
"Build Report": {
"main": [
[
{
"node": "Gmail KPI",
"type": "main",
"index": 0
}
]
]
}
}
}
Why self-hosted n8n for TelecomTech SaaS
| Regulatory Risk | What Breaks With Cloud iPaaS | n8n Self-Hosted Fix |
|---|---|---|
| FCC CPNI §222(c)(1) | Subscriber call records, location, service plan data flowing through Zapier = potential unauthorized disclosure to non-employees | CPNI data stays in your VPC — no third-party data egress |
| CALEA §103(b)(2) | Lawful intercept workflow routed through Make.com creates third-party dependency in the assistance capability chain | CALEA assistance workflows run in-enclave, no external CSP in the chain |
| E-911 Kari's Law | Dispatchable location data in cloud iPaaS audit log = chain-of-custody gap | E-911 routing health monitor and incident pipeline run air-gapped |
| TCPA §64.1200(a)(2) | Consent records flowing through Zapier → Zapier's own audit log becomes consent evidence target in class actions | Consent chain stays in git-versioned Postgres under your control |
| SOC2 CC9.2 | Zapier/Make = subprocessor on every enterprise telecom customer's vendor risk assessment → procurement blocks you | Self-hosted n8n = no new subprocessor → clears enterprise procurement |
Get the pre-built templates
All five workflows are available as import-ready JSON at stripeai.gumroad.com — part of the FlowKit n8n template library.
Drop questions in the comments — especially if you are dealing with a specific FCC CPNI or CALEA compliance edge case.
Originally published by Dev.to Security. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.