planeta ai logo
Darmowy szablon automatyzacji

Menedżer duplikatów plików Google Drive

163
25 dni temu
20
bloków

Google Drive Duplicate File Manager 🧹📁

Cel automatyzacji

Automatyzacja procesu wyszukiwania i zarządzania zduplikowanymi plikami w Google Drive.

Dla kogo jest to rozwiązanie?

  • Osoby i zespoły chcące usprawnić organizację plików w Google Drive
  • Każdy, kto chce uniknąć ręcznego czyszczenia duplikatów

Rozwiązywane problemy

  • Oszczędność miejsca w chmurze 💾
  • Eliminacja chaosu spowodowanego duplikatami plików 😕➡️🙂
  • Automatyzacja żmudnych zadań porządkowych 🤖

Jak to działa?

  1. Wyzwalacz: Monitoruje folder w Google Drive pod kątem nowych plików
  2. Konfiguracja: Ustala zasady postępowania z duplikatami
  3. Wyszukiwanie duplikatów: Identyfikuje duplikaty na podstawie zawartości (MD5Checksum)
  4. Akcja: Przenosi duplikaty do kosza lub zmienia ich nazwę

Przewodnik konfiguracji

Wyzwalacz Google Drive ⏰:

  • Skonfiguruj wyzwalacz do monitorowania konkretnego folderu lub całego dysku (uważaj na folder główny! ⚠️)
  • Ustaw interwał sprawdzania (domyślnie: co 15 minut)

Węzeł konfiguracyjny ⚙️:

  • keep: Wybierz czy zachować "pierwszy" czy "ostatni" przesłany plik (domyślnie: "last")
  • action: Wybierz "trash" aby usunąć duplikaty lub "flag" aby dodać przedrostek "DUPLICATE-" (domyślnie: "flag")
  • owner & folder: Pobrane z wyzwalacza. Zmień tylko jeśli potrzebujesz

Ważne uwagi

  • Ograniczenia API Google Drive: Zwróć uwagę na limity użycia API
  • Zakres folderu: Workflow domyślnie obsługuje jeden poziom folderów (OSTRZEŻENIE: Jeśli skonfigurowany do pracy z folderem głównym, wszystkie pliki we wszystkich podfolderach będą przetwarzane)
  • Dokumenty Google: Pliki Google Docs są ignorowane, ponieważ nie są plikami binarnymi i nie można porównać ich zawartości

Przykłady zastosowań

Ta automatyzacja znajduje zastosowanie w wielu scenariuszach, szczególnie tam gdzie ważna jest organizacja plików i oszczędność miejsca:

  • Porządkowanie współdzielonego dysku firmowego po zakończeniu projektu
  • Automatyczne czyszczenie duplikatów zdjęć przesłanych przez wielu członków zespołu
  • Optymalizacja miejsca na dysku przed okresowym archiwizowaniem danych
  • Eliminacja zduplikowanych wersji dokumentów po procesie recenzji i edycji
  • Utrzymanie porządku w folderach z materiałami marketingowymi
  • Automatyczne zarządzanie wielokrotnie przesłanymi plikami w folderze uploadu
  • Przygotowanie czystego środowiska przed rozpoczęciem nowego projektu

