从Google Sheets到Monday.com的自动化任务创建与状态更新

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a0911000-e46e-4997-bf20-2dcc78a6a00c",
      "name": "便签63",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        10160
      ],
      "parameters": {
        "color": 7,
        "width": 1488,
        "height": 928,
        "content": "# ✅ Google Sheets 到 Monday.com 任务创建器"
      },
      "typeVersion": 1
    },
    {
      "id": "17687765-c41a-4418-8b7f-887ab0e3fcdc",
      "name": "便签21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        10160
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ 设置说明"
      },
      "typeVersion": 1
    },
    {
      "id": "bbff1f85-e15d-4a49-9e78-5e283939a630",
      "name": "获取新的 Monday 任务",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1152,
        10880
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "No",
              "lookupColumn": "Added"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "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": "6a7a191e-f507-4e7e-8aea-3ca08c03b9d2",
      "name": "创建 Monday 任务",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        -288,
        10768
      ],
      "parameters": {
        "name": "={{ $json.Task }}",
        "boardId": "9865886546",
        "groupId": "new_group29179",
        "resource": "boardItem",
        "additionalFields": {}
      },
      "credentials": {
        "mondayComApi": {
          "id": "swmFzbI2ZRBZwzn5",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a4fb3aaa-dcc3-44e9-8724-15ab99a589e6",
      "name": "将行标记为已完成",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -720,
        10432
      ],
      "parameters": {
        "columns": {
          "value": {
            "Task": "={{ $json.Task }}",
            "Added": "Yes"
          },
          "schema": [
            {
              "id": "Task",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Task",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Added",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Added",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Task"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "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": "c40bab9e-f109-4c4a-a460-c87e6c10ec36",
      "name": "便签67",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        10416
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 480,
        "content": "### 2️⃣ 连接 Monday.com 节点"
      },
      "typeVersion": 1
    },
    {
      "id": "bfb1cf14-2e89-40de-ba2e-1d0a4aec9c6d",
      "name": "便签24",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1344,
        10592
      ],
      "parameters": {
        "color": 3,
        "width": 512,
        "height": 432,
        "content": "### 1️⃣ 准备您的 Google Sheet"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Create Monday Task": {
      "main": [
        []
      ]
    },
    "Get new Monday Tasks": {
      "main": [
        [
          {
            "node": "Create Monday Task",
            "type": "main",
            "index": 0
          },
          {
            "node": "Mark row as Completed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}