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

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a0911000-e46e-4997-bf20-2dcc78a6a00c",
      "name": "Sticky Note63",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        10160
      ],
      "parameters": {
        "color": 7,
        "width": 1488,
        "height": 928,
        "content": "# ✅ Google Sheets to Monday.com Task Creator\n\nThis workflow checks a **Google Sheet** for new tasks (marked `Added = No`) and automatically creates them in a **Monday.com board**.  \nOnce added, the workflow updates the sheet to mark the task as `Added = Yes`.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "17687765-c41a-4418-8b7f-887ab0e3fcdc",
      "name": "Sticky Note21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        10160
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ Setup Instructions\n\n### 1️⃣ Prepare Your Google Sheet\n- Copy this template to your own Google Drive: [Google Sheet Template](https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?gid=876214427#gid=876214427)  \n- First row should contain **column names** \n- Add your data in rows 2–100.  \n- Make sure each new task row starts with `Added = No`.  \n\n#### Connect Google Sheets in n8n\n1. Go to **n8n → Credentials → New → Google Sheets (OAuth2)**  \n2. Log in with your Google account and grant access.  \n3. In the workflow, select your **Spreadsheet ID** and **Worksheet Name**.  \n4. Optional: You can connect Airtable, Notion, or your database instead of Google Sheets.  \n\n---\n\n### 2️⃣ Connect Monday.com Node\n1. In **Monday.com** → go to your **Admin → API**  \n   - Copy your **Personal API Token**  \n   - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication)  \n2. In **n8n** → **Credentials → New → Monday.com API**  \n   - Paste your token and save.  \n3. Open the **Create Monday Task** node → choose your credential → select your **Board ID** and **Group ID**.  \n\n---\n\n## 📬 Contact\nNeed help customizing this (e.g., mapping more fields, syncing statuses, or updating timelines)?  \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": "bbff1f85-e15d-4a49-9e78-5e283939a630",
      "name": "Get new Monday Tasks",
      "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": "Create Monday Task",
      "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": "Mark row as Completed",
      "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": "Sticky Note67",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        10416
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 480,
        "content": "### 2️⃣ Connect Monday.com Node\n1. In **Monday.com** → go to your **Admin → API**  \n   - Copy your **Personal API Token**  \n   - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication)  \n2. In **n8n** → **Credentials → New → Monday.com API**  \n   - Paste your token and save.  \n3. Open the **Create Monday Task** node → choose your credential → select your **Board ID** and **Group ID**.  \n"
      },
      "typeVersion": 1
    },
    {
      "id": "bfb1cf14-2e89-40de-ba2e-1d0a4aec9c6d",
      "name": "Sticky Note24",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1344,
        10592
      ],
      "parameters": {
        "color": 3,
        "width": 512,
        "height": 432,
        "content": "### 1️⃣ Prepare Your Google Sheet\n- Copy this template to your own Google Drive: [Google Sheet Template](https://docs.google.com/spreadsheets/d/1KRiAUbZP77dC_9x5pqrvcQvaAkUsoPXkZOZvfU69ILM/edit?gid=876214427#gid=876214427)  \n- Add your data in rows 2–100.  \n- Make sure each new task row starts with `Added = No`.  \n\n#### Connect Google Sheets in n8n\n1. Go to **n8n → Credentials → New → Google Sheets (OAuth2)**  \n2. Log in with your Google account and grant access.  \n3. In the workflow, select your **Spreadsheet ID** and "
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "6a7a191e-f507-4e7e-8aea-3ca08c03b9d2": {
      "main": [
        []
      ]
    },
    "bbff1f85-e15d-4a49-9e78-5e283939a630": {
      "main": [
        [
          {
            "node": "6a7a191e-f507-4e7e-8aea-3ca08c03b9d2",
            "type": "main",
            "index": 0
          },
          {
            "node": "a4fb3aaa-dcc3-44e9-8724-15ab99a589e6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}