Google Drive重复文件管理器
高级
这是一个Other领域的自动化工作流，包含 20 个节点。主要使用 If, Set, Code, Filter, Switch 等节点。 Google Drive重复文件管理器
前置要求
- •Google Drive API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "5e2cdd86a9e1ca2fc82cc63db38d1710d5d6a5c6fe352258a6f7112815bcd512",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "c4dca8f0-98fa-4b06-a806-1ab271f024a2",
"name": "配置",
"type": "n8n-nodes-base.set",
"position": [
120,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a916dcbd-d681-4e09-9ce9-0f50a1b4290b",
"name": "keep",
"type": "string",
"value": "=last"
},
{
"id": "949a2f76-5981-4fd2-9665-b10db26e2f48",
"name": "action",
"type": "string",
"value": "=flag"
},
{
"id": "7f4502b4-c330-4c9c-ab89-ba53874aafbb",
"name": "owner",
"type": "string",
"value": "={{ $json.owner || $json.owners[0].emailAddress }}"
},
{
"id": "592eb79e-28db-4470-8347-36b2a661cb03",
"name": "folder",
"type": "string",
"value": "={{ $json.folder || $json.parents[0]}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2562ed4a-8ecd-4a32-ae51-bc85daa9817b",
"name": "获取简报",
"type": "n8n-nodes-base.set",
"position": [
1800,
440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "1d28f976-2467-4d18-8698-556d29a5f8c0",
"name": "isDuplicate",
"type": "boolean",
"value": "={{ $json.isDuplicate }}"
},
{
"id": "e9d8eb20-7668-4287-bfb4-d4f66c019f73",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "587e5f8e-bd94-4ec5-80f2-066c99922135",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e7f0482c-77c7-46a0-8a36-e61bb624c422",
"name": "筛选",
"type": "n8n-nodes-base.filter",
"position": [
2020,
440
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bd33247c-4c88-4c0b-bdfe-6f9dca0205e3",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.isDuplicate }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "28768732-29a4-4446-8b12-dda187976bf9",
"name": "去重保留首个",
"type": "n8n-nodes-base.code",
"position": [
1580,
560
],
"parameters": {
"jsCode": "// Sort files by creation time (oldest first)\nconst sorted = items.sort((a, b) => \n new Date(a.json.createdTime) - new Date(b.json.createdTime));\n\nconst seen = {};\nfor (const item of sorted) {\n const md5 = item.json.md5Checksum;\n\n // Failsafe: Skip if md5Checksum is missing or empty\n if (!md5) {\n item.json.isDuplicate = false; // Mark as not duplicate to avoid issues\n continue; // Skip to the next item\n }\n\n item.json.isDuplicate = md5 in seen;\n if (!item.json.isDuplicate) seen[md5] = true;\n}\nreturn items;"
},
"executeOnce": false,
"typeVersion": 2
},
{
"id": "1f6f9529-2283-4806-ad5a-b0425f9f68e2",
"name": "去重保留末个",
"type": "n8n-nodes-base.code",
"position": [
1580,
360
],
"parameters": {
"jsCode": "// Sort files by creation time (latest first)\nconst sorted = items.sort((a, b) => \n new Date(b.json.createdTime) - new Date(a.json.createdTime));\n\nconst seen = {};\nfor (const item of sorted) {\n const md5 = item.json.md5Checksum;\n\n // Failsafe: Skip if md5Checksum is missing or empty\n if (!md5) {\n item.json.isDuplicate = false; // Mark as not duplicate to avoid issues\n continue; // Skip to the next item\n }\n\n if (md5 in seen) {\n item.json.isDuplicate = true;\n } else {\n item.json.isDuplicate = false;\n seen[md5] = true;\n }\n}\nreturn items;"
},
"executeOnce": false,
"typeVersion": 2
},
{
"id": "c5250dd1-6eeb-4b89-b2e7-e44a8d88212c",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-120
],
"parameters": {
"color": 5,
"width": 440,
"height": 800,
"content": "# 2. 配置"
},
"typeVersion": 1
},
{
"id": "67c4d02f-b170-4504-9bae-7bf14db7abd3",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
180
],
"parameters": {
"color": 7,
"width": 320,
"height": 500,
"content": "## 工作文件夹"
},
"typeVersion": 1
},
{
"id": "9ed26ef0-da89-43c5-9e12-2ec97b2e51f6",
"name": "将重复文件移至回收站",
"type": "n8n-nodes-base.googleDrive",
"position": [
2760,
320
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "deleteFile"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "VypmUgEf64twpmiZ",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "fcfd08fa-7a19-4974-b3bb-6ed27a2030cf",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
2800,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "de7967e7-eb3b-456c-b12e-6de3165ad29a",
"name": "已标记",
"type": "n8n-nodes-base.if",
"position": [
2540,
620
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c8d8eac5-e03a-4673-bcf9-a8acaa95cb8e",
"operator": {
"type": "string",
"operation": "startsWith"
},
"leftValue": "={{ $('Trash/Flag Duplicates').item.json.name }}",
"rightValue": "DUPLICATE-"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d227d6ee-97e7-4b4d-b1a2-4cd402be99d5",
"name": "Google Drive 触发器",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-360,
460
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyX",
"unit": "minutes",
"value": 15
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1-tjf96Ooj0SL8qaE04BGIeCGnd-O1R8c",
"cachedResultUrl": "https://drive.google.com/drive/folders/1-tjf96Ooj0SL8qaE04BGIeCGnd-O1R8c",
"cachedResultName": "2025/04\n"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "VypmUgEf64twpmiZ",
"name": "Google Drive account"
}
},
"typeVersion": 1
},
{
"id": "22e1638e-5c2e-41bc-b66e-fcee6af05762",
"name": "丢弃 Google 应用文件",
"type": "n8n-nodes-base.filter",
"position": [
940,
460
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1e7d9666-fba0-4fe7-b03a-1a4e5c07b389",
"operator": {
"type": "string",
"operation": "notStartsWith"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "application/vnd.google-apps"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "ec80f4de-5dff-4693-bff4-2509fd581d70",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
180
],
"parameters": {
"color": 7,
"width": 320,
"height": 500,
"content": "# 丢弃找到的 Google 应用文档"
},
"typeVersion": 1
},
{
"id": "66ee766a-3dea-449f-827c-1922c6e053f3",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-120
],
"parameters": {
"color": 5,
"width": 440,
"height": 800,
"content": "# 1. 触发器设置和工作文件夹"
},
"typeVersion": 1
},
{
"id": "6f8a7855-2ee3-426d-879f-afb303d5aa20",
"name": "工作文件夹",
"type": "n8n-nodes-base.googleDrive",
"position": [
560,
460
],
"parameters": {
"filter": {
"folderId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Config').item.json.folder }}"
},
"whatToSearch": "files"
},
"options": {
"fields": [
"*"
]
},
"resource": "fileFolder",
"returnAll": true,
"queryString": "='{{$('Config').item.json.owner}}' in owners",
"searchMethod": "query"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "VypmUgEf64twpmiZ",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "6f69e6d3-96ca-4411-9a48-160ebdb2a273",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2500,
540
],
"parameters": {
"color": 7,
"width": 540,
"height": 220,
"content": "### 已以 *DUPLICATE-* 开头的文件不会重复标记"
},
"typeVersion": 1
},
{
"id": "65b4ba42-89ce-437c-a3e8-bf3f9b01cc21",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2500,
780
],
"parameters": {
"color": 7,
"width": 360,
"height": 240,
"content": "### 在 Google Drive 中，移至回收站的文件会保留30天后才被永久删除"
},
"typeVersion": 1
},
{
"id": "99374aa8-e597-4919-8b64-c376b246621a",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
2880,
800
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "update",
"newUpdatedFileName": "=DUPLICATE-{{ $json.name }}"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "VypmUgEf64twpmiZ",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "6ae62c31-4cf0-48e7-aa42-19fc259c5981",
"name": "保留首个/末个",
"type": "n8n-nodes-base.switch",
"position": [
1300,
460
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "last",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7f5ba21d-8f3d-4736-9c34-ac7ebd6a9699",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Config').item.json.keep }}",
"rightValue": "last"
}
]
},
"renameOutput": true
},
{
"outputKey": "first",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "93a013f6-6c59-47ad-bce3-8b34cc8f026c",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Config').item.json.keep }}",
"rightValue": "first"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "9cb84da7-3cd9-4a53-af09-8b63f1cf8a34",
"name": "移至回收站/标记重复文件",
"type": "n8n-nodes-base.switch",
"position": [
2240,
440
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "send to trash",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0314ac48-e7b7-406b-abcd-8cd1ab872c79",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Config').item.json.action }}",
"rightValue": "trash"
}
]
},
"renameOutput": true
},
{
"outputKey": "flag as duplicate",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "70d8e5f1-16a6-4921-ad9c-ab00049e507d",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Config').item.json.action }}",
"rightValue": "flag"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
}
],
"pinData": {},
"connections": {
"Config": {
"main": [
[
{
"node": "Working Folder",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Trash/Flag Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Is Flagged": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Working Folder": {
"main": [
[
{
"node": "Drop Google Apps files",
"type": "main",
"index": 0
}
]
]
},
"Keep First/Last": {
"main": [
[
{
"node": "Deduplicate Keep Last",
"type": "main",
"index": 0
}
],
[
{
"node": "Deduplicate Keep First",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Config",
"type": "main",
"index": 0
}
]
]
},
"Deduplicate Keep Last": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Trash/Flag Duplicates": {
"main": [
[
{
"node": "Send Duplicates to Trash",
"type": "main",
"index": 0
}
],
[
{
"node": "Is Flagged",
"type": "main",
"index": 0
}
]
]
},
"Deduplicate Keep First": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Drop Google Apps files": {
"main": [
[
{
"node": "Keep First/Last",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
Google上传至YouTube
自动化音乐视频创建与YouTube发布，含AI生成的Google Drive元数据
If
Set
Code
+13
73 节点danejw
其他
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用AI汇总Slack频道活动生成周报
使用AI汇总Slack频道活动生成周报
If
Set
Code
+13
47 节点Jimleuk
其他
按公司整理邮件附件到Google Drive文件夹
使用Gmail和表格按公司整理邮件附件到Google Drive文件夹
If
Set
Gmail
+6
19 节点Ventsislav Minev
其他
