8
n8n 中文网amn8n.com

每日 Trello 任务追踪器与 Google Sheets 历史记录

中级

这是一个Project Management, Multimodal AI领域的自动化工作流，包含 11 个节点。主要使用 Set, Code, Merge, Trello, GoogleSheets 等节点。 每日 Trello 任务追踪器与 Google Sheets 历史记录

前置要求
  • •Google Sheets API 凭证

使用的节点 (11)

Set
Code
Merge
Trello
StickyNote
GoogleSheets
ScheduleTrigger

分类

项目管理
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "299e3c15-7a6f-4c92-9c1d-2cb763e62a9d",
      "name": "Sticky Note47",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        3312
      ],
      "parameters": {
        "color": 7,
        "width": 1248,
        "height": 928,
        "content": "# 📋 Trello → Google Sheets 每日任务状态"
      },
      "typeVersion": 1
    },
    {
      "id": "df25de48-0aac-4a7e-af2e-e61be0ebc369",
      "name": "获取看板2",
      "type": "n8n-nodes-base.trello",
      "position": [
        -128,
        3728
      ],
      "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": "e2311a05-aeb5-4039-a11a-934f94ba4d72",
      "name": "获取列表2",
      "type": "n8n-nodes-base.trello",
      "position": [
        144,
        4016
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getAll",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "592ae7d6-c757-41dd-b3ce-68811803f9bc",
      "name": "获取卡片2",
      "type": "n8n-nodes-base.trello",
      "position": [
        368,
        3584
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getCards",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e5ca7c3b-97d4-4e01-b022-de796a9b69cd",
      "name": "映射字段2",
      "type": "n8n-nodes-base.set",
      "position": [
        544,
        3808
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "3c2613df-a000-4c8e-bd27-2aef696f5ced",
              "name": "Board Name",
              "type": "string",
              "value": "={{ $('Get Board2').item.json.name }}"
            },
            {
              "id": "e4048a3f-d352-4b1f-a76a-4fbf9b74b163",
              "name": "List Name",
              "type": "string",
              "value": "={{ $('Get Lists2').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": "1f7b1c4f-a63c-4fed-ab02-dde5d79465ae",
      "name": "便签49",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        3792
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 352,
        "content": "### 1️⃣ 连接 Trello (开发者 API)"
      },
      "typeVersion": 1
    },
    {
      "id": "426d15b6-107b-417d-9508-a5985be97015",
      "name": "合并1",
      "type": "n8n-nodes-base.merge",
      "position": [
        784,
        3824
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "9291c303-4098-466e-a0ac-7284c0240e5b",
      "name": "今日日期1",
      "type": "n8n-nodes-base.code",
      "position": [
        800,
        3408
      ],
      "parameters": {
        "jsCode": "return [\n  {\n    json: {\n      badges: {\n        today: new Date().toISOString().split('T')[0]  \n      }\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "40e6b69d-3300-4f7c-9cb7-d294a45e3bd1",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        3312
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "457f6ed8-42ad-433c-9df6-db372b47d518",
      "name": "由 Github 模型提供支持",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        3456
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "31096032-6f0b-4b31-bb07-ac895aff193e",
      "name": "每日进度到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        800,
        4064
      ],
      "parameters": {
        "columns": {
          "value": {
            "url": "={{ $json.url }}",
            "Date": "={{ $('Today\\'s Date1').item.json.badges.today }}",
            "Due Date": "={{ $json['Due Date'] }}",
            "List Name": "={{ $json['List Name'] }}",
            "Task Name": "={{ $json['Task Name'] }}",
            "Task Description": "={{ $json['Task Description'] }}"
          },
          "schema": [
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "List Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "List Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Task Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Task Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Task Description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Task Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Due Date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Due Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yAdFAsq38OTtZ52jJV2m9LpzGQH-PQmCW-ZPPBF3AAg/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1yAdFAsq38OTtZ52jJV2m9LpzGQH-PQmCW-ZPPBF3AAg",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yAdFAsq38OTtZ52jJV2m9LpzGQH-PQmCW-ZPPBF3AAg/edit?usp=drivesdk",
          "cachedResultName": "Trello Progress"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    }
  ],
  "pinData": {},
  "connections": {
    "Merge1": {
      "main": [
        [
          {
            "node": "Daily Progress to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Board2": {
      "main": [
        [
          {
            "node": "Get Lists2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Cards2": {
      "main": [
        [
          {
            "node": "Map Fields2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Lists2": {
      "main": [
        [
          {
            "node": "Get Cards2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Fields2": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Today's Date1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Board2",
            "type": "main",
            "index": 0
          },
          {
            "node": "Today's Date1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

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

需要付费吗？

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

相关工作流推荐

从Monday.com到Google Sheets创建每日任务状态快照
从Monday.com到Google Sheets创建每日任务状态快照
Set
Code
Merge
+3
9 节点Robert Breen
项目管理
每日 Trello 任务截止日期摘要发送至 Slack
每日 Trello 任务截止日期摘要发送至 Slack
Set
Code
Merge
+5
13 节点Robert Breen
项目管理
AI生成LinkedIn帖子含人工审批
使用GPT-4、GoToHuman和Blotato的AI生成LinkedIn帖子含人工审批
Code
Merge
Filter
+10
19 节点Robert Breen
社交媒体
每日广告支出监控：Google表格和Slack阈值提醒
使用Google表格和Slack阈值提醒的每日广告支出监控
If
Set
Code
+7
13 节点Robert Breen
内容创作
在Google Sheets中跟踪Pipedrive交易用于销售管道报告
在Google Sheets中跟踪Pipedrive交易用于销售管道报告
Set
Code
Merge
+4
11 节点Robert Breen
客户关系管理
播客笔记记录器
使用GPT和Gemini结合性能数据创建高转化率Meta广告脚本
Set
Code
Merge
+7
24 节点Robert Breen
文档提取
工作流信息
难度等级
中级
节点数量11
分类2
节点类型7
难度说明

适合有一定经验的用户，包含 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 查看 →

分享此工作流