Automated workflow test runner with Google Drive, Sheets & ClickUp result logging
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, ClickUp and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Execute Target Workflow Under Test (Execute Sub-workflow): calls another n8n workflow
- Test Result Evaluation (If): checks a condition and branches into true / false
- Format Success Test Result (Edit Fields (Set)): sets 3 fields: status, tested_workflow, timestamp
- Format Failed Test Result (Edit Fields (Set)): sets 3 fields: status, tested_workflow, timestamp
- Log Error Details to Error Tracking Sheet (Google Sheets): append or update
- Generate Success Report Text (Code): runs custom JavaScript code
- Generate Failure Report Text (Code): runs custom JavaScript code
- Convert Success Report to Text File (Convert to File): converts data to a file (to text)
- Convert Failure Report to Text File (Convert to File): converts data to a file (to text)
- Archive Success Report to Google Drive (Google Drive): uses Google Drive
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Convert to File
n8n-nodes-base.convertToFile - Google Drive
n8n-nodes-base.googleDrive - ClickUp
n8n-nodes-base.clickUp - Google Sheets
n8n-nodes-base.googleSheets - Execute Sub-workflow
n8n-nodes-base.executeWorkflow
From the author
Description This workflow acts as a CI/CD-style test harness for validating other n8n workflows. It executes a target workflow (here: Archive Payment Receipts), evaluates pass/fail outcomes, and generates structured reports. Results are automatically archived…