从Monday.com到Google Sheets创建每日任务状态快照

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9"
  },
  "nodes": [
    {
      "id": "fafaf19e-d738-481c-b6c7-715c3d2540ca",
      "name": "Sticky Note48",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1840,
        4944
      ],
      "parameters": {
        "color": 7,
        "width": 1248,
        "height": 928,
        "content": "# 📋 Monday.com → Google Sheets 每日任务状态"
      },
      "typeVersion": 1
    },
    {
      "id": "2f7712dd-4e3e-4268-b9c7-252e50d3a85e",
      "name": "字段映射",
      "type": "n8n-nodes-base.set",
      "position": [
        2320,
        5344
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "d0236a8a-8129-4370-b241-9e27adcb9952",
              "name": "Task Name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "4183c1c0-e306-4234-845d-4cb5d0009008",
              "name": "Status",
              "type": "string",
              "value": "={{ $json.column_values[1].text }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "cbe08309-9967-4f39-9cc3-754e69a2a57e",
      "name": "便签57",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        5312
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 448,
        "content": "### 1️⃣ 连接 Monday.com API"
      },
      "typeVersion": 1
    },
    {
      "id": "99184ab6-ac8a-4119-930f-bf0c2079aecc",
      "name": "合并2",
      "type": "n8n-nodes-base.merge",
      "position": [
        2800,
        5200
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "6541e0f5-f179-45e0-a6b8-a0d04055375d",
      "name": "今日日期2",
      "type": "n8n-nodes-base.code",
      "position": [
        2416,
        5104
      ],
      "parameters": {
        "jsCode": "return [\n  {\n    json: {\n      badges: {\n        today: new Date().toISOString().split('T')[0]  \n      }\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "34c78214-269a-4ade-8f7d-a1e41adb1819",
      "name": "便签14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1392,
        4944
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ 设置说明"
      },
      "typeVersion": 1
    },
    {
      "id": "4c139763-0b8b-4f50-8f87-91dd701f91d7",
      "name": "每日进度到表格1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2720,
        5696
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $json.badges.today }}",
            "Name": "={{ $json['Task Name'] }}",
            "Status": "={{ $json.Status }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 876214427,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=876214427",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?usp=drivesdk",
          "cachedResultName": "New Monday Tasks"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "a31b430c-022b-44ed-bd41-218b8fdcd263",
      "name": "获取多个项目2",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        1984,
        5632
      ],
      "parameters": {
        "boardId": "9865886546",
        "groupId": "new_group29179",
        "resource": "boardItem",
        "operation": "getAll"
      },
      "credentials": {
        "mondayComApi": {
          "id": "swmFzbI2ZRBZwzn5",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "8ca935cc-a8ec-44ed-ae8c-08a362730d72",
      "name": "便签26",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2528,
        5424
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 432,
        "content": "### 2️⃣ 准备您的 Google 表格"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Merge2": {
      "main": [
        [
          {
            "node": "Daily Progress to Sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Fields": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Today's Date2": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get many items2": {
      "main": [
        [
          {
            "node": "Map Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}