Automate Zabbix Health Reports: n8n Workflow with Gemini & Email

Automate Your Zabbix Health Reporting with the Power of n8n, Gemini, and Email

Streamline your Zabbix monitoring processes effortlessly! This specialized n8n workflow automatically generates comprehensive health reports by querying your Zabbix PostgreSQL database, structuring insights with Google Gemini, and delivering detailed KPI-rich reports straight to your inbox. Perfect for IT professionals eager to optimize their monitoring routines, this workflow leaves no stone unturned in maintaining your systems’ health.

What This Workflow Does

• Cron Scheduling: Initiates every weekday at 07:00, ensuring up-to-date monitoring.
• Data Extraction: Queries your Zabbix PostgreSQL database to pull vital host availability and inventory status.
• Alert Aggregation: Retrieves and consolidates active high-priority alerts (WARNING and above).
• Performance Trends: Gathers CPU, memory, and disk utilization trends from the past 7–14 days.
• Data Processing: Integrates these inputs into a consolidated JSON payload with a specific focus on top CPU, low-memory, and high-disk-usage candidates.
• AI-Enhanced Assessment: Utilizes Google Gemini to transform raw data into a structured health assessment with a strict JSON response.
• Report Generation: Converts health insights into a formatted HTML email, automatically dispatched to designated recipients through SMTP.

Use Cases

• IT Management: Automate the generation of daily system health reports, facilitating proactive IT management.
• SaaS Operations: Maintain optimal service levels by keeping a close eye on key performance metrics.
• Automation Engineers: Leverage Google Gemini’s AI capabilities for deeper analytical insights into system health.

Technical Details

• Nodes Used: Set, Code, Merge, PostgreSQL, Email Send, Sticky Note.
• Integrations: Google Gemini (PaLM) API, PostgreSQL Database, SMTP Email Services.
• Prerequisites: PostgreSQL credential for Zabbix, Google Gemini API credential, SMTP credential configuration.