Advanced Maintenance System with Intelligent Workflow Filtering - n8n Workflow

n8n administrators managing large, complex self-hosted instances.
DevOps engineers needing automated backup and security auditing for their automation platform.
Users looking for advanced n8n templates for infrastructure management.
Teams requiring robust, scheduled maintenance routines to ensure platform health.

Managing dozens or hundreds of production n8n workflow automations can be complex. This powerful system solves the challenge of routine maintenance, security, and backup by automating these crucial tasks using the internal n8n node capabilities and intelligent filtering logic. The system is designed to execute four core actions: Security Audit (logging to Google Sheets), Scheduled Pause/Resume for maintenance windows, Smart Duplication for instant backups, and Intelligent Export (saving to Google Drive). The intelligence is derived from a custom scoring engine that analyzes factors like node count, activity, and critical tags to determine which n8n workflow is high-value and requires action. This comprehensive maintenance n8n workflow ensures operational stability and security compliance.

The n8n workflow begins with a secure Webhook n8n trigger. The Webhook node receives a request detailing the desired action (audit, pause, duplicate, or export).

1. Security & Routing: A Code node, 🔐 Security Validator, enforces token authentication and whitelists actions. The If node checks for success, and the 🔀 Action Router Switch node directs the flow based on the requested action.

1. Audit (Case 0): The 🔒 Generate Security Audit n8n node uses the n8n API to generate a security report. The 📊 Parse Audit Data Code node structures this complex JSON into flat rows, adding severity scores. Finally, the data is appended to 📈 Save to Google Sheets.

1. Pause (Case 1): The ⏸️ Get Workflows to Pause n8n node fetches active workflows. The 🔍 Filter Workflows Code node applies manual filters (name pattern, tags) and enforces exclusion of protected critical n8n workflow templates. Affected workflows are paused via the ⏸️ Deactivate Workflow n8n node, wait 8 hours in the ⏰ Wait 8h for Reactivation n8n trigger, and are then reactivated by the ▶️ Reactivate Workflows n8n node.

1. Duplicate (Case 2): Workflows are fetched and filtered by the 🤖 AI Filter for Duplicate Code node using a scoring system (score ≥3 required) to select high-value targets. The system then uses the n8n API to retrieve details and the 🔄 Prepare Duplicate Data Code node generates a complete, clean JSON payload, assigning new unique IDs and tagging the copy as 'backup'. The ➕ Create Duplicate Workflow n8n node submits this payload to create the new backup n8n workflow.

1. Export (Case 3): The 📦 Get Workflows for Export n8n node retrieves data, and the 🧠 AI Filter for Export Code node uses an advanced scoring engine (score ≥5 required, or system workflow) to select business-critical automations. The 📤 Prepare Export Data Code node aggregates the full JSON payload, rich with performance metadata and statistics. This data is then converted to binary and stored in Google Drive using the ☁️ Save to Google Drive n8n node, providing a secure, centralized backup of your critical n8n templates.

1. Import the n8n template: Copy the provided JSON and import it into your n8n instance via the Settings > Import Workflow menu.


2. Configure n8n API Credentials: This n8n workflow requires an API credential with administrative access to manage workflows (read, write, activate, deactivate). Set this up for the internal n8n node operations.


3. Set up Google Integrations:

1. Configure Webhook Security:

1. Activate Schedules: Activate the three Schedule n8n trigger nodes (📅 Weekly Audit Schedule, 📅 Daily Pause Schedule, 📅 Monthly Export Schedule) to enable automatic, periodic maintenance.

Webhook (n8n trigger): The entry point for the automation. Listens for POST requests at /ops/n8n and enforces Bearer Token authentication via credentials and the subsequent Code node.
n8n (API Node): Used extensively for core operations like fetching, activating, deactivating, auditing, and creating workflows. This n8n node communicates directly with the hosting n8n instance API.
🔐 Security Validator (Code Node): A crucial security n8n node. Validates the Authorization Bearer Token and verifies that the incoming request body contains a valid, supported action (e.g., 'audit', 'pause'), ensuring security and data integrity.
🔀 Action Router (Switch Node): A dynamic control flow n8n node that uses an expression to route the request based on the dynamic action field provided by the previous Code node.
🧠 AI Filter for Export (Code Node): An advanced filtering n8n node that calculates a complexity and importance score for each workflow based on tags, recent activity, node count, and semantic analysis of the name. Only high-scoring n8n workflow templates (score ≥5) are selected for comprehensive export backup.
📊 Parse Audit Data (Code Node): Used in the audit path to flatten the nested JSON security report generated by the n8n API into structured rows ready for database insertion, applying severity classifications.
⏰ Wait 8h for Reactivation (Wait Trigger): A specialized n8n trigger that pauses the workflow execution for 8 hours before proceeding to reactivate the paused workflows, simulating a maintenance window.
☁️ Save to Google Drive (Google Drive Node): Saves the comprehensive binary workflow export file, ensuring cloud persistence for crucial n8n workflow templates and backups.

• 📈 Save to Google Sheets (Google Sheets Node): Logs structured security audit results, including risk type, description, and severity, providing a historical record of n8n maintenance.