{
  "name": "Auto bug report aggregator: Sync Zendesk bug tickets into Google Sheets",
  "nodes": [
    {
      "id": "0253acc9-a616-49ba-a3d7-a9231eb0cdde",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        496,
        480
      ]
    },
    {
      "id": "1ec2303c-04fe-433d-9f94-863550e9eeb1",
      "name": "Bug Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        416
      ],
      "parameters": {
        "width": 526,
        "height": 384,
        "content": "## Bug Tracking Workflow\n\nThis workflow automatically tracks and aggregates bug reports from Zendesk into a centralized Google Sheets dashboard.\n\n**Flow Overview:**\n1. Fetches all tickets from Zendesk"
      }
    },
    {
      "id": "eb5ffe7e-f226-43b0-b084-c14e8676c40f",
      "name": "Manual Trigger Usage",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        112
      ],
      "parameters": {
        "width": 320,
        "height": 328,
        "content": "## Manual Execution\n\nClick 'Execute Workflow' to run bug aggregation on-demand.\n\n**When to run manually:**\n- After major releases\n- During bug triage meetings\n- For immediate bug status updates\n- Test"
      }
    },
    {
      "id": "ba1a0bf1-c18e-4a72-85e0-9789b0fe8bea",
      "name": "Zendesk Integration Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        672
      ],
      "parameters": {
        "width": 320,
        "height": 344,
        "content": "## Zendesk Data Source\n\nRetrieves all tickets from your Zendesk instance for bug analysis.\n\n**Data Retrieved:**\n- Ticket descriptions\n- Status information\n- Tags and metadata\n- Requester IDs\n- Creatio"
      }
    },
    {
      "id": "3630e74a-7eda-4d28-847c-62eff46fe6e4",
      "name": "Bug Filter Logic",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        96
      ],
      "parameters": {
        "width": 320,
        "height": 344,
        "content": "## Bug Identification\n\nFilters tickets to identify only those tagged as \"bug\".\n\n**Filter Criteria:**\n- First tag must equal \"bug\" (case-sensitive)\n- Excludes feature requests, questions, etc.\n- Only b"
      }
    },
    {
      "id": "6f5a7b23-4323-47ba-9761-622bd43ced77",
      "name": "Customer Impact Tracking",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        656
      ],
      "parameters": {
        "width": 320,
        "height": 360,
        "content": "## Customer Impact Analysis\n\nEnriches bug data with customer information for impact assessment.\n\n**Customer Data Added:**\n- Reporter name\n- Email address\n- User profile details\n\n**Why Important:** \n- "
      }
    },
    {
      "id": "4dbc6762-5725-4b5b-b096-e2af7cb907e0",
      "name": "Bug Dashboard Management",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        64
      ],
      "parameters": {
        "width": 320,
        "height": 384,
        "content": "## Bug Dashboard Update\n\nMaintains a centralized bug tracking spreadsheet for team visibility.\n\n**Tracked Information:**\n- Bug ID & Description\n- Current Status\n- Reporter Details\n- Bug Tags\n\n**Smart "
      }
    },
    {
      "id": "5a5255f2-ab9c-4afe-9887-288f5f1240e8",
      "name": "Filter Bug Reports Only",
      "type": "n8n-nodes-base.if",
      "position": [
        944,
        480
      ]
    },
    {
      "id": "4f691f63-54df-47c6-b498-c0027b9d7870",
      "name": "Get Bug Reporter Info",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        1168,
        480
      ]
    },
    {
      "id": "cd8695ea-ba75-4723-9967-29ebe7e97fc2",
      "name": "Update Bug Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1392,
        480
      ]
    },
    {
      "id": "94eef00f-986d-431f-8956-3534939d5c76",
      "name": "Fetch All Zendesk Tickets",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        720,
        480
      ]
    }
  ],
  "connections": {
    "Get Bug Reporter Info": {
      "main": [
        [
          {
            "node": "Update Bug Tracking Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Bug Reports Only": {
      "main": [
        [
          {
            "node": "Get Bug Reporter Info",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch All Zendesk Tickets": {
      "main": [
        [
          {
            "node": "Filter Bug Reports Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Fetch All Zendesk Tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}