从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 Daily Task Status  \n\nThis workflow pulls all tasks from your **Monday.com board** each day and logs them into a **Google Sheet**.  \nIt creates a daily snapshot of your project’s progress and statuses.  \n\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "2f7712dd-4e3e-4268-b9c7-252e50d3a85e",
      "name": "Map Fields",
      "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": "Sticky Note57",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1920,
        5312
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 448,
        "content": "### 1️⃣ Connect Monday.com API  \n1. In **Monday.com** → go to **Admin → API**  \n2. Copy your **Personal API Token**  \n   - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication)  \n3. In **n8n → Credentials → New → Monday.com API** → paste your token and save  \n"
      },
      "typeVersion": 1
    },
    {
      "id": "99184ab6-ac8a-4119-930f-bf0c2079aecc",
      "name": "Merge2",
      "type": "n8n-nodes-base.merge",
      "position": [
        2800,
        5200
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "6541e0f5-f179-45e0-a6b8-a0d04055375d",
      "name": "Today's Date2",
      "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": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1392,
        4944
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ Setup Instructions  \n\n### 1️⃣ Connect Monday.com API  \n1. In **Monday.com** → go to **Admin → API**  \n2. Copy your **Personal API Token**  \n   - Docs: [Generate Monday API Token](https://developer.monday.com/api-reference/docs/authentication)  \n3. In **n8n → Credentials → New → Monday.com API** → paste your token and save  \n\n---\n\n### 2️⃣ 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 the correct **Sheet Name**  \n\n\n\n## 📬 Contact  \nNeed help customizing this (e.g., filtering by status, emailing daily reports, or adding charts)?  \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": "4c139763-0b8b-4f50-8f87-91dd701f91d7",
      "name": "Daily Progress to Sheet1",
      "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": "Get many items2",
      "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": "Sticky Note26",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2528,
        5424
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 432,
        "content": "### 2️⃣ 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 the correct **Sheet Name**.  \n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "99184ab6-ac8a-4119-930f-bf0c2079aecc": {
      "main": [
        [
          {
            "node": "4c139763-0b8b-4f50-8f87-91dd701f91d7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2f7712dd-4e3e-4268-b9c7-252e50d3a85e": {
      "main": [
        [
          {
            "node": "99184ab6-ac8a-4119-930f-bf0c2079aecc",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "6541e0f5-f179-45e0-a6b8-a0d04055375d": {
      "main": [
        [
          {
            "node": "99184ab6-ac8a-4119-930f-bf0c2079aecc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a31b430c-022b-44ed-bd41-218b8fdcd263": {
      "main": [
        [
          {
            "node": "2f7712dd-4e3e-4268-b9c7-252e50d3a85e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}