Real-Time Security Threat Dashboard with AI Analysis & Alerts

This n8n workflow creates a real-time security threat dashboard by pulling data from up to 5 Google Sheets populated by BlueOps modules (M1-M5). It aggregates key slices including summary metrics (total threats, actions, endpoints), daily trends, top high-risk assets, and incident response actions. AI-powered risk analysis enhances threat prioritization, providing actionable insights without a full SIEM.

Benefits include automated visibility for Blue Team leads, CISOs, and SOC managers, saving hours on manual reporting. It generates professional HTML reports with charts (customizable via ChartJS or QuickChart), emails them to stakeholders, and logs summaries to a central tracker sheet. Optional PDF conversion stores archives for compliance.

Ideal use cases: Weekly/monthly security briefings, endpoint monitoring dashboards, IR activity reviews. Customize for Supabase/Notion data sources, add Slack/Airtable exports, or integrate BI tools. Modular design ensures scalability for growing security operations.