📂 OneDrive到Excel财务数据自动同步
中级
这是一个Finance领域的自动化工作流，包含 15 个节点。主要使用 If, Set, Code, StopAndError, MicrosoftExcel 等节点。 📂 OneDrive到Excel财务数据自动同步
前置要求
- •无特殊前置要求，导入即可使用
使用的节点 (15)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "6045c639951d83c8706b0dd8d6330164bda01fe58f103cedc2c276bf1f9c11f1"
},
"nodes": [
{
"id": "fc4361c6-494a-4962-9488-2fe8dda1948c",
"name": "Triggers if new file in watched folder",
"type": "n8n-nodes-base.microsoftOneDriveTrigger",
"position": [
-400,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7e914111-ed3b-42c1-9461-5d36739db2b3",
"name": "Not CSV",
"type": "n8n-nodes-base.stopAndError",
"position": [
520,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "43f092fe-9bc5-4e5f-a80b-db8aae53c9af",
"name": "Extracts data from 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": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "48186060-343b-458c-bf2e-a5df501445e2",
"name": "Cleans the output",
"type": "n8n-nodes-base.code",
"position": [
740,
260
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2
},
{
"id": "5914197f-f217-447b-acab-b149f70b11ab",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
5.929829979644694
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c2d9e3a4-b9de-4b25-a06d-49d30402dab0",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
1540,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8d65a94e-3946-4586-ad65-15f765f1b38c",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1500,
80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d2e0d8d2-f62a-4831-be0c-049d735c1fd5",
"name": "Logs the update on sheet",
"type": "n8n-nodes-base.microsoftExcel",
"position": [
-220,
380
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "ff21f07d-7b6a-46cc-87db-2a3fdcd9614f",
"name": "Gets the new file infos",
"type": "n8n-nodes-base.microsoftOneDrive",
"position": [
-40,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7cfa40a4-f3c9-464f-83d4-1eea2a869c75",
"name": "Downloads the new file",
"type": "n8n-nodes-base.microsoftOneDrive",
"position": [
160,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e936a8ec-5544-4d13-9dca-747983ab7e50",
"name": "Checks if it's CSV format",
"type": "n8n-nodes-base.if",
"position": [
340,
380
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f5b24101-4cb9-4a4a-be33-9b6191e20401",
"name": "Prepares the fields to put in the excel table",
"type": "n8n-nodes-base.set",
"position": [
940,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "47793366-1655-4322-ba74-14a5b31b03e8",
"name": "Updates the excel table",
"type": "n8n-nodes-base.microsoftExcel",
"position": [
1120,
260
],
"parameters": {},
"typeVersion": 2.1
}
],
"pinData": {},
"connections": {
"48186060-343b-458c-bf2e-a5df501445e2": {
"main": [
[
{
"node": "f5b24101-4cb9-4a4a-be33-9b6191e20401",
"type": "main",
"index": 0
}
]
]
},
"142f14e7-663f-4225-8e58-551c1e089450": {
"main": [
null,
[
{
"node": "c2d9e3a4-b9de-4b25-a06d-49d30402dab0",
"type": "main",
"index": 0
}
]
]
},
"7cfa40a4-f3c9-464f-83d4-1eea2a869c75": {
"main": [
[
{
"node": "e936a8ec-5544-4d13-9dca-747983ab7e50",
"type": "main",
"index": 0
}
]
]
},
"43f092fe-9bc5-4e5f-a80b-db8aae53c9af": {
"main": [
[
{
"node": "48186060-343b-458c-bf2e-a5df501445e2",
"type": "main",
"index": 0
}
]
]
},
"ff21f07d-7b6a-46cc-87db-2a3fdcd9614f": {
"main": [
[
{
"node": "7cfa40a4-f3c9-464f-83d4-1eea2a869c75",
"type": "main",
"index": 0
}
]
]
},
"47793366-1655-4322-ba74-14a5b31b03e8": {
"main": [
[
{
"node": "142f14e7-663f-4225-8e58-551c1e089450",
"type": "main",
"index": 0
}
]
]
},
"d2e0d8d2-f62a-4831-be0c-049d735c1fd5": {
"main": [
[
{
"node": "ff21f07d-7b6a-46cc-87db-2a3fdcd9614f",
"type": "main",
"index": 0
}
]
]
},
"e936a8ec-5544-4d13-9dca-747983ab7e50": {
"main": [
[
{
"node": "43f092fe-9bc5-4e5f-a80b-db8aae53c9af",
"type": "main",
"index": 0
}
],
[
{
"node": "7e914111-ed3b-42c1-9461-5d36739db2b3",
"type": "main",
"index": 0
}
]
]
},
"fc4361c6-494a-4962-9488-2fe8dda1948c": {
"main": [
[
{
"node": "d2e0d8d2-f62a-4831-be0c-049d735c1fd5",
"type": "main",
"index": 0
}
]
]
},
"f5b24101-4cb9-4a4a-be33-9b6191e20401": {
"main": [
[
{
"node": "47793366-1655-4322-ba74-14a5b31b03e8",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 财务
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用AI将PDF采购订单自动化转换为Adobe Commerce销售订单
使用AI将PDF采购订单自动化转换为Adobe Commerce销售订单
If
Set
Code
+
If
Set
Code
96 节点JKingma
文档提取
会议反馈收集与Excel OneDrive记录及Outlook通知
通过表单收集会议反馈，记录到Excel OneDrive，并发送Outlook通知
If
Set
Code
+
If
Set
Code
13 节点Akhil Varma Gadiraju
营销
使用 Google Gemini AI 生成财经新闻摘要并发送至 Outlook 邮箱
通过 Google Gemini AI 生成财经新闻摘要并发送至 Outlook 邮箱
Set
Code
Aggregate
+
Set
Code
Aggregate
18 节点Louis
财务
ERPNext AI候选人筛选自动化
ERPNext的AI驱动候选人筛选自动化
If
Set
Code
+
If
Set
Code
39 节点Amjid Ali
财务
AI 驱动的股市摘要机器人
AI 驱动的股市摘要机器人
If
Set
Code
+
If
Set
Code
21 节点kenandrewmiranda
财务
(Tung) OCR发票提取到电子表格副本
自动发票和收据OCR到Google表格 - 支持云端硬盘、Gmail和Telegram触发
If
Set
Code
+
If
Set
Code
25 节点Daniel Ng
财务
