{"product_id":"automate-zabbix-health-reports-n8n-workflow-with-gemini-email","title":"Automate Zabbix Health Reports: n8n Workflow with Gemini \u0026 Email","description":"\u003ch3\u003eAutomate Your Zabbix Health Reporting with the Power of n8n, Gemini, and Email\u003c\/h3\u003e\n\u003cp\u003eStreamline 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat This Workflow Does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCron Scheduling:\u003c\/strong\u003e Initiates every weekday at 07:00, ensuring up-to-date monitoring.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Extraction:\u003c\/strong\u003e Queries your Zabbix PostgreSQL database to pull vital host availability and inventory status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlert Aggregation:\u003c\/strong\u003e Retrieves and consolidates active high-priority alerts (WARNING and above).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePerformance Trends:\u003c\/strong\u003e Gathers CPU, memory, and disk utilization trends from the past 7–14 days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData Processing:\u003c\/strong\u003e Integrates these inputs into a consolidated JSON payload with a specific focus on top CPU, low-memory, and high-disk-usage candidates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI-Enhanced Assessment:\u003c\/strong\u003e Utilizes Google Gemini to transform raw data into a structured health assessment with a strict JSON response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReport Generation:\u003c\/strong\u003e Converts health insights into a formatted HTML email, automatically dispatched to designated recipients through SMTP.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse Cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIT Management:\u003c\/strong\u003e Automate the generation of daily system health reports, facilitating proactive IT management.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS Operations:\u003c\/strong\u003e Maintain optimal service levels by keeping a close eye on key performance metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation Engineers:\u003c\/strong\u003e Leverage Google Gemini’s AI capabilities for deeper analytical insights into system health.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical Details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes Used:\u003c\/strong\u003e Set, Code, Merge, PostgreSQL, Email Send, Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Gemini (PaLM) API, PostgreSQL Database, SMTP Email Services.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrerequisites:\u003c\/strong\u003e PostgreSQL credential for Zabbix, Google Gemini API credential, SMTP credential configuration.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45612539281587,"sku":"N8N-16208","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1Pnof7jZ6EyD2gL5F4SIU_c6095198210a4740a6aea4f477a09e24.jpg?v=1782724101","url":"https:\/\/buyflowscripts.com\/products\/automate-zabbix-health-reports-n8n-workflow-with-gemini-email","provider":"N8N Commerce","version":"1.0","type":"link"}