{"product_id":"daily-security-log-briefing-with-openai-whatsapp-email","title":"Daily Security Log Briefing with OpenAI + WhatsApp \u0026 Email","description":"\u003ch3\u003eGet a daily security risk briefing—automatically—sent to you on WhatsApp and by email\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls the last 24 hours of security logs from your SIEM\/log aggregator, uses OpenAI to generate a clear executive risk briefing, and delivers a short WhatsApp summary plus a detailed HTML email report. If an escalation is needed, it pauses for a security lead acknowledgment before continuing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules daily runs\u003c\/strong\u003e (or supports manual testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries your SIEM\/log aggregator API\u003c\/strong\u003e for events from the configured systems covering the \u003cstrong\u003eprevious 24 hours\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e mixed log formats, categorizes events, scores severity, collapses near-duplicates, and keeps only the most notable items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI\u003c\/strong\u003e to produce a \u003cstrong\u003eJSON briefing\u003c\/strong\u003e including an executive summary, findings, recommended actions, overall risk level, and an \u003cem\u003eescalationRequired\u003c\/em\u003e flag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates two outputs\u003c\/strong\u003e: a concise \u003cstrong\u003eWhatsApp\u003c\/strong\u003e message and a detailed \u003cstrong\u003eHTML email\u003c\/strong\u003e report (with category and top-IP breakdowns).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalation gating\u003c\/strong\u003e: when \u003cem\u003eescalationRequired\u003c\/em\u003e is true, it \u003cstrong\u003ewaits for security lead acknowledgment\u003c\/strong\u003e before sending\/continuing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends\u003c\/strong\u003e the briefing via \u003cstrong\u003eWhatsApp Business Cloud API\u003c\/strong\u003e (WhatsApp) and \u003cstrong\u003eSMTP\u003c\/strong\u003e (email).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS security teams who want an automated \u003cstrong\u003edaily security log briefing\u003c\/strong\u003e without manual triage.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n-based \u003cstrong\u003eSIEM-to-alert\u003c\/strong\u003e reporting flow with OpenAI summarization.\u003c\/li\u003e\n  \u003cli\u003eOperators who need escalation control to ensure high-risk events get acknowledged before action.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic\u003c\/strong\u003e: if, set, code, wait, WhatsApp, email send\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSIEM\/log aggregator integration\u003c\/strong\u003e: HTTP Header Auth; configure \u003cem\u003elogAggregatorApiUrl\u003c\/em\u003e and query parameters for your platform\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration\u003c\/strong\u003e: Chat Model to generate the JSON briefing and the escalationRequired flag\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\u003c\/strong\u003e: WhatsApp Business Cloud API (phone number ID + recipient phone number)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery\u003c\/strong\u003e: SMTP with a detailed \u003cstrong\u003eHTML\u003c\/strong\u003e report\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869879525555,"sku":"N8N-18451","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AMvhSAmg_PHdmDpLZjfcq_YUFplFwI.png?v=1787130160","url":"https:\/\/buyflowscripts.com\/products\/daily-security-log-briefing-with-openai-whatsapp-email","provider":"N8N Commerce","version":"1.0","type":"link"}