Dev.to Security 🔐 Cybersecurity 👁 0 📖 22 min read

n8n for TelecomTech SaaS Vendors: 5 Automations for FCC CPNI, STIR/SHAKEN, TCPA, and CALEA Compliance

TelecomTech SaaS vendors — UCaaS platforms, CPaaS providers, MVNO operators, billing SaaS — face a compliance stack that most generic iPaaS tools can't touch: FCC CPNI §64.2010, STIR/SHAKEN 47 CFR §64.6300, TCPA 47 USC §

TelecomTech SaaS vendors — UCaaS platforms, CPaaS providers, MVNO operators, billing SaaS — face a compliance stack that most generic iPaaS tools can't touch: FCC CPNI §64.2010, STIR/SHAKEN 47 CFR §64.6300, TCPA 47 USC §227, CALEA 47 USC §1002, and FCC E-911 §9.5.

The fastest clock in telecom compliance: 30 minutes. Under 47 CFR §4.5, any network outage affecting 911 emergency services must be reported to the FCC within 30 minutes of determining the outage. The second fastest: CPNI unauthorized disclosure must be filed with the FCC and law enforcement within 7 calendar days (§64.2011), with willful violations at $10,000/day.

The self-hosting argument for telecom SaaS: FCC CPNI §64.2010 defines routing customer proprietary network information through a cloud iPaaS as a potential unauthorized CPNI disclosure event — you have to be able to demonstrate that CPNI was never accessible to any unauthorized person, including the workflow automation vendor. CALEA is even stricter: 18 USC §2515 provides an exclusionary rule for evidence obtained through a failed or unauthorized intercept — if your lawful intercept capability routes through an uncontrolled third-party SaaS at any point, a DOJ/FBI attorney will argue for suppression. STIR/SHAKEN attestation signing keys cannot reside in a shared cloud automation environment without triggering key management questions under FCC rules.

Here are 5 production-ready n8n workflows for TelecomTech SaaS vendors. Import each JSON block directly into your n8n instance.

Workflow 1: TelecomTech Customer Onboarding Drip

Classifies new customers into 7 tiers (TIER_1_NATIONAL_CARRIER / MID_MARKET_REGIONAL_CARRIER / MVNO_OPERATOR / VOIP_UCAAS_VENDOR / CPAAS_PLATFORM_VENDOR / TELECOM_BILLING_SAAS / ENTERPRISE_TELECOM_TECH_VENDOR) and injects CPNI / STIR-SHAKEN / CALEA / TCPA / E-911 / PCI compliance context into Day 0, Day 3, and Day 7 onboarding emails.

