📂 OneDrive到Excel财务数据自动同步

• •无特殊前置要求，导入即可使用

{
  "meta": {
    "instanceId": "6045c639951d83c8706b0dd8d6330164bda01fe58f103cedc2c276bf1f9c11f1"
  },
  "nodes": [
    {
      "id": "fc4361c6-494a-4962-9488-2fe8dda1948c",
      "name": "如果在监视文件夹中有新文件则触发",
      "type": "n8n-nodes-base.microsoftOneDriveTrigger",
      "position": [
        -400,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7e914111-ed3b-42c1-9461-5d36739db2b3",
      "name": "非 CSV",
      "type": "n8n-nodes-base.stopAndError",
      "position": [
        520,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "43f092fe-9bc5-4e5f-a80b-db8aae53c9af",
      "name": "从 CSV 提取数据",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        520,
        260
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "142f14e7-663f-4225-8e58-551c1e089450",
      "name": "Microsoft OneDrive2",
      "type": "n8n-nodes-base.microsoftOneDrive",
      "onError": "continueErrorOutput",
      "position": [
        1300,
        260
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "4d62251b-9a0d-4426-bf31-6fab04a645a7",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "48186060-343b-458c-bf2e-a5df501445e2",
      "name": "清理输出",
      "type": "n8n-nodes-base.code",
      "position": [
        740,
        260
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 2
    },
    {
      "id": "5914197f-f217-447b-acab-b149f70b11ab",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        660,
        5.929829979644694
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c2d9e3a4-b9de-4b25-a06d-49d30402dab0",
      "name": "无操作，不执行任何动作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1540,
        280
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8d65a94e-3946-4586-ad65-15f765f1b38c",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1500,
        80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d2e0d8d2-f62a-4831-be0c-049d735c1fd5",
      "name": "在表格中记录更新",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        -220,
        380
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "ff21f07d-7b6a-46cc-87db-2a3fdcd9614f",
      "name": "获取新文件信息",
      "type": "n8n-nodes-base.microsoftOneDrive",
      "position": [
        -40,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7cfa40a4-f3c9-464f-83d4-1eea2a869c75",
      "name": "下载新文件",
      "type": "n8n-nodes-base.microsoftOneDrive",
      "position": [
        160,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e936a8ec-5544-4d13-9dca-747983ab7e50",
      "name": "检查是否为 CSV 格式",
      "type": "n8n-nodes-base.if",
      "position": [
        340,
        380
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f5b24101-4cb9-4a4a-be33-9b6191e20401",
      "name": "准备要放入 Excel 表格的字段",
      "type": "n8n-nodes-base.set",
      "position": [
        940,
        260
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "47793366-1655-4322-ba74-14a5b31b03e8",
      "name": "更新 Excel 表格",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        1120,
        260
      ],
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "pinData": {},
  "connections": {
    "Cleans the output": {
      "main": [
        [
          {
            "node": "Prepares the fields to put in the excel table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Microsoft OneDrive2": {
      "main": [
        null,
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Downloads the new file": {
      "main": [
        [
          {
            "node": "Checks if it's CSV format",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extracts data from csv": {
      "main": [
        [
          {
            "node": "Cleans the output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gets the new file infos": {
      "main": [
        [
          {
            "node": "Downloads the new file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Updates the excel table": {
      "main": [
        [
          {
            "node": "Microsoft OneDrive2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Logs the update on sheet": {
      "main": [
        [
          {
            "node": "Gets the new file infos",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Checks if it's CSV format": {
      "main": [
        [
          {
            "node": "Extracts data from csv",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Not CSV",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Triggers if new file in watched folder": {
      "main": [
        [
          {
            "node": "Logs the update on sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepares the fields to put in the excel table": {
      "main": [
        [
          {
            "node": "Updates the excel table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}