n8n for EdTech SaaS Vendors: 5 Automations for Title IX, ADA Section 508, IDEA, and FERPA Compliance

{
  "name": "EdTech Vendor \u2014 New Institution Onboarding Drip (Title IX / 508 / IDEA / FERPA)",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "edtech-vendor-onboarding",
        "responseMode": "responseNode"
      },
      "name": "Webhook \u2014 New Institution Signup",
      "type": "n8n-nodes-base.webhook",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const inst = $input.first().json;\nconst tier = inst.institution_type || 'UNKNOWN';\nconst flags = {\n  TITLE_IX_APPLICABLE: ['K12_DISTRICT', 'HIGHER_ED', 'COMMUNITY_COLLEGE', 'PRIVATE_SCHOOL'].includes(tier),\n  SECTION_508_REQUIRED: ['HIGHER_ED', 'COMMUNITY_COLLEGE', 'FEDERAL_AGENCY_PARTNER'].includes(tier),\n  IDEA_ACCOMMODATION_SCOPE: ['K12_DISTRICT', 'CHARTER_SCHOOL', 'SPECIAL_ED_PROGRAM'].includes(tier),\n  FERPA_COVERED: tier !== 'CORPORATE_LD',\n  COPPA_APPLICABLE: tier === 'K12_DISTRICT',\n  WCAG_21_AA_REQUIRED: true,\n  SOC2_REQUIRED: ['HIGHER_ED', 'K12_DISTRICT', 'CORPORATE_LD'].includes(tier),\n  GDPR_EU_APPLICABLE: inst.country && ['GB','DE','FR','NL','SE','IE'].includes(inst.country)\n};\nreturn [{json: {...inst, tier, flags, onboarded_at: new Date().toISOString()}}];"
      },
      "name": "Code \u2014 Classify Institution & Set Compliance Flags",
      "type": "n8n-nodes-base.code",
      "position": [
        420,
        300
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Institutions!A:Z"
      },
      "name": "Sheets \u2014 Log Institution",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        300
      ]
    },
    {
      "parameters": {
        "subject": "Welcome to {{$json.platform_name}} \u2014 your compliance quick-start guide",
        "message": "=Hi {{$json.contact_name}},\n\nYour institution ({{$json.institution_name}}) is onboarded. Here's what's relevant for you:\n\n{{$json.flags.TITLE_IX_APPLICABLE ? '\u2713 Title IX: Your Title IX Coordinator has the grievance inbox. We log all reports with timestamps for the 20-business-day investigation window (34 CFR \u00a7106.45).' : ''}}\n{{$json.flags.SECTION_508_REQUIRED ? '\u2713 Section 508 / ADA: Our current VPAT is attached. Next conformance review is Q2. Contact accessibility@platform.com for remediation requests.' : ''}}\n{{$json.flags.IDEA_ACCOMMODATION_SCOPE ? '\u2713 IDEA Accommodations: The Accommodation Management module is pre-enabled. IEP/504 accommodation flags propagate to assessment and LMS modules automatically.' : ''}}\n{{$json.flags.FERPA_COVERED ? '\u2713 FERPA: We operate as a School Official under the legitimate educational interest exemption. Your FERPA Annual Notification template is in the admin portal.' : ''}}\n\nYour Customer Success contact: {{$json.csm_name}} at {{$json.csm_email}}\n\nFull compliance documentation: [Knowledge Base Link]\n\nBest,\nThe {{$json.platform_name}} Team"
      },
      "name": "Gmail \u2014 Day 0 Welcome + Compliance Flags",
      "type": "n8n-nodes-base.gmail",
      "position": [
        820,
        200
      ]
    },
    {
      "parameters": {
        "amount": 3,
        "unit": "days"
      },
      "name": "Wait \u2014 3 Days",
      "type": "n8n-nodes-base.wait",
      "position": [
        820,
        400
      ]
    },
    {
      "parameters": {
        "subject": "Quick win: set up your first automated compliance reminder",
        "message": "=Hi {{$json.contact_name}},\n\nDay 3 tip:\n\n{{$json.flags.TITLE_IX_APPLICABLE ? 'Title IX administrators spend ~4h/week on grievance intake and deadline tracking. Our n8n integration can automate the 3-business-day acknowledgement and route complaints to the right coordinator \u2014 zero manual calendar entries.' : 'Your first automation win: set a 30-day re-engagement email for learners who haven't logged in \u2014 takes 10 minutes to configure.'}}\n\nSchedule a 20-min setup call: [Calendly Link]\n\nThe {{$json.platform_name}} Team"
      },
      "name": "Gmail \u2014 Day 3 Quick Win Tip",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1020,
        400
      ]
    }
  ],
  "connections": {
    "Webhook \u2014 New Institution Signup": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify Institution & Set Compliance Flags",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify Institution & Set Compliance Flags": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Log Institution",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Log Institution": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Day 0 Welcome + Compliance Flags",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait \u2014 3 Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait \u2014 3 Days": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Day 3 Quick Win Tip",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

{
  "name": "Title IX Grievance Intake & Deadline Pipeline",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "title9-report",
        "responseMode": "responseNode"
      },
      "name": "Webhook \u2014 Title IX Report Received",
      "type": "n8n-nodes-base.webhook",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const report = $input.first().json;\nconst now = new Date();\nconst reportType = report.report_type || 'UNKNOWN';\n\n// Map report types to routing + deadlines\nconst routing = {\n  FORMAL_COMPLAINT: {\n    coordinator_channel: '#title9-coordinator',\n    ack_days_business: 3,\n    investigation_days_business: 20,\n    severity: 'HIGH',\n    requires_respondent_notice: true\n  },\n  SUPPORTIVE_MEASURE_REQUEST: {\n    coordinator_channel: '#title9-coordinator',\n    ack_days_business: 1,\n    investigation_days_business: 10,\n    severity: 'MEDIUM',\n    requires_respondent_notice: false\n  },\n  RETALIATION_REPORT: {\n    coordinator_channel: '#title9-coordinator',\n    ack_days_business: 1,\n    investigation_days_business: 5,\n    severity: 'HIGH',\n    requires_respondent_notice: true\n  },\n  ANONYMOUS_CONCERN: {\n    coordinator_channel: '#title9-coordinator',\n    ack_days_business: 2,\n    investigation_days_business: 15,\n    severity: 'LOW',\n    requires_respondent_notice: false\n  }\n};\n\nconst config = routing[reportType] || routing['ANONYMOUS_CONCERN'];\n\n// Calculate business day deadlines (approximate \u2014 add 1.4x buffer for weekends)\nconst ackDeadline = new Date(now.getTime() + config.ack_days_business * 1.4 * 24 * 3600 * 1000);\nconst investigationDeadline = new Date(now.getTime() + config.investigation_days_business * 1.4 * 24 * 3600 * 1000);\n\nreturn [{json: {\n  ...report,\n  report_id: 'TIX-' + Date.now(),\n  report_type: reportType,\n  severity: config.severity,\n  coordinator_channel: config.coordinator_channel,\n  requires_respondent_notice: config.requires_respondent_notice,\n  ack_deadline_iso: ackDeadline.toISOString(),\n  investigation_deadline_iso: investigationDeadline.toISOString(),\n  received_at: now.toISOString(),\n  regulatory_citation: '34 CFR \u00a7106.45'\n}}];"
      },
      "name": "Code \u2014 Classify + Deadline Calc",
      "type": "n8n-nodes-base.code",
      "position": [
        420,
        300
      ]
    },
    {
      "parameters": {
        "channel": "={{ $json.coordinator_channel }}",
        "text": "=:warning: *Title IX Report* \u2014 {{ $json.severity }}\nID: {{ $json.report_id }}\nType: {{ $json.report_type }}\nInstitution: {{ $json.institution_name }}\nReceived: {{ $json.received_at }}\nAck due (3 biz days): {{ $json.ack_deadline_iso }}\nInvestigation due (20 biz days): {{ $json.investigation_deadline_iso }}\nRegulatory citation: {{ $json.regulatory_citation }}"
      },
      "name": "Slack \u2014 Alert Title IX Coordinator",
      "type": "n8n-nodes-base.slack",
      "position": [
        620,
        200
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "YOUR_SHEET_ID",
        "range": "TitleIX_Log!A:Z"
      },
      "name": "Sheets \u2014 Postgres Audit Log",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        400
      ]
    },
    {
      "parameters": {
        "subject": "=Title IX Report Received \u2014 {{ $json.report_id }} (Acknowledgement Required by {{ $json.ack_deadline_iso }})",
        "message": "=Dear Title IX Coordinator,\n\nA new report has been received:\n\nReport ID: {{ $json.report_id }}\nType: {{ $json.report_type }}\nSeverity: {{ $json.severity }}\nInstitution: {{ $json.institution_name }}\nReceived at: {{ $json.received_at }}\n\nDeadlines (34 CFR \u00a7106.45):\n- Written acknowledgement required by: {{ $json.ack_deadline_iso }} (3 business days)\n- Investigation completion target: {{ $json.investigation_deadline_iso }} (20 business days)\n- Respondent notice required: {{ $json.requires_respondent_notice }}\n\nAction required: Send written acknowledgement to complainant within 3 business days.\n\nThis message was generated automatically by your n8n compliance pipeline."
      },
      "name": "Gmail \u2014 Coordinator Deadline Summary",
      "type": "n8n-nodes-base.gmail",
      "position": [
        820,
        300
      ]
    }
  ],
  "connections": {
    "Webhook \u2014 Title IX Report Received": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify + Deadline Calc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify + Deadline Calc": {
      "main": [
        [
          {
            "node": "Slack \u2014 Alert Title IX Coordinator",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sheets \u2014 Postgres Audit Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Postgres Audit Log": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Coordinator Deadline Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

{
  "name": "ADA Section 508 & WCAG Compliance Deadline Tracker",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * 1-5"
            }
          ]
        }
      },
      "name": "Schedule \u2014 Weekdays 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "operation": "read",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Accessibility_Deadlines!A:G"
      },
      "name": "Sheets \u2014 Read Accessibility Deadlines",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const items = $input.all();\nconst now = new Date();\nconst alerts = [];\n\nfor (const item of items) {\n  const d = item.json;\n  if (!d.deadline_date || d.status === 'COMPLETE') continue;\n\n  const deadline = new Date(d.deadline_date);\n  const daysLeft = Math.ceil((deadline - now) / (1000 * 60 * 60 * 24));\n\n  let urgency = null;\n  if (daysLeft < 0) urgency = 'OVERDUE';\n  else if (daysLeft <= 14) urgency = 'CRITICAL';\n  else if (daysLeft <= 30) urgency = 'URGENT';\n  else if (daysLeft <= 60) urgency = 'WARNING';\n  else if (daysLeft <= 90) urgency = 'NOTICE';\n\n  if (!urgency) continue;\n\n  // Map deadline type to regulatory citation\n  const citations = {\n    WCAG_21_AA_AUDIT_ANNUAL: 'WCAG 2.1 AA \u2014 EN 301 549 / ADA Title II',\n    VPAT_RENEWAL: 'Section 508 \u00a71194 \u2014 VPAT must reflect current product state',\n    SECTION_508_CONFORMANCE_REVIEW: '29 U.S.C. \u00a7794d \u2014 EIT accessibility for federal grantees',\n    ADA_TITLE_II_SELF_EVAL_TRIENNIAL: 'ADA Title II \u2014 28 CFR \u00a735.105 self-evaluation (3yr)',\n    TITLE_IX_POLICY_ANNUAL_REVIEW: '34 CFR \u00a7106.8(b) \u2014 Annual grievance procedure review',\n    IDEA_ACCOMMODATION_AUDIT: '20 U.S.C. \u00a71412(a)(5) \u2014 FAPE/LRE accommodation review',\n    FERPA_ANNUAL_NOTIFICATION: '34 CFR \u00a799.7 \u2014 Annual FERPA rights notice to eligible students',\n    COPPA_CONSENT_MECHANISM_REVIEW: '15 U.S.C. \u00a76501 \u2014 Verifiable parental consent mechanism',\n    SOC2_TYPE2_RENEWAL: 'SOC 2 Type II \u2014 annual audit cycle',\n    GDPR_ART28_DPA_RENEWAL: 'GDPR Art.28 \u2014 DPA renewal for EU institution customers',\n    CCPA_PRIVACY_NOTICE_UPDATE: 'Cal. Civ. Code \u00a71798.100 \u2014 annual privacy notice review',\n    STATE_STUDENT_DATA_LAW_REVIEW: 'State student data privacy law compliance (SOPIPA/SDPC)'\n  };\n\n  alerts.push({\n    ...d,\n    days_left: daysLeft,\n    urgency,\n    regulatory_citation: citations[d.deadline_type] || 'Review regulatory requirements'\n  });\n}\n\n// Sort by urgency\nconst urgencyOrder = {OVERDUE: 0, CRITICAL: 1, URGENT: 2, WARNING: 3, NOTICE: 4};\nalerts.sort((a, b) => urgencyOrder[a.urgency] - urgencyOrder[b.urgency]);\n\nreturn alerts.map(a => ({json: a}));"
      },
      "name": "Code \u2014 Classify Urgency & Citations",
      "type": "n8n-nodes-base.code",
      "position": [
        620,
        300
      ]
    },
    {
      "parameters": {
        "channel": "#accessibility-compliance",
        "text": "=:accessibility: *{{ $json.urgency }}* \u2014 {{ $json.deadline_type }} ({{ $json.days_left }} days)\nCitation: {{ $json.regulatory_citation }}\nOwner: {{ $json.owner }}\nDeadline: {{ $json.deadline_date }}"
      },
      "name": "Slack \u2014 Accessibility Team Alert",
      "type": "n8n-nodes-base.slack",
      "position": [
        820,
        200
      ]
    },
    {
      "parameters": {
        "subject": "=[{{ $json.urgency }}] {{ $json.deadline_type }} \u2014 {{ $json.days_left }} days remaining",
        "message": "=Hi {{ $json.owner }},\n\nAccessibility compliance deadline approaching:\n\nDeadline Type: {{ $json.deadline_type }}\nStatus: {{ $json.urgency }} ({{ $json.days_left }} days remaining)\nDeadline Date: {{ $json.deadline_date }}\nRegulatory Citation: {{ $json.regulatory_citation }}\n\nAction: {{ $json.action_required }}\n\nThis reminder was sent automatically by your compliance pipeline."
      },
      "name": "Gmail \u2014 Owner Deadline Reminder",
      "type": "n8n-nodes-base.gmail",
      "position": [
        820,
        400
      ]
    }
  ],
  "connections": {
    "Schedule \u2014 Weekdays 8AM": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Read Accessibility Deadlines",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Read Accessibility Deadlines": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify Urgency & Citations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify Urgency & Citations": {
      "main": [
        [
          {
            "node": "Slack \u2014 Accessibility Team Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Gmail \u2014 Owner Deadline Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

{
  "name": "IDEA Accommodation Gap Detection Pipeline",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "accommodation-request",
        "responseMode": "responseNode"
      },
      "name": "Webhook \u2014 Accommodation Request",
      "type": "n8n-nodes-base.webhook",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const req = $input.first().json;\nconst accommodationType = req.accommodation_type;\n\n// Check if platform currently supports this accommodation\nconst platformSupport = {\n  EXTENDED_TIME: { supported: true, module: 'Assessment Engine \u2014 Time Multiplier setting' },\n  SCREEN_READER_COMPATIBLE: { supported: true, module: 'WCAG 2.1 AA compliant UI + ARIA labels' },\n  AUDIO_DESCRIPTION: { supported: false, module: null },  // GAP \u2014 flag for product\n  LARGE_PRINT_UI: { supported: true, module: 'Font scaling + high contrast mode' },\n  ALTERNATIVE_FORMAT_EXPORT: { supported: false, module: null },  // GAP\n  BRAILLE_READY_OUTPUT: { supported: false, module: null },  // GAP\n  REDUCED_DISTRACTION_MODE: { supported: true, module: 'Focus Mode feature' },\n  HUMAN_READER: { supported: false, module: null },  // GAP \u2014 requires integration\n  SCRIBE_SUPPORT: { supported: false, module: null },  // GAP\n  SPEECH_TO_TEXT: { supported: true, module: 'Browser native + Google Voice API integration' },\n  CALCULATOR_PERMITTED: { supported: true, module: 'Assessment settings \u2014 calculator toggle' },\n  DICTIONARY_PERMITTED: { supported: true, module: 'Assessment settings \u2014 dictionary toggle' }\n};\n\nconst support = platformSupport[accommodationType] || { supported: false, module: 'Unknown accommodation type' };\nconst regulatory = req.plan_type === 'IEP' ? 'IDEA 20 U.S.C. \u00a71412(a)(5) \u2014 FAPE/LRE obligation' : 'Section 504 \u2014 29 U.S.C. \u00a7794';\n\nreturn [{json: {\n  ...req,\n  accommodation_supported: support.supported,\n  support_module: support.module,\n  regulatory_citation: regulatory,\n  gap_severity: !support.supported ? 'PRODUCT_GAP' : 'OK',\n  escalate_to_product: !support.supported,\n  flagged_at: new Date().toISOString()\n}}];"
      },
      "name": "Code \u2014 Check Platform Support + Classify",
      "type": "n8n-nodes-base.code",
      "position": [
        420,
        300
      ]
    },
    {
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{ $json.gap_severity }}",
              "operation": "equal",
              "value2": "PRODUCT_GAP"
            }
          ]
        }
      },
      "name": "IF \u2014 Platform Gap?",
      "type": "n8n-nodes-base.if",
      "position": [
        620,
        300
      ]
    },
    {
      "parameters": {
        "channel": "#product-accessibility-gaps",
        "text": "=:red_circle: *IDEA Accommodation Gap* \u2014 {{ $json.accommodation_type }}\nPlan type: {{ $json.plan_type }} ({{ $json.regulatory_citation }})\nInstitution: {{ $json.institution_name }}\nStudent ID: {{ $json.student_id }} (anonymized in non-compliant log)\nGap: Platform does NOT support {{ $json.accommodation_type }}\nThis may constitute a FAPE/LRE violation for the district. Product team action required."
      },
      "name": "Slack \u2014 #product-accessibility-gaps (URGENT)",
      "type": "n8n-nodes-base.slack",
      "position": [
        820,
        200
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Accommodation_Gaps!A:Z"
      },
      "name": "Sheets \u2014 Log Gap for Product Backlog",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        300
      ]
    },
    {
      "parameters": {
        "subject": "=[PRODUCT GAP] IDEA Accommodation Not Supported: {{ $json.accommodation_type }}",
        "message": "=Hi Product Team,\n\nAn accommodation request was submitted that our platform does NOT currently support:\n\nAccommodation Type: {{ $json.accommodation_type }}\nPlan Type: {{ $json.plan_type }}\nRegulatory Citation: {{ $json.regulatory_citation }}\nInstitution: {{ $json.institution_name }}\nFlagged At: {{ $json.flagged_at }}\n\nThis represents a potential FAPE/LRE compliance gap under IDEA. The institution may be unable to fulfill their IEP obligations using our platform for this accommodation type.\n\nRecommendation: Add {{ $json.accommodation_type }} support to the product backlog with HIGH priority.\n\nThis alert was sent automatically by your n8n compliance pipeline."
      },
      "name": "Gmail \u2014 Product Team + Head of Product",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1020,
        200
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Accommodations_Fulfilled!A:Z"
      },
      "name": "Sheets \u2014 Log Fulfilled Accommodation",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        450
      ]
    }
  ],
  "connections": {
    "Webhook \u2014 Accommodation Request": {
      "main": [
        [
          {
            "node": "Code \u2014 Check Platform Support + Classify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Check Platform Support + Classify": {
      "main": [
        [
          {
            "node": "IF \u2014 Platform Gap?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "IF \u2014 Platform Gap?": {
      "main": [
        [
          {
            "node": "Slack \u2014 #product-accessibility-gaps (URGENT)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sheets \u2014 Log Gap for Product Backlog",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets \u2014 Log Fulfilled Accommodation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Log Gap for Product Backlog": {
      "main": [
        [
          {
            "node": "Gmail \u2014 Product Team + Head of Product",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

{
  "name": "FERPA Disclosure Request Audit Pipeline",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "ferpa-disclosure",
        "responseMode": "responseNode"
      },
      "name": "Webhook \u2014 Disclosure Request",
      "type": "n8n-nodes-base.webhook",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const req = $input.first().json;\nconst disclosureType = req.disclosure_type;\n\n// FERPA disclosure type routing (34 CFR \u00a799)\nconst routing = {\n  SCHOOL_OFFICIAL_LEGITIMATE_INTEREST: {\n    auto_approve: true,\n    citation: '34 CFR \u00a799.31(a)(1) \u2014 School official with legitimate educational interest',\n    requires_consent: false,\n    log_required: true\n  },\n  JUDICIAL_ORDER_SUBPOENA: {\n    auto_approve: false,\n    citation: '34 CFR \u00a799.31(a)(9) \u2014 Judicial order or lawfully issued subpoena',\n    requires_consent: false,\n    requires_legal_review: true,\n    notify_student: true,\n    log_required: true\n  },\n  HEALTH_SAFETY_EMERGENCY: {\n    auto_approve: false,\n    citation: '34 CFR \u00a799.36 \u2014 Health or safety emergency exception',\n    requires_consent: false,\n    requires_admin_approval: true,\n    log_required: true\n  },\n  DIRECTORY_INFORMATION: {\n    auto_approve: false,\n    citation: '34 CFR \u00a799.37 \u2014 Directory information (check opt-out register)',\n    requires_opt_out_check: true,\n    log_required: true\n  },\n  WRITTEN_CONSENT: {\n    auto_approve: true,\n    citation: '34 CFR \u00a799.30 \u2014 Student or parent written consent',\n    requires_consent_verification: true,\n    log_required: true\n  },\n  AUDIT_EVALUATION: {\n    auto_approve: true,\n    citation: '34 CFR \u00a799.31(a)(3) \u2014 Federal/state audit and evaluation',\n    requires_consent: false,\n    log_required: true\n  },\n  RESEARCH_DE_IDENTIFIED: {\n    auto_approve: false,\n    citation: '34 CFR \u00a799.31(a)(6) \u2014 Research under strict conditions',\n    requires_irb_approval: true,\n    log_required: true\n  }\n};\n\nconst config = routing[disclosureType] || {\n  auto_approve: false,\n  citation: 'Unknown disclosure type \u2014 requires manual FERPA review',\n  requires_legal_review: true,\n  log_required: true\n};\n\nreturn [{json: {\n  ...req,\n  disclosure_id: 'FERPA-' + Date.now(),\n  routing: config,\n  status: config.auto_approve ? 'APPROVED' : 'PENDING_REVIEW',\n  logged_at: new Date().toISOString()\n}}];"
      },
      "name": "Code \u2014 Classify Disclosure Type & Routing",
      "type": "n8n-nodes-base.code",
      "position": [
        420,
        300
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "sheetId": "YOUR_SHEET_ID",
        "range": "FERPA_Audit_Log!A:Z"
      },
      "name": "Sheets \u2014 FERPA Audit Log (immutable)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        300
      ]
    },
    {
      "parameters": {
        "channel": "#ferpa-compliance",
        "text": "=:lock: *FERPA Disclosure* \u2014 {{ $json.disclosure_id }}\nType: {{ $json.disclosure_type }}\nStatus: {{ $json.status }}\nCitation: {{ $json.routing.citation }}\nRequestor: {{ $json.requestor_name }} ({{ $json.requestor_org }})\nInstitution: {{ $json.institution_name }}\nLogged: {{ $json.logged_at }}"
      },
      "name": "Slack \u2014 #ferpa-compliance Log",
      "type": "n8n-nodes-base.slack",
      "position": [
        820,
        300
      ]
    }
  ],
  "connections": {
    "Webhook \u2014 Disclosure Request": {
      "main": [
        [
          {
            "node": "Code \u2014 Classify Disclosure Type & Routing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Classify Disclosure Type & Routing": {
      "main": [
        [
          {
            "node": "Sheets \u2014 FERPA Audit Log (immutable)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 FERPA Audit Log (immutable)": {
      "main": [
        [
          {
            "node": "Slack \u2014 #ferpa-compliance Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

{
  "name": "Weekly EdTech Compliance & Platform KPI Dashboard",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * 1"
            }
          ]
        }
      },
      "name": "Schedule \u2014 Monday 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "operation": "read",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Platform_Metrics!A:Z"
      },
      "name": "Sheets \u2014 Platform Metrics",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        200
      ]
    },
    {
      "parameters": {
        "operation": "read",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Compliance_Events!A:Z"
      },
      "name": "Sheets \u2014 Compliance Events",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        400
      ]
    },
    {
      "parameters": {
        "mode": "combine",
        "combinationMode": "mergeByPosition"
      },
      "name": "Merge \u2014 Platform + Compliance",
      "type": "n8n-nodes-base.merge",
      "position": [
        620,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const data = $input.first().json;\nconst prev = $getWorkflowStaticData('global');\n\nconst m = {\n  active_institutions: data.active_institutions || 0,\n  daily_learners_avg: data.daily_learners_avg || 0,\n  api_uptime_pct: data.api_uptime_pct || 0,\n  accommodation_requests_week: data.accommodation_requests_week || 0,\n  accommodation_gaps_open: data.accommodation_gaps_open || 0,\n  title9_cases_open: data.title9_cases_open || 0,\n  ferpa_disclosures_week: data.ferpa_disclosures_week || 0,\n  accessibility_overdue: data.accessibility_overdue || 0,\n  new_institutions_week: data.new_institutions_week || 0,\n  mrr_usd: data.mrr_usd || 0\n};\n\nfunction wowPct(curr, prevVal) {\n  if (!prevVal) return 'N/A';\n  return ((curr - prevVal) / prevVal * 100).toFixed(1) + '%';\n}\n\nconst html = `\n<h2>Weekly EdTech Platform Report \u2014 ${new Date().toISOString().slice(0,10)}</h2>\n<table border=\"1\" cellpadding=\"6\" style=\"border-collapse:collapse;font-family:Arial,sans-serif\">\n<tr style=\"background:#1a1a2e;color:#e2e8f0\"><th>Metric</th><th>This Week</th><th>WoW</th></tr>\n<tr><td>Active Institutions</td><td>${m.active_institutions}</td><td>${wowPct(m.active_institutions, prev.active_institutions)}</td></tr>\n<tr><td>Daily Learners (avg)</td><td>${m.daily_learners_avg.toLocaleString()}</td><td>${wowPct(m.daily_learners_avg, prev.daily_learners_avg)}</td></tr>\n<tr><td>API Uptime</td><td style=\"color:${m.api_uptime_pct >= 99.9 ? '#22c55e' : '#ef4444'}\">${m.api_uptime_pct}%</td><td>\u2014</td></tr>\n<tr><td>MRR</td><td>$${m.mrr_usd.toLocaleString()}</td><td>${wowPct(m.mrr_usd, prev.mrr_usd)}</td></tr>\n<tr><td>New Institutions</td><td>${m.new_institutions_week}</td><td>\u2014</td></tr>\n<tr style=\"background:#fff7ed\"><td>Title IX Open Cases</td><td style=\"color:${m.title9_cases_open > 0 ? '#ef4444' : '#22c55e'}\">${m.title9_cases_open}</td><td>\u2014</td></tr>\n<tr style=\"background:#fff7ed\"><td>Accommodation Gaps (open)</td><td style=\"color:${m.accommodation_gaps_open > 0 ? '#ef4444' : '#22c55e'}\">${m.accommodation_gaps_open}</td><td>\u2014</td></tr>\n<tr style=\"background:#fff7ed\"><td>Accessibility Deadlines Overdue</td><td style=\"color:${m.accessibility_overdue > 0 ? '#ef4444' : '#22c55e'}\">${m.accessibility_overdue}</td><td>\u2014</td></tr>\n<tr><td>FERPA Disclosures (week)</td><td>${m.ferpa_disclosures_week}</td><td>\u2014</td></tr>\n</table>\n<p style=\"color:#94a3b8;font-size:12px\">Generated by n8n \u2014 Self-hosted. Student data stays in your VPC.</p>\n`;\n\n// Save for next week's WoW comparison\n$setWorkflowStaticData('global', m);\n\nreturn [{json: {html_body: html, metrics: m}}];"
      },
      "name": "Code \u2014 Build KPI Dashboard",
      "type": "n8n-nodes-base.code",
      "position": [
        820,
        300
      ]
    },
    {
      "parameters": {
        "subject": "=Weekly EdTech Platform Report \u2014 {{ $now.format('YYYY-MM-DD') }}",
        "message": "={{ $json.html_body }}",
        "options": {
          "emailType": "html"
        },
        "toList": "ceo@yourcompany.com",
        "ccList": "cpo@yourcompany.com",
        "bccList": "compliance@yourcompany.com"
      },
      "name": "Gmail \u2014 CEO + CPO BCC Compliance",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1020,
        300
      ]
    }
  ],
  "connections": {
    "Schedule \u2014 Monday 8AM": {
      "main": [
        [
          {
            "node": "Sheets \u2014 Platform Metrics",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sheets \u2014 Compliance Events",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Platform Metrics": {
      "main": [
        [
          {
            "node": "Merge \u2014 Platform + Compliance",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets \u2014 Compliance Events": {
      "main": [
        [
          {
            "node": "Merge \u2014 Platform + Compliance",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge \u2014 Platform + Compliance": {
      "main": [
        [
          {
            "node": "Code \u2014 Build KPI Dashboard",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code \u2014 Build KPI Dashboard": {
      "main": [
        [
          {
            "node": "Gmail \u2014 CEO + CPO BCC Compliance",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}