Advanced n8n workflow JSON object creation w/ Stats, Analytics, HTML Dashboard

n8n Instance Analytics & JSON Report Generator This workflow provides a comprehensive audit and analysis of an entire n8n instance. It systematically fetches data for every workflow, processes it to extract key statistics, and compiles everything into a single, structured JSON object. This final object is ideal for use in Business Intelligence (BI) tools, custom dashboards, or for administrative reporting to understand instance usage, complexity, and health. Technologies Used - n8n API: Connects to the instance itself to retrieve a list of all workflows and their detailed configurations. - JavaScript (Code & Set Nodes): Heavily used for data manipulation, including: - JMESPath: For efficiently querying and extracting specific data points from complex JSON structures. - Luxon: For parsing and formatting date-time values. - Advanced JS: Array methods (.map, .reduce, .forEach), Set for finding unique values, and template literals for string construction. - Core n8n Logic Nodes: - Sort: To organize the data for better readability and structured output. - Aggregate: To group lists of items into single, structured fields. - Merge: To combine multiple, parallel data streams into one final output object. Automation Value The workflow automates the tedious and complex process of n8n instance auditing. Instead of manually inspecting each workflow to check its nodes, tags, triggers, or activity, this automation provides a complete, queryable snapshot on demand. The value lies in: - Instance Governance: Quickly identify which workflows use specific nodes (e.g., for deprecation), which are untagged, or which are inactive. - Performance Monitoring: Get a high-level view of total trigger counts and the number of active vs. inactive workflows. - Dependency Mapping: Instantly see which workflows are associated with a specific webhook path, node type, or tag. - BI & Reporting: The structured JSON output can be directly fed into tools like Grafana, Power BI, or Tableau to create dynamic, visual dashboards for monitoring the n8n environment.