{
  "name": "Automated workflow test runner with Google Drive, Sheets & ClickUp result logging",
  "nodes": [
    {
      "id": "ebbca67b-a5e8-47a6-b0f0-0e01a2cf0c90",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -576,
        0
      ]
    },
    {
      "id": "f90f0568-e7ab-451c-bfe9-7151835fec62",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        208
      ],
      "parameters": {
        "width": 304,
        "height": 368,
        "content": "## 🔄 Execute Target Workflow Under Test\n**Action:**  \n- Calls and executes the \"Archive Payment Receipts\" workflow as a sub-process.  \n**Description:**  \n- Runs the specified workflow and waits for it"
      }
    },
    {
      "id": "f5de02c6-f686-402f-90df-80bc60151c1c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        -480
      ],
      "parameters": {
        "width": null,
        "height": 448,
        "content": "## ✅ Test Result Evaluation (Pass/Fail Check)\n**Action:**  \n- Determines whether the sub-workflow executed successfully or failed.  \n**Description:**  \n- Checks if an \"error\" field exists in the retur"
      }
    },
    {
      "id": "3af7b28f-f3a6-45af-a3c0-49d0d867290d",
      "name": "Test Result Evaluation ",
      "type": "n8n-nodes-base.if",
      "position": [
        -16,
        0
      ]
    },
    {
      "id": "c9ded697-7e80-4c9d-ae63-b34dd83a4b4b",
      "name": "Format Success Test Result",
      "type": "n8n-nodes-base.set",
      "position": [
        384,
        -208
      ]
    },
    {
      "id": "0df832de-9809-4c05-944b-1ab8e62fb6ff",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1232,
        -704
      ],
      "parameters": {
        "width": null,
        "height": 448,
        "content": "## ☁️ Archive Success Report to Google Drive\n**Action:**  \n- Uploads the success test report file to a designated Google Drive folder.  \n**Description:**  \n- Stores test results in the \"resume store\" "
      }
    },
    {
      "id": "18671bfd-775b-42e6-a64e-3921ffee5961",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -640
      ],
      "parameters": {
        "width": null,
        "height": 384,
        "content": "## 📦 Convert Success Report to Text File\n**Action:**  \n- Transforms the formatted text into a downloadable .txt file.  \n**Description:**  \n- Prepares the success report for upload to Google Drive.  \n-"
      }
    },
    {
      "id": "90db750f-6254-40d3-8755-4b22c377f3c3",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        -640
      ],
      "parameters": {
        "width": null,
        "height": 400,
        "content": "## 📄 Generate Success Report Text\n**Action:**  \n- Formats test result data into a human-readable text report.  \n**Description:**  \n- Concatenates workflow name, pass status, and timestamp into a struc"
      }
    },
    {
      "id": "fcce2d0a-4f68-49c5-a1e6-87be0cadb94b",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        -672
      ],
      "parameters": {
        "width": null,
        "height": 448,
        "content": "## 🎯 Format Success Test Result\n**Action:**  \n- Structures the test outcome data for successful workflow execution.  \n**Description:**  \n- Creates a standardized result object containing:  \n  - Status"
      }
    },
    {
      "id": "48482dbc-5fa7-47d6-8f4e-94f4f7cecf3c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        384
      ],
      "parameters": {
        "width": null,
        "height": 448,
        "content": "## ❌ Format Failed Test Result\n**Action:**  \n- Structures the test outcome data for failed workflow execution.  \n**Description:**  \n- Creates a standardized result object containing:  \n  - Status: \"❌ "
      }
    },
    {
      "id": "163d4cae-b9b2-4317-867e-d5b3ad1d4173",
      "name": "Format Failed Test Result",
      "type": "n8n-nodes-base.set",
      "position": [
        368,
        224
      ]
    },
    {
      "id": "5040deb0-6db6-40c8-9cad-f8637dd2f9fa",
      "name": "Generate Success Report Text",
      "type": "n8n-nodes-base.code",
      "position": [
        736,
        -208
      ]
    },
    {
      "id": "2b1741e8-7258-4f28-b050-57dc4545692b",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1232,
        416
      ],
      "parameters": {
        "width": null,
        "height": 400,
        "content": "## ☁️ Archive Failure Report to Google Drive\n**Action:**  \n- Uploads the failure test report file to a designated Google Drive folder.  \n**Description:**  \n- Stores test results in the \"resume store\" "
      }
    },
    {
      "id": "8e5de5e8-71a1-4a74-b1a9-df712153c9db",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        944,
        416
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## 📦 Convert Failure Report to Text File\n**Action:**  \n- Transforms the formatted text into a downloadable .txt file.  \n**Description:**  \n- Prepares the failure report for upload to Google Drive.  \n-"
      }
    },
    {
      "id": "54f6ba7c-b99c-40c3-a0ec-14bfd933ca2c",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        400
      ],
      "parameters": {
        "width": null,
        "height": 368,
        "content": "## 📄 Generate Failure Report Text\n**Action:**  \n- Formats test result data into a human-readable text report.  \n**Description:**  \n- Concatenates workflow name, fail status, and timestamp into a struc"
      }
    },
    {
      "id": "6637cf99-13de-4668-bb63-ea921dccc182",
      "name": "Generate Failure Report Text",
      "type": "n8n-nodes-base.code",
      "position": [
        736,
        224
      ]
    },
    {
      "id": "1140f35d-1fc6-4dab-b7a5-4ac118ea4a6d",
      "name": "Convert Success Report to Text File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1024,
        -208
      ]
    },
    {
      "id": "57b36b45-ebfb-4e36-8b3d-79641f1831a9",
      "name": "Convert Failure Report to Text File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1008,
        224
      ]
    },
    {
      "id": "4b572d2b-e233-410b-aa83-abae2b023184",
      "name": "Archive Success Report to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1296,
        -208
      ]
    },
    {
      "id": "0c3a0ce7-61bd-4ab4-9e3b-a0f6a97c75bb",
      "name": "Archive Failure Report to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1312,
        224
      ]
    },
    {
      "id": "dcde5325-c1a3-4e33-acf9-661587287d9f",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1552,
        400
      ],
      "parameters": {
        "width": null,
        "height": 400,
        "content": "## ✏️ Update ClickUp Task with Failure Status\n**Action:**  \n- Posts the failure test result to a specific ClickUp task for team visibility.  \n**Description:**  \n- Updates task ID .. with formatted tes"
      }
    },
    {
      "id": "5622acb4-1563-498d-9ac8-cb0d2fdadebf",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        -656
      ],
      "parameters": {
        "width": null,
        "height": 400,
        "content": "## ✏️ Update ClickUp Task with Success Status\n**Action:**  \n- Posts the success test result to a specific ClickUp task for team visibility.  \n**Description:**  \n- Updates task ID with formatted test o"
      }
    },
    {
      "id": "7c80063a-3bfe-4677-9dfc-9f24616bb84a",
      "name": "Update ClickUp Task with Success Status",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1552,
        -208
      ]
    },
    {
      "id": "b26d1493-d58a-4395-b4d3-d2bdfa4080cb",
      "name": "Update ClickUp Task with Failure Status",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1584,
        224
      ]
    },
    {
      "id": "5dff41d1-8ca3-49e2-a6cd-f181bb402cb0",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        784
      ],
      "parameters": {
        "width": null,
        "height": 448,
        "content": "## 📊 Log Error Details to Error Tracking Sheet\n**Action:**  \n- Appends error information to a dedicated error log in Google Sheets.  \n**Description:**  \n- Writes to the \"error log sheet\" tab in the \"I"
      }
    },
    {
      "id": "4a18b563-f4ef-4ad8-8b19-74d45ac01736",
      "name": " Log Error Details to Error Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        144,
        752
      ]
    },
    {
      "id": "4158484c-a8ed-4c33-8ea2-f0fb7cf2194d",
      "name": "Execute Target Workflow Under Test",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        -288,
        0
      ]
    }
  ],
  "connections": {
    "Test Result Evaluation ": {
      "main": [
        [
          {
            "node": "Format Success Test Result",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Failed Test Result",
            "type": "main",
            "index": 0
          },
          {
            "node": " Log Error Details to Error Tracking Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Failed Test Result": {
      "main": [
        [
          {
            "node": "Generate Failure Report Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Success Test Result": {
      "main": [
        [
          {
            "node": "Generate Success Report Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Failure Report Text": {
      "main": [
        [
          {
            "node": "Convert Failure Report to Text File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Success Report Text": {
      "main": [
        [
          {
            "node": "Convert Success Report to Text File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Execute Target Workflow Under Test": {
      "main": [
        [
          {
            "node": "Test Result Evaluation ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Failure Report to Text File": {
      "main": [
        [
          {
            "node": "Archive Failure Report to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Success Report to Text File": {
      "main": [
        [
          {
            "node": "Archive Success Report to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Execute Target Workflow Under Test",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Archive Failure Report to Google Drive": {
      "main": [
        [
          {
            "node": "Update ClickUp Task with Failure Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Archive Success Report to Google Drive": {
      "main": [
        [
          {
            "node": "Update ClickUp Task with Success Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}