毎日のTrelloタスク追踪器とGoogle Sheetsの履歴
中級
これはProject Management, Multimodal AI分野の自動化ワークフローで、11個のノードを含みます。主にSet, Code, Merge, Trello, GoogleSheetsなどのノードを使用。 毎日の Trello タスク追跡と Google スプシ履歴
前提条件
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "299e3c15-7a6f-4c92-9c1d-2cb763e62a9d",
"name": "付箋47",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
3312
],
"parameters": {
"color": 7,
"width": 1248,
"height": 928,
"content": "# 📋 Trello → Google Sheets Daily Task Status\n\nThis workflow **pulls all tasks from your Trello board** every day and logs them into a **Google Sheet**. \nUse it to track project progress, due dates, and keep a daily snapshot of your board’s status.\n\n"
},
"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️⃣ Connect Trello (Developer API)\n1. Get your **API key**: https://trello.com/app-key \n2. Generate a **token** (from the same page → **Token**)\n3. In n8n → **Credentials → New → Trello API**, paste **API Key** and **Token**, save. "
},
"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": "\n## ⚙️ Setup Instructions\n\n### 1️⃣ Connect Trello (Developer API)\n1. Get your **API key**: [Trello App Key](https://trello.com/app-key) \n2. On the same page, generate a **Token** (click **Token**) \n3. In **n8n** → **Credentials → New → Trello API**, paste your **API Key** + **Token**, then save. \n4. Open each Trello node (**Get Board**, **Get Lists**, **Get Cards**) and select your Trello credential. \n\n---\n\n## 🧠 How It Works\n- **Schedule Trigger**: Runs daily (can be customized). \n- **Get Board → Get Lists → Get Cards**: Pulls every task, its list, due date, and description. \n- **Map Fields**: Normalizes the data (board name, list name, task name, description, due date, URL). \n- **Today's Date Node**: Adds a timestamp column so each run is logged. \n- **Google Sheets (Append)**: Appends all task rows into a sheet → creating a **daily history log**.\n\n---\n\n## 📬 Contact\nNeed help customizing this (e.g., filtering by list, or sending reports by email/Slack)? \n\n📧 **robert@ynteractive.com** \n🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** \n🌐 **[ynteractive.com](https://ynteractive.com)**\n"
},
"typeVersion": 1
},
{
"id": "457f6ed8-42ad-433c-9df6-db372b47d518",
"name": "スケジュールトリガー",
"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": {
"426d15b6-107b-417d-9508-a5985be97015": {
"main": [
[
{
"node": "31096032-6f0b-4b31-bb07-ac895aff193e",
"type": "main",
"index": 0
}
]
]
},
"df25de48-0aac-4a7e-af2e-e61be0ebc369": {
"main": [
[
{
"node": "e2311a05-aeb5-4039-a11a-934f94ba4d72",
"type": "main",
"index": 0
}
]
]
},
"592ae7d6-c757-41dd-b3ce-68811803f9bc": {
"main": [
[
{
"node": "e5ca7c3b-97d4-4e01-b022-de796a9b69cd",
"type": "main",
"index": 0
}
]
]
},
"e2311a05-aeb5-4039-a11a-934f94ba4d72": {
"main": [
[
{
"node": "592ae7d6-c757-41dd-b3ce-68811803f9bc",
"type": "main",
"index": 0
}
]
]
},
"e5ca7c3b-97d4-4e01-b022-de796a9b69cd": {
"main": [
[
{
"node": "426d15b6-107b-417d-9508-a5985be97015",
"type": "main",
"index": 1
}
]
]
},
"9291c303-4098-466e-a0ac-7284c0240e5b": {
"main": [
[
{
"node": "426d15b6-107b-417d-9508-a5985be97015",
"type": "main",
"index": 0
}
]
]
},
"457f6ed8-42ad-433c-9df6-db372b47d518": {
"main": [
[
{
"node": "df25de48-0aac-4a7e-af2e-e61be0ebc369",
"type": "main",
"index": 0
},
{
"node": "9291c303-4098-466e-a0ac-7284c0240e5b",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - プロジェクト管理, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Monday.com から Google Sheets へ每日のタスクステータスをスナップショット作成
Monday.comからGoogle Sheetsへ毎日のタスクステータスをスナップショットで作成
Set
Code
Merge
+
Set
Code
Merge
9 ノードRobert Breen
プロジェクト管理
毎日のSlackへTrelloタスクの締切サマリーを送信
毎日、Trello のタスク期限を Slack に送信
Set
Code
Merge
+
Set
Code
Merge
13 ノードRobert Breen
プロジェクト管理
AI生成LinkedIn投稿（人間による承認付き）
GPT-4、GoToHuman、Blotatoを使用したAI生成LinkedIn投稿（人間による承認付き）
Code
Merge
Filter
+
Code
Merge
Filter
19 ノードRobert Breen
ソーシャルメディア
広告費用毎日監視：GoogleスプレッドシートとSlackのスレショルド通知
GoogleシートとSlackの閾値アラートによる広告費用の監視（毎日）
If
Set
Code
+
If
Set
Code
13 ノードRobert Breen
コンテンツ作成
ポッドキャストのノート記録器
GPTとGeminiを使用してパフォーマンスデータと結合して、高転化率のMeta広告スクリプトを作成
Set
Code
Merge
+
Set
Code
Merge
24 ノードRobert Breen
文書抽出
ポッドキャストのノート記録器
GPTとGeminiを使用してパフォーマンスデータと結合して、高転化率のMeta広告スクリプトを作成
Set
Code
Merge
+
Set
Code
Merge
16 ノードRobert Breen
リード獲得
ワークフロー情報
難易度
中級
ノード数11
カテゴリー2
ノードタイプ7
作成者
Robert Breen
@rbreenProfessional 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で表示 →
このワークフローを共有