Automated weekly security audit reports with Gmail delivery

🔒 N8N Security Audit Report - Automated Weekly Email 🎯 What does this workflow do? This workflow automatically generates and emails a comprehensive security audit report for your N8N instance every week. It identifies potential security risks related to: - Credentials 🔑 : Exposed or insecure credentials - Nodes 🧩 : Sensitive nodes (Code, HTTP Request, SSH, FTP, etc.) - Instance settings 🏢 : Global security configuration - Community nodes 📦 : Third-party nodes that may pose risks The report includes direct links to affected workflows, execution statuses, and actionable recommendations. --- ✨ Key Features 📊 Smart Risk Assessment - Calculates overall risk level: 🟩 Low / 🟧 Moderate / 🟥 High - Tracks unique credentials (not just total occurrences) - Provides detailed breakdown by node type 🔗 Direct Workflow Links - Clickable links to each workflow mentioned - Shows last execution status (🟢 success / 🔴 failed) - Displays execution timestamps 🌍 Bilingual Support - Full support for French and English - Switch language with a single variable 📧 Beautiful HTML Email - Clean, professional formatting - Color-coded risk levels - Emoji icons for easy scanning --- 🚀 Quick Setup (5 minutes) 1️⃣ Configure Credentials - N8N API: Generate an API key in your N8N settings - Gmail OAuth2: Set up OAuth2 for Gmail sending 2️⃣ Set Your Variables Edit the "Set Config Variables" node: javascript { "emailto": "[email protected]", "projectname": "My-N8N-Project", "serverurl": "https://n8n.yourdomain.com", // NO trailing slash! "Language": "EN" // or "FR" } 3️⃣ Test & Activate - Click "Execute Workflow" to test - Check your email inbox - Activate for weekly automation --- 📧 Example Report Output Subject: 🔒 Audit Report My-Project – Risk 🟧 Moderate Content: 📊 Summary • Credentials involved: 8 (5 unique) • Nodes involved: 12 - 💻 code: 4 - 🌐 httpRequest: 3 - 🔐 ssh: 2 • Community nodes: 1 • Overall risk level: 🟧 Moderate 🔐 Credentials Risk Report 🔹 Credentials with full access - 🔑 My AWS Credentials - 🔑 Database Admin 📋 Workflow: Data Processing Pipeline 🟢 (25-10-2024 06:15 → 06:16) - 💻 Process Data - 🌐 API Call 🧩 Nodes Risk Report ...detailed node analysis... --- 🎨 Customization Options Change Schedule Modify the "Schedule Trigger" node to run: - Daily at 8 AM - Monthly on the 1st - Custom cron expression Add Recipients Add multiple emails in the Gmail node's toList parameter Adjust Risk Thresholds Edit the JavaScript in "Format Audit Report" nodes to customize when risk levels change Use Different Email Service Replace Gmail node with: - SMTP - Microsoft Outlook - SendGrid - Any email service N8N supports --- 💡 Use Cases ✅ Compliance Monitoring: Track security posture for audits ✅ Team Awareness: Keep your team informed of security status ✅ Change Detection: Notice when new risky nodes are added ✅ Best Practices: Get recommendations to improve security ✅ Multi-Environment: Run separate instances for dev/staging/prod --- 🔧 Technical Details Nodes Used: 8 Credentials Required: 2 (N8N API + Gmail OAuth2) External Dependencies: None N8N Version: Compatible with latest N8N versions Execution Time: ~10-20 seconds --- 📋 Requirements - N8N instance with API access - Gmail account (or other email service) - N8N API key with audit permissions - Valid SSL certificate for workflow links (recommended) --- 🐛 Troubleshooting Empty report? → Check your N8N API key has audit permissions Workflow links don't work? → Verify serverurl is correct and has no trailing slash No execution status shown? → Workflows must have been executed at least once Wrong language displayed? → Set Language to exactly "FR" or "EN" (uppercase) --- 🌟 Why This Template? Unlike basic monitoring tools, this workflow: - ✅ Provides context-aware security analysis - ✅ Links directly to affected workflows - ✅ Shows real execution data (not just theoretical risks) - ✅ Calculates unique credential exposure (not just counts) - ✅ Supports bilingual reports - ✅ Delivers