8
n8n 中文网amn8n.com

每日 Trello 任务截止日期摘要发送至 Slack

中级

这是一个Project Management, Multimodal AI领域的自动化工作流,包含 13 个节点。主要使用 Set, Code, Merge, Slack, Filter 等节点。 每日 Trello 任务截止日期摘要发送至 Slack

前置要求
  • Slack Bot Token 或 Webhook URL
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "edea30b9-4fe9-4c32-a10b-4775910ef67e",
      "name": "当点击“执行工作流”时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -368,
        2544
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5bb5ef97-8ddd-4a66-b5c2-00a5062fe85a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        2400
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ 设置说明"
      },
      "typeVersion": 1
    },
    {
      "id": "f0ec26ef-3b96-40f9-a387-2353d880d44a",
      "name": "便签 44",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        2400
      ],
      "parameters": {
        "color": 7,
        "width": 1248,
        "height": 928,
        "content": "# 📋 Trello → Slack 每日任务报告器"
      },
      "typeVersion": 1
    },
    {
      "id": "ba24e584-d77a-42a4-871e-a543f1284a0d",
      "name": "便签 45",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        2544
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 528,
        "content": "### 2️⃣ 连接 Slack"
      },
      "typeVersion": 1
    },
    {
      "id": "b5b38c6b-459b-47b6-852c-58b3a7f9f43f",
      "name": "获取看板1",
      "type": "n8n-nodes-base.trello",
      "position": [
        -368,
        2752
      ],
      "parameters": {
        "id": {
          "__rl": true,
          "mode": "url",
          "value": "https://trello.com/b/DCpuJbnd/administrative-tasks"
        },
        "resource": "board",
        "operation": "get",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "8de617cc-e356-4414-986c-dc20bf58f672",
      "name": "获取列表1",
      "type": "n8n-nodes-base.trello",
      "position": [
        -304,
        3184
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getAll",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1b518650-0d57-4128-8630-94af9de6ecdc",
      "name": "获取卡片1",
      "type": "n8n-nodes-base.trello",
      "position": [
        -112,
        2800
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getCards",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3351a653-38cb-4b52-80e9-8d73b0c1aaeb",
      "name": "映射字段1",
      "type": "n8n-nodes-base.set",
      "position": [
        64,
        2656
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "3c2613df-a000-4c8e-bd27-2aef696f5ced",
              "name": "Board Name",
              "type": "string",
              "value": "={{ $('Get Board1').item.json.name }}"
            },
            {
              "id": "e4048a3f-d352-4b1f-a76a-4fbf9b74b163",
              "name": "List Name",
              "type": "string",
              "value": "={{ $('Get Lists1').item.json.name }}"
            },
            {
              "id": "d0236a8a-8129-4370-b241-9e27adcb9952",
              "name": "Task Name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "8b6b23c1-1661-4af7-b62d-4facaf0d2651",
              "name": "Task Description",
              "type": "string",
              "value": "={{ $json.desc }}"
            },
            {
              "id": "1bc7f7c2-9121-4059-81e3-7f6962e509cc",
              "name": "Due Date",
              "type": "string",
              "value": "={{ $json.badges.due.trim().substring(0, 10) }}"
            },
            {
              "id": "d6410de8-9d2f-4ef4-9e41-4f5eb6224534",
              "name": "url",
              "type": "string",
              "value": "={{ $json.url }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "c7292203-397b-4acf-90ce-6c7a42bf23cf",
      "name": "便签 46",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        2960
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 352,
        "content": "### 1️⃣ 连接 Trello (开发者 API)"
      },
      "typeVersion": 1
    },
    {
      "id": "2eed1cdb-da3a-4617-af78-7fa8de716213",
      "name": "过滤器",
      "type": "n8n-nodes-base.filter",
      "position": [
        272,
        3168
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "8fa541be-ccd3-4893-836a-10335a45e8bf",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.badges.today }}",
              "rightValue": "={{ $('Map Fields1').item.json['Due Date'] }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "5389e9b4-7d3c-41d7-8b06-0c5f6f42dc2b",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        240,
        2544
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "008dffe5-5b07-43d7-8fbe-2c163ce56fc7",
      "name": "发送消息",
      "type": "n8n-nodes-base.slack",
      "position": [
        544,
        2944
      ],
      "webhookId": "14f651eb-ad60-48fe-aa20-1e96a24be707",
      "parameters": {
        "text": "=Task Due Today: {{ $json.url }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U09ADJPB7QA",
          "cachedResultName": "rbreen672"
        },
        "select": "user",
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "xMo9MC2XXECx5Mqp",
          "name": "Slack account 8"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "f818165d-f36b-49bb-80ae-15a8bb73c436",
      "name": "今日日期",
      "type": "n8n-nodes-base.code",
      "position": [
        -80,
        2528
      ],
      "parameters": {
        "jsCode": "return [\n  {\n    json: {\n      badges: {\n        today: new Date().toISOString().split('T')[0]  \n      }\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    }
  ],
  "pinData": {},
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Board1": {
      "main": [
        [
          {
            "node": "Get Lists1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Cards1": {
      "main": [
        [
          {
            "node": "Map Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Lists1": {
      "main": [
        [
          {
            "node": "Get Cards1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Fields1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Today's Date": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Board1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Today's Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 项目管理, 多模态 AI

需要付费吗?

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

工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
难度说明

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

作者
Robert Breen

Robert Breen

@rbreen

Professional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.

外部链接
在 n8n.io 查看

分享此工作流