Luis Hernandez
I like solving problems and have a true passion for no-code automation. I'm thoughtful by nature and enjoy finding ways to optimize processes, always guided by my principles and values.
Templates by Luis Hernandez
User-friendly technical support portal for GLPI ticket management
Custom Interface for GLPI with n8n Transform your GLPI system's user experience with a modern, optimized web interface that simplifies technical support ticket creation. How it works Unified entry portal: Users access an intuitive web form where they select between "Request" or "Incident" Custom data collection: Specific forms adapt fields based on ticket type, requesting only relevant information Automatic processing: The system automatically maps categories and priorities, creates tickets in GLPI via REST API File management: Allows document attachments that are automatically linked to the created ticket Confirmation and tracking: Provides the generated ticket ID for future follow-up Key benefits ✅ More user-friendly interface than native GLPI interface ✅ Adaptive forms based on request type ✅ Error reduction through automatic validations ✅ Mobile-optimized user experience ✅ Seamless integration with existing GLPI Setup steps ⏱️ Estimated time: 15-20 minutes Prerequisites GLPI server with REST API enabled User with application administrator privileges Application token generated in GLPI Basic configuration Connection variables: Update GLPI server URL and application token in the "Configuration Variables" node Authentication credentials: Configure HTTP Basic Auth credentials for GLPI connection Category IDs: Identify and map ITIL category IDs in the processing nodes Form customization: Adapt fields, options, and categories according to organizational needs Activation Activate the workflow and obtain web form URLs Share the portal link with end users Perform ticket creation tests Ideal use cases Companies looking to improve GLPI user experience Organizations needing more intuitive support forms IT teams wanting to reduce miscategorized tickets Companies requiring mobile-friendly support interfaces Technologies used n8n (orchestration and web forms) GLPI REST API HTTP Basic Authentication Automatic session management
By Luis HernandezAutomated GLPI ticket deadline alerts via Microsoft Teams
Overview This n8n workflow provides an automated notification system that monitors tickets in GLPI (Gestionnaire Libre de Parc Informatique) and sends proactive alerts through Microsoft Teams when tickets are approaching their expiration dates. Key Features 🕘 Automated Scheduling Daily execution scheduled at 9:00 AM Continuous monitoring without manual intervention Customizable scheduling configuration 🎯 Intelligent Deadline Detection Automatic identification of tickets expiring within the next 2 days Configurable date-based filtering criteria Efficient processing of multiple simultaneous tickets 👥 Targeted Notifications Personalized alerts sent to specific technicians via Microsoft Teams Automatic assignment based on ticket assignee Structured messages with key ticket information 🔧 Complete GLPI Integration Secure connection through GLPI REST API Authentication with application tokens Automatic session management (initiation and closure) Technical Functionalities Data Processing Extraction: Automatic queries to GLPI database Filtering: Ticket separation by assigned technician Transformation: Data formatting for readable notifications Conditional Flow Automatic evaluation of responsible technician Intelligent notification routing Handling of cases without specific assignment Session Management Automatic session initiation with GLPI Secure session token maintenance Controlled session closure upon completion Ticket Information Included Each alert contains: Ticket Title: Clear problem description Ticket ID: Unique identifier for tracking Time Remaining: Days/hours until expiration System Requirements Infrastructure GLPI server with REST API enabled Running n8n instance Microsoft Teams account with API permissions Required Credentials GLPI user with application administrator privileges Valid GLPI application token OAuth2 credentials for Microsoft Teams GLPI User ID Identification For complete workflow configuration, it's necessary to identify the correct IDs of technical users for proper notification assignment. User IDs can be obtained by accessing user management in GLPI and observing the ID directly in the browser URL when selecting a specific user. Path: Administration > Users > [Select User] When clicking on the desired user, you can see the user ID directly in the browser URL (e.g., id=7 for Support Technician 1, id=8 for Support Technician 2). Configuration Environment Variables json{ "glpi_url": "https://your-glpi-server.com", "app_token": "your-application-token-here" } Available Customization Alert Period: Modifiable from 2 days to any desired range Execution Schedule: Configurable according to operational needs Recipients: Adaptable to specific team structure Operational Benefits For Support Teams Reduction of expired tickets Improved response times Proactive workload management For Organizations Higher SLA compliance Increased customer satisfaction Optimized technical support resources Ideal Use Cases IT Service Centers: Incident and request management Technical Support Teams: Critical case tracking Organizations with Strict SLAs: Service agreement compliance IT Departments: Internal ticket monitoring Scalability This workflow is designed to: Handle high ticket volumes Adapt to teams of different sizes Integrate with multiple communication channels Expand with additional functionalities Installation and Deployment Import the JSON workflow into n8n Configure GLPI and Microsoft Teams credentials Update configuration variables Activate the scheduled trigger Perform functionality tests This workflow represents a robust and scalable solution for proactive ticket management in enterprise environments, significantly improving operational efficiency and service commitment compliance.
By Luis HernandezGenerate GLPI support performance reports with SLA tracking & email delivery
Overview This comprehensive n8n workflow automates the generation and distribution of detailed monthly technical support reports from GLPI (IT Service Management platform). The workflow intelligently calculates SLA compliance, analyzes technician performance, and delivers professionally formatted HTML reports via email. ✨ Key Features Intelligent SLA Calculation Business Hours Tracking: Automatically calculates resolution time considering only working hours (excludes weekends and lunch breaks) Configurable Schedule: Customizable work hours (default: 8 AM - 12 PM, 1 PM - 6 PM) Dynamic SLA Monitoring: Real-time compliance tracking with configurable thresholds (default: 24 hours) Visual Indicators: Color-coded alerts for critical SLA breaches and high-volume warnings Comprehensive Reporting General Summary: Total cases, open, in-progress, resolved, and closed tickets Performance Metrics: Total and average resolution hours in both decimal and formatted (hours/minutes) display Technician Breakdown: Individual performance analysis per technician including case distribution and SLA compliance Smart Alerts: Automatic warnings for high case volumes (>100 in-progress) and critical SLA levels (<50%) Professional Email Delivery Responsive HTML Design: Mobile-optimized email templates with elegant styling Dynamic Content: Conditional formatting based on performance metrics Automatic Scheduling: Monthly execution on the 6th day to ensure accurate SLA measurement 💼 Business Benefits Time Savings Eliminates Manual Work: Saves 2-4 hours per month previously spent compiling reports manually Automated Data Collection: No more exporting CSVs or copying data between systems One-Click Setup: Configure once and receive reports automatically every month Improved Decision Making Real-Time Insights: Identify bottlenecks and performance issues immediately Technician Accountability: Clear visibility into individual and team performance SLA Compliance Tracking: Proactively manage service level agreements before they become critical Enhanced Communication Stakeholder Ready: Professional reports suitable for management presentations Consistent Format: Standardized metrics ensure month-over-month comparability Instant Distribution: Automatic email delivery to relevant stakeholders 🔧 Technical Specifications Requirements n8n instance (self-hosted or cloud) GLPI server with API access enabled Gmail account (or any SMTP-compatible email service) GLPI API credentials (App-Token and User credentials) Configuration Points Variables Node: Server URL, API tokens, entity name, work hours, SLA limits Schedule Trigger: Monthly execution timing (default: 6th of each month) Email Recipient: Target email address for report delivery Date Range Logic: Automatic previous month calculation Data Processing Retrieves up to 999 tickets per execution (configurable) Filters by entity and date range Excludes weekends and non-business hours from calculations Groups data by technician for detailed analysis 📋 Setup Instructions Prerequisites GLPI Configuration: Enable API and configure the Tickets panel with required fields (ID, -Title, Status, Opening Date, Closing Date, Resolution Date, Priority, Requester, Assigned To) API Credentials: Create Basic Auth credentials in n8n for GLPI API access Email Authentication: Set up Gmail OAuth2 or SMTP credentials in n8n Implementation Steps Import the workflow JSON into your n8n instance Configure the Variables node with your GLPI server details and business hours Set up GLPI API credentials in the HTTP Request nodes Configure email credentials in the Gmail node Update the recipient email address Test the workflow manually before enabling the schedule Activate the workflow for automatic monthly execution 🎯 Use Cases IT Support Teams: Track helpdesk performance and SLA compliance Service Managers: Monitor team productivity and identify training needs Executive Reporting: Provide high-level summaries to stakeholders Resource Planning: Identify workload distribution and capacity issues Compliance Auditing: Maintain historical records of SLA performance 📈 ROI Impact Time Savings: 24-48 hours annually in manual reporting eliminated Error Reduction: Eliminates human calculation errors in SLA tracking Faster Response: Early alerts enable proactive issue resolution Better Visibility: Data-driven insights improve team management
By Luis Hernandez