时间日志报告Clickup（BDE）

• •Google 账号和 Gmail API 凭证

{
  "id": "xVWb962oKTrPDnCW",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "时间日志报告 Clickup (BDE)",
  "tags": [],
  "nodes": [
    {
      "id": "d62f9407-69b4-41d9-9977-8fd3bb43d084",
      "name": "处理冲刺数据",
      "type": "n8n-nodes-base.function",
      "position": [
        -416,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8883b033-77cf-4d39-b0dc-490b11c4dedf",
      "name": "发送每日报告邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        224,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6627e0b3-2931-42cf-ac8a-0565d694fb3f",
      "name": "创建报告",
      "type": "n8n-nodes-base.function",
      "position": [
        -64,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "259a67a2-52d9-4c5b-93c2-6d245b25c3f2",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        240,
        -112
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "b12bcbbe-9b65-4e19-8e0f-0ccc06bd49d0",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -192
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "12efbfc4-e75d-4c3c-a45d-d4a86146dded",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        432
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "b7f97dd4-af50-4951-96c9-feda7ff3cc22",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -656,
        -112
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "36cfc79f-1179-4765-b334-485d24a331b8",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2032,
        -80
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "9d8e43e9-7320-4eaa-bdb7-da8da622ae1b",
      "name": "获取所有列表（冲刺）",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -1520,
        304
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6a348c15-a6a0-4e80-8294-d216d87f0f95",
      "name": "检查列表是否存在",
      "type": "n8n-nodes-base.if",
      "position": [
        -1264,
        304
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "e25f00d1-5688-4339-8492-2cdd3ec522df",
      "name": "查找最新冲刺",
      "type": "n8n-nodes-base.code",
      "position": [
        -992,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6f26a0c3-4b29-4588-8eb6-c9c92bfa3549",
      "name": "从最新冲刺获取任务",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -736,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "61aaf594-4dc8-4545-bca0-8c2f559064ab",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1792,
        304
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "75f51ab6-006e-4010-8874-e86e49b15ca4",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1664,
        -80
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "5d63e9d8-b728-43a1-bff6-5a0964bdf01b",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1072,
        448
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "2ec45003-a396-4eae-ac06-f725a4e85b8c",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1328,
        -96
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "9242b7eb-44ce-406d-bfd9-7f5e97fcd660",
  "connections": {
    "creating report": {
      "main": [
        [
          {
            "node": "Send Daily Report Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get All Lists (Sprints)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Lists Exist": {
      "main": [
        [
          {
            "node": "Find Latest Sprint",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Find Latest Sprint": {
      "main": [
        [
          {
            "node": "Get Tasks from Latest Sprint",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Sprint Data": {
      "main": [
        [
          {
            "node": "creating report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Lists (Sprints)": {
      "main": [
        [
          {
            "node": "Check Lists Exist",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Tasks from Latest Sprint": {
      "main": [
        [
          {
            "node": "Process Sprint Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}