中文网

Bug汇总器

中级

这是一个Content Creation、Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 If、Zendesk、GoogleSheets、ManualTrigger 等节点。 自动Bug报告汇总器：将Zendesk Bug工单同步到Google表格

前置要求
  • •Google Sheets API 凭证

使用的节点 (11 个)

If
Zendesk
StickyNote
GoogleSheets
ManualTrigger

分类

Content Creation
Multimodal AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "kIN8X8CkweB2yEiP",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177"
  },
  "name": "Bug 汇总器",
  "tags": [],
  "nodes": [
    {
      "id": "0253acc9-a616-49ba-a3d7-a9231eb0cdde",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        496,
        480
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1ec2303c-04fe-433d-9f94-863550e9eeb1",
      "name": "Bug 工作流概览",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        416
      ],
      "parameters": {
        "width": 526,
        "height": 384,
        "content": "## Bug 跟踪工作流"
      },
      "typeVersion": 1
    },
    {
      "id": "eb5ffe7e-f226-43b0-b084-c14e8676c40f",
      "name": "手动触发器使用",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        112
      ],
      "parameters": {
        "width": 320,
        "height": 328,
        "content": "## 手动执行"
      },
      "typeVersion": 1
    },
    {
      "id": "ba1a0bf1-c18e-4a72-85e0-9789b0fe8bea",
      "name": "Zendesk 集成信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        672
      ],
      "parameters": {
        "width": 320,
        "height": 344,
        "content": "## Zendesk 数据源"
      },
      "typeVersion": 1
    },
    {
      "id": "3630e74a-7eda-4d28-847c-62eff46fe6e4",
      "name": "Bug 筛选逻辑",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        96
      ],
      "parameters": {
        "width": 320,
        "height": 344,
        "content": "## Bug 识别"
      },
      "typeVersion": 1
    },
    {
      "id": "6f5a7b23-4323-47ba-9761-622bd43ced77",
      "name": "客户影响跟踪",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        656
      ],
      "parameters": {
        "width": 320,
        "height": 360,
        "content": "## 客户影响分析"
      },
      "typeVersion": 1
    },
    {
      "id": "4dbc6762-5725-4b5b-b096-e2af7cb907e0",
      "name": "Bug 仪表板管理",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        64
      ],
      "parameters": {
        "width": 320,
        "height": 384,
        "content": "## Bug 仪表板更新"
      },
      "typeVersion": 1
    },
    {
      "id": "5a5255f2-ab9c-4afe-9887-288f5f1240e8",
      "name": "仅筛选 Bug 报告",
      "type": "n8n-nodes-base.if",
      "position": [
        944,
        480
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "cc47baeb-cdfb-4a6b-94ca-ef18c6450d9f",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.tags[0] }}",
              "rightValue": "=bug"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "4f691f63-54df-47c6-b498-c0027b9d7870",
      "name": "获取 Bug 报告者信息",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        1168,
        480
      ],
      "parameters": {
        "id": "={{ $json.requester_id }}",
        "resource": "user",
        "operation": "get"
      },
      "credentials": {
        "zendeskApi": {
          "id": "BQ61OjTaFfNPQ1bK",
          "name": "Zendesk account-anuj"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cd8695ea-ba75-4723-9967-29ebe7e97fc2",
      "name": "更新 Bug 跟踪表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1392,
        480
      ],
      "parameters": {
        "columns": {
          "value": {
            "Tag": "={{ $('Filter Bug Reports Only').item.json.tags[0] || 'No tags' }}",
            "email": "={{ $json.email }}",
            "owner": "={{ $json.name }}",
            "Status": "={{ $('Filter Bug Reports Only').item.json.status }}",
            "Ticket No.": "={{ $('Filter Bug Reports Only').item.json.id }}",
            "Description": "={{ $('Filter Bug Reports Only').item.json.description }}"
          },
          "schema": [
            {
              "id": "Ticket No.",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Ticket No.",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "owner",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "owner",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Tag",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Tag",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Description"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Utpt2Z8krX-29nE3_HAJVmm9yUp9NRcq-_P8JL1UqRk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Utpt2Z8krX-29nE3_HAJVmm9yUp9NRcq-_P8JL1UqRk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Utpt2Z8krX-29nE3_HAJVmm9yUp9NRcq-_P8JL1UqRk/edit?usp=drivesdk",
          "cachedResultName": "Ticket status dummy"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "94eef00f-986d-431f-8956-3534939d5c76",
      "name": "获取所有 Zendesk 工单",
      "type": "n8n-nodes-base.zendesk",
      "position": [
        720,
        480
      ],
      "parameters": {
        "options": {},
        "operation": "getAll",
        "returnAll": true
      },
      "credentials": {
        "zendeskApi": {
          "id": "BQ61OjTaFfNPQ1bK",
          "name": "Zendesk account-anuj"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "85116073-56a5-4546-9c4c-7ae78b420a25",
  "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
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

这是一个中级难度的工作流，适用于Content Creation、Multimodal AI等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

知识库自动更新
将 Zendesk 操作指南工单同步到 Google Sheets 知识库
If
Code
Zendesk
+5
24 节点Rahul Joshi
Content Creation
雇佣后留存跟踪
使用GPT-4o和Gmail摘要生成员工留存分析报告
If
Code
Gmail
+6
19 节点Rahul Joshi
Content Creation
待处理付款自动化 - ClickUp集成
使用Google Sheets、ClickUp、Gmail和Slack自动化付款跟踪
If
Gmail
Slack
+4
12 节点Rahul Joshi
Content Creation
技能差距 → 培训推荐
为 HR 团队使用 GPT-4o、Google Sheets 和 Gmail 个性化候选人反馈
If
Code
Gmail
+7
27 节点Rahul Joshi
Content Creation
面试质量审计
使用GPT-4o-mini和Google表格通过Slack审核面试反馈并生成报告
If
Code
Slack
+5
23 节点Rahul Joshi
Content Creation
使用Stripe、Google Drive和Google Sheets归档付款收据
自动化付款收据：通过Stripe和Google Workspace发送邮件、归档和跟踪
If
Gmail
Split Out
+5
21 节点Rahul Joshi
Content Creation
工作流信息
难度等级
中级
节点数量11
分类2
节点类型5
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.

外部链接
在 n8n.io 上查看 →

分享此工作流