{
  "name": "TelecomTech Customer Onboarding Drip",
  "nodes": [
    {
      "id": "w1n1",
      "name": "Webhook \u2014 New Customer",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        0,
        0
      ],
      "parameters": {
        "path": "telecom-new-customer",
        "responseMode": "responseNode"
      }
    },
    {
      "id": "w1n2",
      "name": "Respond OK",
      "type": "n8n-nodes-base.respondToWebhook",
      "typeVersion": 1,
      "position": [
        200,
        0
      ],
      "parameters": {
        "respondWith": "text",
        "responseBody": "OK"
      }
    },
    {
      "id": "w1n3",
      "name": "Set \u2014 Tier & Flags",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3,
      "position": [
        400,
        0
      ],
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "name": "customer_tier",
              "value": "={{ $json.tier === 'tier1' ? 'TIER_1_NATIONAL_CARRIER' : $json.tier === 'midmarket' ? 'MID_MARKET_REGIONAL_CARRIER' : $json.tier === 'mvno' ? 'MVNO_OPERATOR' : $json.product === 'voip' ? 'VOIP_UCAAS_VENDOR' : $json.product === 'cpaas' ? 'CPAAS_PLATFORM_VENDOR' : $json.product === 'billing' ? 'TELECOM_BILLING_SAAS' : 'ENTERPRISE_TELECOM_TECH_VENDOR' }}",
              "type": "string"
            },
            {
              "name": "flag_cpni",
              "value": "={{ $json.cpni_program === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_stir_shaken",
              "value": "={{ $json.stir_shaken === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_calea",
              "value": "={{ $json.calea_capable === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_tcpa",
              "value": "={{ $json.tcpa_consent_mgr === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_e911",
              "value": "={{ $json.e911_provider === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_pci_billing",
              "value": "={{ $json.processes_payments === true }}",
              "type": "boolean"
            },
            {
              "name": "flag_usf",
              "value": "={{ $json.usf_filer === true }}",
              "type": "boolean"
            }
          ]
        }
      }
    },
    {
      "id": "w1n4",
      "name": "Gmail \u2014 Day 0 Welcome",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        600,
        0
      ],
      "parameters": {
        "sendTo": "={{ $json.email }}",
        "subject": "Welcome to FlowKit \u2014 TelecomTech Compliance Setup",
        "emailType": "html",
        "message": "={{ '<h2>Welcome, ' + $json.company + '!</h2><p>Tier: <strong>' + $('Set \u2014 Tier & Flags').item.json.customer_tier + '</strong></p>' + ($('Set \u2014 Tier & Flags').item.json.flag_cpni ? '<p><strong>FCC CPNI \u00a764.2010:</strong> Annual certification due March 1. Unauthorized disclosure must be filed with FCC within 7 calendar days (\u00a764.2011) \u2014 our 28-min monitor catches it first.</p>' : '') + ($('Set \u2014 Tier & Flags').item.json.flag_stir_shaken ? '<p><strong>STIR/SHAKEN 47 CFR \u00a764.6300:</strong> Attestation signing key management template included.</p>' : '') + ($('Set \u2014 Tier & Flags').item.json.flag_calea ? '<p><strong>CALEA 47 USC \u00a71002:</strong> Lawful intercept capability worksheet included \u2014 18 USC \u00a72515 exclusionary rule applies if capability fails during an active DOJ/FBI order.</p>' : '') + ($('Set \u2014 Tier & Flags').item.json.flag_e911 ? '<p><strong>FCC E-911 \u00a79.5:</strong> Network outage affecting 911 requires report within 30 minutes (47 CFR \u00a74.5).</p>' : '') + ($('Set \u2014 Tier & Flags').item.json.flag_tcpa ? '<p><strong>TCPA 47 USC \u00a7227:</strong> Consent audit log is Postgres INSERT-only. Exposure: $500\u2013$1,500/call without consent.</p>' : '') + '<p>\u2014 FlowKit Automation Team</p>' }}"
      }
    },
    {
      "id": "w1n5",
      "name": "Sheets \u2014 Log Onboarding",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4,
      "position": [
        800,
        0
      ],
      "parameters": {
        "operation": "append",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "telecom_customers",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "customer_id": "={{ $json.customer_id }}",
            "company": "={{ $json.company }}",
            "email": "={{ $json.email }}",
            "tier": "={{ $('Set \u2014 Tier & Flags').item.json.customer_tier }}",
            "cpni": "={{ $('Set \u2014 Tier & Flags').item.json.flag_cpni }}",
            "stir_shaken": "={{ $('Set \u2014 Tier & Flags').item.json.flag_stir_shaken }}",
            "calea": "={{ $('Set \u2014 Tier & Flags').item.json.flag_calea }}",
            "tcpa": "={{ $('Set \u2014 Tier & Flags').item.json.flag_tcpa }}",
            "e911": "={{ $('Set \u2014 Tier & Flags').item.json.flag_e911 }}",
            "pci_billing": "={{ $('Set \u2014 Tier & Flags').item.json.flag_pci_billing }}",
            "onboarded_at": "={{ $now.toISO() }}",
            "day3_sent": "false",
            "day7_sent": "false"
          }
        }
      }
    },
    {
      "id": "w1n6",
      "name": "Wait \u2014 3 Days",
      "type": "n8n-nodes-base.wait",
      "typeVersion": 1,
      "position": [
        1000,
        0
      ],
      "parameters": {
        "unit": "days",
        "amount": 3
      }
    },
    {
      "id": "w1n7",
      "name": "Gmail \u2014 Day 3 Integration Guide",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        1200,
        0
      ],
      "parameters": {
        "sendTo": "={{ $json.email }}",
        "subject": "Day 3: Configure Your FCC & TCPA Monitoring Pipelines",
        "emailType": "html",
        "message": "<h2>Day 3: Your Compliance Monitoring</h2><p>Configure these endpoints in your n8n Health Monitor:<br/>\u2022 <code>cpni_api</code> \u2014 FCC \u00a764.2010 consent disclosure risk<br/>\u2022 <code>stir_shaken_gateway</code> \u2014 \u00a764.6300 attestation score<br/>\u2022 <code>calea_intercept_api</code> \u2014 18 USC \u00a72515 exclusionary rule<br/>\u2022 <code>porting_api</code> \u2014 FCC LNP porting rules<br/>\u2022 <code>billing_api</code> \u2014 PCI DSS v4.0 CHD scope</p><p>Full setup guide: https://stripeai.gumroad.com</p>"
      }
    },
    {
      "id": "w1n8",
      "name": "Wait \u2014 4 Days",
      "type": "n8n-nodes-base.wait",
      "typeVersion": 1,
      "position": [
        1400,
        0
      ],
      "parameters": {
        "unit": "days",
        "amount": 4
      }
    },
    {
      "id": "w1n9",
      "name": "Gmail \u2014 Day 7 Incident Response",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        1600,
        0
      ],
      "parameters": {
        "sendTo": "={{ $json.email }}",
        "subject": "Day 7: Activate Incident Response - FCC Sec 4.5, CALEA, TCPA Pipelines",
        "emailType": "html",
        "message": "<h2>Day 7: Incident Pipelines Active</h2><p>8 pre-configured incident types:<br/>\u2022 CPNI unauthorized disclosure \u2014 FCC \u00a764.2011 7-day notification clock<br/>\u2022 Network outage affecting 911 \u2014 FCC \u00a74.5 30-minute report (fastest clock)<br/>\u2022 CALEA intercept failure \u2014 DOJ/FBI 24h notice<br/>\u2022 TCPA mass autodial detection \u2014 immediate $500\u2013$1,500/call exposure<br/>\u2022 STIR/SHAKEN attestation failure \u2014 24h<br/>\u2022 Number port fraud \u2014 immediate<br/>\u2022 PCI CHD breach \u2014 1h<br/>\u2022 FCC robocall enforcement sweep \u2014 72h response prep</p>"
      }
    }
  ],
  "connections": {
    "Webhook \u2014 New Customer": {
      "main": [
        [
          {
            "node": "Respond OK",
            "type": "main",
            "index": 0
          },
          {
            "node": "Set \u2014 Tier & Flags",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set \u2014 Tier & Flags": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Day 0 Welcome",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail \u2014 Day 0 Welcome": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Log Onboarding",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Log Onboarding": {
      "main": [
        [
          {
            "node": "Wait \u2014 3 Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait \u2014 3 Days": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Day 3 Integration Guide",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail \u2014 Day 3 Integration Guide": {
      "main": [
        [
          {
            "node": "Wait \u2014 4 Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait \u2014 4 Days": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Day 7 Incident Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Workflow 2: TelecomTech API & Network Health Monitor

Polls 5 critical endpoints every 5 minutes with $getWorkflowStaticData deduplication to catch UP→DOWN transitions only. Each endpoint carries the specific regulatory annotation that fires when it goes down:

  • cpni_api — FCC §64.2010 CPNI disclosure risk
  • stir_shaken_gateway — §64.6300 attestation degraded
  • calea_intercept_api — 18 USC §2515 exclusionary rule risk during active DOJ/FBI order
  • porting_api — FCC LNP porting rule delay exposure
  • billing_api — PCI DSS v4.0 Req 6.3.3 CHD scope incident
{
  "name": "TelecomTech API & Network Health Monitor",
  "nodes": [
    {
      "id": "w2n1",
      "name": "Schedule \u2014 Every 5 Min",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 5
            }
          ]
        }
      }
    },
    {
      "id": "w2n2",
      "name": "HTTP \u2014 CPNI API",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        200,
        -200
      ],
      "parameters": {
        "url": "https://YOUR_CPNI_API/health",
        "method": "GET",
        "timeout": 10000
      }
    },
    {
      "id": "w2n3",
      "name": "HTTP \u2014 STIR/SHAKEN Gateway",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        200,
        -100
      ],
      "parameters": {
        "url": "https://YOUR_STIR_SHAKEN_GW/health",
        "method": "GET",
        "timeout": 10000
      }
    },
    {
      "id": "w2n4",
      "name": "HTTP \u2014 CALEA Intercept API",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        200,
        0
      ],
      "parameters": {
        "url": "https://YOUR_CALEA_API/health",
        "method": "GET",
        "timeout": 10000
      }
    },
    {
      "id": "w2n5",
      "name": "HTTP \u2014 Number Porting API",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        200,
        100
      ],
      "parameters": {
        "url": "https://YOUR_PORTING_API/health",
        "method": "GET",
        "timeout": 10000
      }
    },
    {
      "id": "w2n6",
      "name": "HTTP \u2014 Billing API",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        200,
        200
      ],
      "parameters": {
        "url": "https://YOUR_BILLING_API/health",
        "method": "GET",
        "timeout": 10000
      }
    },
    {
      "id": "w2n7",
      "name": "Code \u2014 Classify & Dedup",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        500,
        0
      ],
      "parameters": {
        "jsCode": "\nconst endpoints = [\n  { name: 'cpni_api', res: $('HTTP \u2014 CPNI API').first(), note: 'FCC \u00a764.2010 CPNI disclosure risk if DOWN \u2014 file with FCC within 7 days \u00a764.2011' },\n  { name: 'stir_shaken_gateway', res: $('HTTP \u2014 STIR/SHAKEN Gateway').first(), note: 'STIR/SHAKEN \u00a764.6300 attestation degraded \u2014 robocall compliance gap' },\n  { name: 'calea_intercept_api', res: $('HTTP \u2014 CALEA Intercept API').first(), note: '18 USC \u00a72515 exclusionary rule risk if DOWN during active DOJ/FBI intercept order' },\n  { name: 'porting_api', res: $('HTTP \u2014 Number Porting API').first(), note: 'FCC LNP porting rules \u2014 port delay exposure if DOWN' },\n  { name: 'billing_api', res: $('HTTP \u2014 Billing API').first(), note: 'PCI DSS v4.0 Req 6.3.3 CHD scope incident if DOWN' }\n];\n\nconst stateKey = 'telecom_api_prev';\nlet prev = $getWorkflowStaticData('global')[stateKey] || {};\nconst now = new Date().toISOString();\nconst alerts = [];\n\nfor (const ep of endpoints) {\n  const httpStatus = ep.res?.json?.$response?.statusCode ?? 0;\n  const isDown = httpStatus === 0 || httpStatus >= 500;\n  const wasUp = prev[ep.name] !== 'DOWN';\n  if (isDown && wasUp) {\n    alerts.push({ json: { endpoint: ep.name, status: 'DOWN', note: ep.note, ts: now, transition: 'UP\u2192DOWN' } });\n  }\n  prev[ep.name] = isDown ? 'DOWN' : 'UP';\n}\n$getWorkflowStaticData('global')[stateKey] = prev;\nreturn alerts.length ? alerts : [{ json: { endpoint: 'none', status: 'OK', note: '', ts: now, transition: '' } }];\n"
      }
    },
    {
      "id": "w2n8",
      "name": "IF \u2014 Has Alerts",
      "type": "n8n-nodes-base.if",
      "typeVersion": 2,
      "position": [
        700,
        0
      ],
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true
          },
          "conditions": [
            {
              "leftValue": "={{ $json.endpoint }}",
              "rightValue": "none",
              "operator": {
                "type": "string",
                "operation": "notEquals"
              }
            }
          ]
        }
      }
    },
    {
      "id": "w2n9",
      "name": "Slack \u2014 #telecom-ops",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        900,
        -100
      ],
      "parameters": {
        "channel": "#telecom-ops",
        "text": "={{ ':red_circle: TelecomTech API DOWN\\nEndpoint: ' + $json.endpoint + '\\n' + $json.note + '\\nTime: ' + $json.ts }}"
      }
    },
    {
      "id": "w2n10",
      "name": "Sheets \u2014 Log Incident",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4,
      "position": [
        900,
        100
      ],
      "parameters": {
        "operation": "append",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "telecom_api_incidents",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "endpoint": "={{ $json.endpoint }}",
            "status": "={{ $json.status }}",
            "note": "={{ $json.note }}",
            "ts": "={{ $json.ts }}",
            "transition": "={{ $json.transition }}"
          }
        }
      }
    }
  ],
  "connections": {
    "Schedule \u2014 Every 5 Min": {
      "main": [
        [
          {
            "node": "HTTP \u2014 CPNI API",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP \u2014 STIR/SHAKEN Gateway",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP \u2014 CALEA Intercept API",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP \u2014 Number Porting API",
            "type": "main",
            "index": 0
          },
          {
            "node": "HTTP \u2014 Billing API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP \u2014 CPNI API": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify & Dedup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP \u2014 STIR/SHAKEN Gateway": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify & Dedup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP \u2014 CALEA Intercept API": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify & Dedup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP \u2014 Number Porting API": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify & Dedup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP \u2014 Billing API": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify & Dedup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify & Dedup": {
      "main": [
        [
          {
            "node": "IF \u2014 Has Alerts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "IF \u2014 Has Alerts": {
      "main": [
        [
          {
            "node": "Slack \u2014 #telecom-ops",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets \u2014 Log Incident",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack \u2014 #telecom-ops": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Log Incident",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Workflow 3: FCC / TCPA / CALEA Compliance Deadline Tracker

Runs weekdays at 8AM. Reads your deadlines sheet and classifies into OVERDUE / CRITICAL (≤7d) / URGENT (≤21d) / WARNING (≤45d) / NOTICE (≤90d). Uses $getWorkflowStaticData to deduplicate — each deadline only alerts once per tier.

12 deadline types pre-configured:

  • FCC_CPNI_ANNUAL_CERT_MARCH_1 — 47 CFR §64.2009(e)
  • STIR_SHAKEN_ROBOCALL_FILING_ANNUAL — 47 CFR §64.6300
  • TCPA_CONSENT_AUDIT_ANNUAL — 47 USC §227
  • FCC_E911_ANNUAL_REPORT — 47 CFR §9.19
  • CALEA_CAPABILITY_AUDIT_ANNUAL — 47 USC §1002
  • FCC_UNIVERSAL_SERVICE_CONTRIBUTION — 47 CFR §54.706
  • USAC_E_RATE_FORM_471 — 47 CFR §54.503
  • FCC_DATA_BREACH_CPNI_REPORT — §64.2011
  • PCI_DSS_ANNUAL_QSA — PCI DSS v4.0
  • SOC2_TYPE2_RENEWAL
  • ISO_27001_SURVEILLANCE
  • STATE_PUC_ANNUAL_TARIFF_FILING
{
  "name": "FCC / TCPA / CALEA Compliance Deadline Tracker",
  "nodes": [
    {
      "id": "w3n1",
      "name": "Schedule \u2014 Daily 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * 1-5"
            }
          ]
        }
      }
    },
    {
      "id": "w3n2",
      "name": "Sheets \u2014 Read Deadlines",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4,
      "position": [
        200,
        0
      ],
      "parameters": {
        "operation": "read",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "telecom_deadlines"
      }
    },
    {
      "id": "w3n3",
      "name": "Code \u2014 Classify Tiers",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        400,
        0
      ],
      "parameters": {
        "jsCode": "\nconst rows = $('Sheets \u2014 Read Deadlines').all().map(r => r.json);\nconst now = new Date();\nconst results = [];\n\nfor (const row of rows) {\n  if (!row.deadline_date || row.dismissed === 'true') continue;\n  const daysUntil = Math.floor((new Date(row.deadline_date) - now) / 86400000);\n  let tier = null;\n  if (daysUntil < 0) tier = 'OVERDUE';\n  else if (daysUntil <= 7) tier = 'CRITICAL';\n  else if (daysUntil <= 21) tier = 'URGENT';\n  else if (daysUntil <= 45) tier = 'WARNING';\n  else if (daysUntil <= 90) tier = 'NOTICE';\n  if (!tier) continue;\n\n  const dedup_key = `${row.deadline_type}_${row.deadline_date}`;\n  const state = $getWorkflowStaticData('global');\n  if (state[dedup_key] === tier) continue;\n  state[dedup_key] = tier;\n\n  results.push({ json: {\n    deadline_type: row.deadline_type,\n    description: row.description,\n    deadline_date: row.deadline_date,\n    days_until: daysUntil,\n    tier: tier,\n    owner_email: row.owner_email,\n    citation: row.citation\n  }});\n}\nreturn results.length ? results : [];\n"
      }
    },
    {
      "id": "w3n4",
      "name": "Switch \u2014 Severity",
      "type": "n8n-nodes-base.switch",
      "typeVersion": 3,
      "position": [
        600,
        0
      ],
      "parameters": {
        "mode": "expression",
        "output": "={{ $json.tier }}",
        "rules": {
          "values": [
            {
              "outputKey": "OVERDUE",
              "value": "OVERDUE"
            },
            {
              "outputKey": "CRITICAL",
              "value": "CRITICAL"
            },
            {
              "outputKey": "URGENT",
              "value": "URGENT"
            },
            {
              "outputKey": "WARNING",
              "value": "WARNING"
            },
            {
              "outputKey": "NOTICE",
              "value": "NOTICE"
            }
          ]
        }
      }
    },
    {
      "id": "w3n5",
      "name": "Slack \u2014 CRITICAL/OVERDUE",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        900,
        -200
      ],
      "parameters": {
        "channel": "#compliance-critical",
        "text": "={{ ':rotating_light: [' + $json.tier + '] ' + $json.deadline_type + ' \u2014 ' + $json.description + ' | Due: ' + $json.deadline_date + ' (' + $json.days_until + 'd) | ' + $json.citation }}"
      }
    },
    {
      "id": "w3n6",
      "name": "Gmail \u2014 Owner Alert",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        900,
        0
      ],
      "parameters": {
        "sendTo": "={{ $json.owner_email }}",
        "subject": "={{ '[' + $json.tier + '] ' + $json.deadline_type + ' \u2014 ' + $json.days_until + ' days remaining' }}",
        "emailType": "html",
        "message": "={{ '<h3>' + $json.deadline_type + '</h3><p>' + $json.description + '</p><p><strong>Due:</strong> ' + $json.deadline_date + ' (' + $json.days_until + ' days)</p><p><strong>Citation:</strong> ' + $json.citation + '</p>' }}"
      }
    },
    {
      "id": "w3n7",
      "name": "Slack \u2014 URGENT/WARNING",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        900,
        100
      ],
      "parameters": {
        "channel": "#telecom-compliance",
        "text": "={{ ':warning: [' + $json.tier + '] ' + $json.deadline_type + ' in ' + $json.days_until + 'd \u2014 ' + $json.citation }}"
      }
    },
    {
      "id": "w3n8",
      "name": "Slack \u2014 NOTICE",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        900,
        200
      ],
      "parameters": {
        "channel": "#telecom-compliance",
        "text": "={{ ':calendar: [NOTICE] ' + $json.deadline_type + ' in ' + $json.days_until + 'd \u2014 ' + $json.citation }}"
      }
    }
  ],
  "connections": {
    "Schedule \u2014 Daily 8AM": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Read Deadlines",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Read Deadlines": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify Tiers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify Tiers": {
      "main": [
        [
          {
            "node": "Switch \u2014 Severity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch \u2014 Severity": {
      "main": [
        [
          {
            "node": "Slack \u2014 CRITICAL/OVERDUE",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Gmail \u2014 Owner Alert",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Slack \u2014 URGENT/WARNING",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Slack \u2014 NOTICE",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Slack \u2014 NOTICE",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack \u2014 CRITICAL/OVERDUE": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Owner Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Workflow 4: Telecom Incident & FCC Alert Pipeline

Webhook-triggered pipeline with 8 incident types and pre-configured regulatory SLAs:

Incident SLA Citation
CPNI_UNAUTHORIZED_DISCLOSURE 7 calendar days FCC §64.2011
FCC_OUTAGE_AFFECTING_911 30 minutes 47 CFR §4.5
CALEA_INTERCEPT_FAILURE 24h 47 USC §1002
TCPA_MASS_AUTODIAL_DETECTED Immediate 47 USC §227
STIR_SHAKEN_ATTESTATION_FAILURE 24h 47 CFR §64.6300
NUMBER_PORT_FRAUD Immediate FCC LNP Rules
PCI_CHD_BREACH 1h PCI DSS v4.0
FCC_ROBOCALL_ENFORCEMENT_SWEEP 72h FCC TCPA

FCC_OUTAGE_AFFECTING_911 at 30 minutes is the fastest notification clock in this stack — it fires Slack and email simultaneously with a Postgres INSERT-only audit trail.

{
  "name": "Telecom Incident & FCC Alert Pipeline",
  "nodes": [
    {
      "id": "w4n1",
      "name": "Webhook \u2014 Incident",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2,
      "position": [
        0,
        0
      ],
      "parameters": {
        "path": "telecom-incident",
        "responseMode": "responseNode"
      }
    },
    {
      "id": "w4n2",
      "name": "Respond OK",
      "type": "n8n-nodes-base.respondToWebhook",
      "typeVersion": 1,
      "position": [
        200,
        0
      ],
      "parameters": {
        "respondWith": "text",
        "responseBody": "OK"
      }
    },
    {
      "id": "w4n3",
      "name": "Code \u2014 Classify & Deadline",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        400,
        0
      ],
      "parameters": {
        "jsCode": "\nconst INCIDENT_CONFIG = {\n  CPNI_UNAUTHORIZED_DISCLOSURE: {\n    deadline_hours: 168,  // 7 calendar days \u2014 FCC \u00a764.2011 (fastest financial clock: $10k/day willful)\n    channel: '#compliance-critical',\n    escalate: true,\n    citation: 'FCC \u00a764.2011 \u2014 notify FCC + law enforcement within 7 calendar days'\n  },\n  FCC_OUTAGE_AFFECTING_911: {\n    deadline_hours: 0.5,  // 30 minutes \u2014 47 CFR \u00a74.5 \u2014 fastest notification clock\n    channel: '#network-ops-critical',\n    escalate: true,\n    citation: '47 CFR \u00a74.5 \u2014 file with FCC within 30 minutes of determining outage affects 911'\n  },\n  CALEA_INTERCEPT_FAILURE: {\n    deadline_hours: 24,\n    channel: '#legal-compliance',\n    escalate: true,\n    citation: '47 USC \u00a71002 + 18 USC \u00a72515 \u2014 notify DOJ/FBI within 24h; exclusionary rule if active order'\n  },\n  TCPA_MASS_AUTODIAL_DETECTED: {\n    deadline_hours: 0,  // immediate\n    channel: '#compliance-critical',\n    escalate: true,\n    citation: 'TCPA 47 USC \u00a7227 \u2014 $500\u2013$1,500/call without consent; class action exposure'\n  },\n  STIR_SHAKEN_ATTESTATION_FAILURE: {\n    deadline_hours: 24,\n    channel: '#telecom-ops',\n    escalate: false,\n    citation: '47 CFR \u00a764.6300 \u2014 STIR/SHAKEN robocall attestation failure; FCC enforcement risk'\n  },\n  NUMBER_PORT_FRAUD: {\n    deadline_hours: 0,  // immediate\n    channel: '#fraud-ops',\n    escalate: true,\n    citation: 'FCC LNP Rules \u2014 unauthorized port-out; customer notification required immediately'\n  },\n  PCI_CHD_BREACH: {\n    deadline_hours: 1,\n    channel: '#security-incident',\n    escalate: true,\n    citation: 'PCI DSS v4.0 Req 12.10.4 \u2014 notify acquiring bank within 1h; card brand notification'\n  },\n  FCC_ROBOCALL_ENFORCEMENT_SWEEP: {\n    deadline_hours: 72,\n    channel: '#legal-compliance',\n    escalate: false,\n    citation: 'FCC TCPA / Robocall Mitigation enforcement \u2014 compile consent records within 72h'\n  }\n};\n\nconst incident_type = $json.incident_type?.toUpperCase();\nconst cfg = INCIDENT_CONFIG[incident_type] || {\n  deadline_hours: 72, channel: '#telecom-compliance', escalate: false, citation: 'Review required'\n};\n\nconst deadline_ts = cfg.deadline_hours > 0\n  ? new Date(Date.now() + cfg.deadline_hours * 3600000).toISOString()\n  : new Date().toISOString();\n\nreturn [{json: {\n  incident_type,\n  severity: cfg.deadline_hours <= 1 ? 'CRITICAL' : cfg.deadline_hours <= 24 ? 'HIGH' : 'MEDIUM',\n  deadline_ts,\n  deadline_hours: cfg.deadline_hours,\n  channel: cfg.channel,\n  escalate: cfg.escalate,\n  citation: cfg.citation,\n  company: $json.company || 'UNKNOWN',\n  detail: $json.detail || '',\n  received_at: new Date().toISOString()\n}}];\n"
      }
    },
    {
      "id": "w4n4",
      "name": "Slack \u2014 Primary Alert",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        600,
        -100
      ],
      "parameters": {
        "channel": "={{ $json.channel }}",
        "text": "={{ ':rotating_light: [' + $json.severity + '] ' + $json.incident_type + '\\nCompany: ' + $json.company + '\\nDeadline: ' + ($json.deadline_hours > 0 ? $json.deadline_hours + 'h from now' : 'IMMEDIATE') + '\\n' + $json.citation + '\\nDetail: ' + $json.detail }}"
      }
    },
    {
      "id": "w4n5",
      "name": "Gmail \u2014 Incident Owner",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        600,
        0
      ],
      "parameters": {
        "sendTo": "compliance@YOUR_DOMAIN.com",
        "subject": "={{ '[' + $json.severity + '] Telecom Incident: ' + $json.incident_type }}",
        "emailType": "html",
        "message": "={{ '<h2>' + $json.incident_type + '</h2><p><strong>Severity:</strong> ' + $json.severity + '</p><p><strong>Company:</strong> ' + $json.company + '</p><p><strong>Regulatory Deadline:</strong> ' + ($json.deadline_hours > 0 ? $json.deadline_hours + ' hours from now (' + $json.deadline_ts + ')' : 'IMMEDIATE') + '</p><p><strong>Citation:</strong> ' + $json.citation + '</p><p><strong>Detail:</strong> ' + $json.detail + '</p>' }}"
      }
    },
    {
      "id": "w4n6",
      "name": "Postgres \u2014 Audit Log",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2,
      "position": [
        600,
        100
      ],
      "parameters": {
        "operation": "executeQuery",
        "query": "INSERT INTO telecom_incidents (incident_type, severity, company, deadline_ts, citation, detail, received_at) VALUES ('{{ $json.incident_type }}', '{{ $json.severity }}', '{{ $json.company }}', '{{ $json.deadline_ts }}', '{{ $json.citation }}', '{{ $json.detail }}', '{{ $json.received_at }}')"
      }
    }
  ],
  "connections": {
    "Webhook \u2014 Incident": {
      "main": [
        [
          {
            "node": "Respond OK",
            "type": "main",
            "index": 0
          },
          {
            "node": "Code \u2014 Classify & Deadline",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify & Deadline": {
      "main": [
        [
          {
            "node": "Slack \u2014 Primary Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack \u2014 Primary Alert": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Incident Owner",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail \u2014 Incident Owner": {
      "main": [
        [
          {
            "node": "Postgres \u2014 Audit Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Workflow 5: Weekly TelecomTech Platform KPI Dashboard

Every Monday at 8AM: Postgres query → HTML email to CEO + CCO (BCC CISO + Legal) + Slack #management one-liner.

KPIs tracked: Active customers / MRR (WoW%) / API calls (7d) / CPNI certs pending / STIR-SHAKEN avg score / Porting errors / TCPA consent violations / CALEA failures / Open incidents.

{
  "name": "Weekly TelecomTech Platform KPI Dashboard",
  "nodes": [
    {
      "id": "w5n1",
      "name": "Schedule \u2014 Monday 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * 1"
            }
          ]
        }
      }
    },
    {
      "id": "w5n2",
      "name": "Postgres \u2014 KPI Query",
      "type": "n8n-nodes-base.postgres",
      "typeVersion": 2,
      "position": [
        200,
        0
      ],
      "parameters": {
        "operation": "executeQuery",
        "query": "SELECT COUNT(DISTINCT customer_id) AS active_customers, SUM(mrr) AS mrr, COUNT(api_calls_7d) AS api_calls_7d, SUM(CASE WHEN cpni_cert_status='PENDING' THEN 1 ELSE 0 END) AS cpni_certs_pending, AVG(stir_shaken_score) AS stir_shaken_score_avg, SUM(porting_errors_7d) AS porting_errors_7d, SUM(tcpa_violations_7d) AS tcpa_consent_violations, SUM(calea_failures_7d) AS calea_capability_failures, COUNT(CASE WHEN status='OPEN' THEN 1 END) AS incidents_open FROM telecom_kpi_view"
      }
    },
    {
      "id": "w5n3",
      "name": "Code \u2014 Format HTML",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        400,
        0
      ],
      "parameters": {
        "jsCode": "\nconst metrics = $('Postgres \u2014 KPI Query').first().json;\nconst state = $getWorkflowStaticData('global');\nconst prev = state['telecom_kpi_prev'] || {};\n\nconst pct = (cur, prevKey) => {\n  const p = prev[prevKey];\n  if (!p || p === 0) return 'N/A';\n  const d = ((cur - p) / p * 100).toFixed(1);\n  return (d > 0 ? '+' : '') + d + '%';\n};\n\nconst summary = {\n  active_customers: metrics.active_customers,\n  mrr: metrics.mrr,\n  mrr_wow: pct(metrics.mrr, 'mrr'),\n  api_calls_7d: metrics.api_calls_7d,\n  cpni_certs_pending: metrics.cpni_certs_pending,\n  stir_shaken_score_avg: metrics.stir_shaken_score_avg,\n  porting_errors_7d: metrics.porting_errors_7d,\n  tcpa_consent_violations: metrics.tcpa_consent_violations,\n  calea_capability_failures: metrics.calea_capability_failures,\n  incidents_open: metrics.incidents_open\n};\n\nstate['telecom_kpi_prev'] = { mrr: metrics.mrr };\n$getWorkflowStaticData('global')['telecom_kpi_prev'] = state['telecom_kpi_prev'];\n\nconst html = `<h2>Weekly TelecomTech KPI \u2014 ${new Date().toDateString()}</h2>\n<table border=\"1\" cellpadding=\"6\">\n<tr><th>Metric</th><th>Value</th><th>WoW</th></tr>\n<tr><td>Active Customers</td><td>${summary.active_customers}</td><td>\u2014</td></tr>\n<tr><td>MRR</td><td>$${Number(summary.mrr).toLocaleString()}</td><td>${summary.mrr_wow}</td></tr>\n<tr><td>API Calls (7d)</td><td>${Number(summary.api_calls_7d).toLocaleString()}</td><td>\u2014</td></tr>\n<tr><td>CPNI Certs Pending</td><td>${summary.cpni_certs_pending}</td><td>\u2014</td></tr>\n<tr><td>STIR/SHAKEN Avg Score</td><td>${summary.stir_shaken_score_avg}</td><td>\u2014</td></tr>\n<tr><td>Porting Errors (7d)</td><td>${summary.porting_errors_7d}</td><td>\u2014</td></tr>\n<tr><td>TCPA Consent Violations</td><td>${summary.tcpa_consent_violations}</td><td>\u2014</td></tr>\n<tr><td>CALEA Failures</td><td>${summary.calea_capability_failures}</td><td>\u2014</td></tr>\n<tr><td>Open Incidents</td><td>${summary.incidents_open}</td><td>\u2014</td></tr>\n</table>`;\n\nreturn [{ json: { html, summary } }];\n"
      }
    },
    {
      "id": "w5n4",
      "name": "Gmail \u2014 KPI to CEO + CCO",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        600,
        -100
      ],
      "parameters": {
        "sendTo": "ceo@YOUR_DOMAIN.com",
        "bcc": "cco@YOUR_DOMAIN.com,ciso@YOUR_DOMAIN.com,legal@YOUR_DOMAIN.com",
        "subject": "={{ 'Weekly TelecomTech KPI \u2014 ' + new Date().toDateString() }}",
        "emailType": "html",
        "message": "={{ $json.html }}"
      }
    },
    {
      "id": "w5n5",
      "name": "Slack \u2014 #management",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        600,
        100
      ],
      "parameters": {
        "channel": "#management",
        "text": "={{ 'Weekly TelecomTech KPI: MRR $' + Number($json.summary.mrr).toLocaleString() + ' (' + $json.summary.mrr_wow + ' WoW) | CPNI Pending: ' + $json.summary.cpni_certs_pending + ' | TCPA Violations: ' + $json.summary.tcpa_consent_violations + ' | Open Incidents: ' + $json.summary.incidents_open }}"
      }
    }
  ],
  "connections": {
    "Schedule \u2014 Monday 8AM": {
      "main": [
        [
          {
            "node": "Postgres \u2014 KPI Query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Postgres \u2014 KPI Query": {
      "main": [
        [
          {
            "node": "Code \u2014 Format HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Format HTML": {
      "main": [
        [
          {
            "node": "Gmail \u2014 KPI to CEO + CCO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail \u2014 KPI to CEO + CCO": {
      "main": [
        [
          {
            "node": "Slack \u2014 #management",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Why self-hosted n8n for TelecomTech SaaS?

Risk Zapier / Make Self-hosted n8n
FCC CPNI §64.2010 CPNI routes through vendor cloud — potential unauthorized disclosure On-prem; CPNI never leaves your network
CALEA 47 USC §1002 Third-party SaaS = additional chain of custody question for DOJ/FBI Lawful intercept data stays in controlled enclave
TCPA consent records Cloud storage = third-party access risk Postgres INSERT-only on your infrastructure
STIR/SHAKEN signing keys Shared cloud = key management question Keys in HSM on your network
PCI DSS v4.0 Req 12.8 CDR billing data = TPSP scope expansion requiring full assessment In-scope by design, assessed once

5 buyer questions your enterprise prospects will ask

1. Does your workflow automation transmit CPNI outside our network?
Self-hosted n8n: No. Your CPNI consent database stays behind your firewall — the workflow runs inside your network boundary.

2. What happens to CALEA intercept metadata if a workflow node fails?
The incident pipeline logs the failure to Postgres immediately and pages your legal team with a 24-hour DOJ/FBI notification SLA — 18 USC §2515 exclusionary rule risk is surfaced in real time.

3. How do you prove TCPA consent at $1,500/call exposure?
The TCPA consent audit log uses Postgres INSERT-only — no UPDATE or DELETE — creating a tamper-evident record acceptable as evidence.

4. Can we demonstrate a STIR/SHAKEN audit trail to FCC enforcement?
Yes — every attestation-related event is logged with timestamp, call ID, and attestation level to Postgres, queryable for FCC subpoenas.

5. How fast does the FCC E-911 outage alert fire?
The health monitor polls every 5 minutes with UP→DOWN deduplication. FCC §4.5 requires a 30-minute report — you'll have 25 minutes to verify and draft the filing after the first alert.

All 5 workflows are included in the FlowKit n8n Automation Templates bundle — 15 production-ready workflows covering TelecomTech, FinTech, LegalTech, HealthTech, and more.

📰 Read the original article on Dev.to Security

Originally published by Dev.to Security. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.