Automated Test Runner and Reporting Pipeline - n8n Workflow

Ideal Users

DevOps and CI/CD Teams: Organizations utilizing n8n for critical backend processes who require reliable automated testing.
Automation Architects: Users needing advanced flow control and error logging capabilities in their n8n workflow designs.
Technical Managers: Individuals who need real-time monitoring and centralized reporting of automation health via ClickUp and Google Drive.
Anyone: Looking for advanced n8n templates to implement self-testing infrastructure.

This comprehensive n8n workflow template is designed to supervise and validate the execution of other n8n templates. It addresses the critical need for automated regression testing and reliable performance monitoring in complex n8n environments. The core of this system is the Execute Workflow n8n node, which runs a designated sub-workflow and, crucially, captures the output, including any error objects, without halting execution.

Upon completion, the process evaluates the result: a pass triggers success logging in Google Drive and a positive status update in ClickUp; a failure triggers failure logging, error archival in a Google Sheet, and a critical alert update in the associated ClickUp task. This n8n workflow ensures a robust audit trail and immediate stakeholder notification, making it a powerful addition to your n8n infrastructure.

This automation initiates when the manual n8n trigger is activated, serving as the start signal for the testing cycle.

1. Execute Target Workflow: The Execute Target Workflow Under Test n8n node calls the specified sub-workflow ('Archive Payment Receipts with Stripe...'). It is configured to continue processing even if the sub-workflow fails, ensuring the error data is captured.


2. Test Result Evaluation: The Test Result Evaluation n8n node, an If statement, checks the output for the presence of an 'error' field. If no error exists, the workflow follows the True (Success) path; otherwise, it follows the False (Failure) path.


3. Success Logging (True Path): The result is formatted, converted into a .txt file, archived in Google Drive, and used to update a specific ClickUp task with a 'Passed' status.


4. Failure Logging & Reporting (False Path): The failure details are formatted and simultaneously sent to two branches:

This entire process guarantees that every execution of the target n8n workflow is monitored, logged, and reported effectively.

To set up this powerful automated testing n8n workflow template, follow these steps:

1. Import the JSON: Copy the provided JSON data and import it into your n8n instance via the 'Workflows' > 'New' > 'Import from JSON' option.


2. Configure Credentials: Establish or link the required credentials for the n8n node integrations:

1. Specify Target Workflow: In the Execute Target Workflow Under Test n8n node, ensure the Workflow ID points to the specific n8n workflow you wish to test (currently configured for 'Archive Payment Receipts...').


2. Define Target Locations: Update the folderId in the Google Drive nodes and the documentId/sheetName in the Google Sheets n8n node to match your desired archival and logging locations.


3. Set ClickUp Task ID: Modify the fixed Task ID (86b700vbb) in both ClickUp n8n nodes to correspond to the task you want updated with test results.


4. Activate: Once configured, you can test the n8n trigger manually.

This n8n workflow utilizes several key n8n node types to achieve its advanced testing capabilities:

When clicking ‘Execute workflow’ (Manual Trigger): The initiating n8n trigger. Used here to manually start the test execution cycle, essential for quick testing of the n8n templates.
Execute Target Workflow Under Test (Execute Workflow n8n node): Calls and executes another n8n workflow. Key configuration: Wait for Sub-Workflow is enabled, and On Error is set to 'Continue Regular Output' to ensure the main flow captures errors.
Test Result Evaluation (If n8n node): The core decision gate. Checks if the error field is present in the output data. This determines if the n8n workflow run succeeded or failed.
Format Success/Failed Test Result (Set n8n node): Standardizes the output data, setting 'status', 'testedworkflow', and 'timestamp' variables used by all downstream reporting n8n nodes.
Generate Success/Failure Report Text (Code n8n node): Creates a formatted, human-readable text report string from the variables, which is then used for both file creation and ClickUp updates.
Convert Success/Failure Report to Text File (Convert To File n8n node): Prepares the text report into a binary file format (.txt) required for the Google Drive n8n node upload.
Archive Success/Failure Report to Google Drive (Google Drive n8n node): Uploads the report file, dynamically naming it using the status and timestamp (e.g., Retention Tracking Post-Hire✅ Passed_2023-10-26.txt).
Update ClickUp Task with Success/Failure Status (ClickUp n8n node): Connects the testing outcome to project management, updating a specific task's content with the detailed pass/fail report generated by the Code n8n node.

• Log Error Details to Error Tracking Sheet (Google Sheets n8n node): In the failure path, this crucial n8n node appends the raw, detailed error object to a structured Google Sheet for long-term failure analysis.