Ciesz się czystym Google Drive! ✨

   Skopiuj kod szablonu   
{"meta":{"instanceId":"5e2cdd86a9e1ca2fc82cc63db38d1710d5d6a5c6fe352258a6f7112815bcd512","templateCredsSetupCompleted":true},"nodes":[{"id":"c4dca8f0-98fa-4b06-a806-1ab271f024a2","name":"Config","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":"Edit Fields","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":"Filter","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":"Deduplicate Keep First","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));nnconst seen = {};nfor (const item of sorted) {n const md5 = item.json.md5Checksum;nn // Failsafe: Skip if md5Checksum is missing or emptyn if (!md5) {n item.json.isDuplicate = false; // Mark as not duplicate to avoid issuesn continue; // Skip to the next itemn }nn 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":"Deduplicate Keep Last","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));nnconst seen = {};nfor (const item of sorted) {n const md5 = item.json.md5Checksum;nn // Failsafe: Skip if md5Checksum is missing or emptyn if (!md5) {n item.json.isDuplicate = false; // Mark as not duplicate to avoid issuesn continue; // Skip to the next itemn }nn 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":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[-40,-120],"parameters":{"color":5,"width":440,"height":800,"content":"# 2. ConfigurationnChoose the **keep** and **action** behavior of the workflownn1. The **keep** parameter let's you decide whether to keep the first or last received file when duplicates are detected. (possible values: `first`, `last`. Default: `last`)n2. The **action** parameter let's you decide what to do with the detected duplicates. Send them to the trash or flag them by renaming them with prefix DUPLICATE- (possible values: `trash`, `flag`. Default: `flag`) flag already prexied by DUPLICATE- are not flagged again.nnnThe parameters `owner` and `folder` are taken from the trigger and will probably never need to be changed:n- The **folder** points to the folder to work with. By default it is taken from the trigger.n- The **owner** parameter needs to match the owner of the files. The workflow only works with files owned by this user. It is specified with the user email and is taken from the first file owner of the trigger."},"typeVersion":1},{"id":"67c4d02f-b170-4504-9bae-7bf14db7abd3","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[460,180],"parameters":{"color":7,"width":320,"height":500,"content":"## Working FoldernThe "Working Folder" node let's you choose Files to deduplicate.nnThis workflow includes a filter to work on just 1 folder at depth level 1. It doesn't work with files in nested foldersnnYou can remove the Folder filter to work on the entire drive instead or add different filters."},"typeVersion":1},{"id":"9ed26ef0-da89-43c5-9e12-2ec97b2e51f6","name":"Send Duplicates to Trash","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":"No Operation, do nothing","type":"n8n-nodes-base.noOp","position":[2800,600],"parameters":{},"typeVersion":1},{"id":"de7967e7-eb3b-456c-b12e-6de3165ad29a","name":"Is Flagged","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 Trigger","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/04n"}},"credentials":{"googleDriveOAuth2Api":{"id":"VypmUgEf64twpmiZ","name":"Google Drive account"}},"typeVersion":1},{"id":"22e1638e-5c2e-41bc-b66e-fcee6af05762","name":"Drop Google Apps files","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":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[840,180],"parameters":{"color":7,"width":320,"height":500,"content":"# Discard found Google Apps documentsnDocs, Sheets, Forms, Slides, Drawins etc. are discarded because they are not actual binary files and their content can't be directly checked."},"typeVersion":1},{"id":"66ee766a-3dea-449f-827c-1922c6e053f3","name":"Sticky Note7","type":"n8n-nodes-base.stickyNote","position":[-520,-120],"parameters":{"color":5,"width":440,"height":800,"content":"# 1. Trigger Settings and Working FoldernnWhen using Google Drive Trigger configure the **Poll times** and the **Folder** to work with.nnBy Default the trigger is configured to check for *file uploads* every 15 minutes.nnWhen configured with a specific folder in the drive the workflow works only with files directly in the folder (It will not check/modify files in sub-folders).nnWhen configured with the root (/) folder of the drive it will check all files in all folders and sub-folders so **USE THIS WITH CAUTION** since it might lead to trashing/renaming of important files. "},"typeVersion":1},{"id":"6f8a7855-2ee3-426d-879f-afb303d5aa20","name":"Working Folder","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":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[2500,540],"parameters":{"color":7,"width":540,"height":220,"content":"### Files that already start with *DUPLICATE-* are not flagged again."},"typeVersion":1},{"id":"65b4ba42-89ce-437c-a3e8-bf3f9b01cc21","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[2500,780],"parameters":{"color":7,"width":360,"height":240,"content":"### In Google Drive Trashed files are kept for 30 days before being permanently deleted. nThey can be reviewed and restored during that 30 day interval."},"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":"Keep First/Last","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":"Trash/Flag Duplicates","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}]]}}}
  • cpde
  • Javascript
  • JS
  • Python
  • Script
  • Custom Code
  • Function
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram