n8n templatesn8n templates

Google Drive Duplicate File Auto-Management Workflow

This workflow is designed to automatically manage duplicate files in Google Drive by regularly monitoring specified folders to automatically detect and handle duplicates. Users can choose to keep either the most recent or the earliest uploaded file and decide how to handle duplicate files (move to trash or rename). At the same time, the system will automatically exclude Google Apps format files to ensure efficient cleaning of actual binary files, reduce storage space waste, lower the risk of accidental deletion, and enhance the convenience of file management.

Workflow Diagram
Google Drive Duplicate File Auto-Management Workflow Workflow diagram

Workflow Name

Google Drive Duplicate File Auto-Management Workflow

Key Features and Highlights

This workflow automatically detects duplicate files within specified Google Drive folders and processes them based on user-defined configurations. It supports two retention strategies (keep the earliest uploaded file or keep the latest uploaded file) and two duplicate file handling methods (move duplicates directly to Trash or rename duplicates with a “DUPLICATE-” prefix). Additionally, the workflow automatically excludes Google Apps format files (such as Docs, Sheets, etc.) to ensure only actual binary files are processed.

Core Problems Addressed

This workflow helps users efficiently manage duplicate files in Google Drive, eliminating the tedious manual search and deletion process, reducing storage waste, and minimizing the risk of accidental deletions. It supports automatic tagging of duplicates for easy manual review or direct moving of duplicates to Trash, enabling automated file cleanup.

Use Cases

  • Individual or business users who need to regularly clean duplicate files in Google Drive to maintain folder organization.
  • Managing duplicates caused by frequent uploads and modifications in team shared drives.
  • Automating the file deduplication process to reduce manual maintenance workload.
  • Scenarios requiring retention of the latest file versions while marking or deleting duplicates.

Main Workflow Steps

  1. Trigger (Google Drive Trigger): Periodically (default every 15 minutes) monitors newly uploaded files in the specified Google Drive folder.
  2. Configuration Parameters (Config): Sets retention strategy (first/last), duplicate file operation (flag/trash), target folder, and file owner.
  3. Retrieve Files from Working Folder (Working Folder): Filters files in the specified folder owned by the designated user.
  4. Exclude Google Apps Files (Drop Google Apps files): Filters out non-binary files such as Google Docs and Sheets.
  5. Select Retention Strategy (Keep First/Last): Sorts files by creation time according to the chosen retention policy to determine which file to keep.
  6. Detect Duplicate Files (Deduplicate Keep First / Deduplicate Keep Last): Uses MD5 checksum to identify duplicate files based on content.
  7. Edit Fields (Edit Fields): Organizes file metadata fields to facilitate subsequent processing.
  8. Filter Duplicate Files (Filter): Selects files marked as duplicates.
  9. Determine Handling Method (Trash/Flag Duplicates): Based on configuration, decides whether to move duplicates to Trash or rename them with a prefix.
  10. Execute Actions:
    • Send Duplicates to Trash: Moves duplicate files to Google Drive Trash, allowing recovery within 30 days.
    • Flag as Duplicate (Google Drive Node): Adds a “DUPLICATE-” prefix to duplicate file names for easy identification.
  11. Skip Already Flagged Files (Is Flagged): Prevents reprocessing files that already have the “DUPLICATE-” prefix.

Involved Systems and Services

  • Google Drive: File storage, metadata retrieval, file deletion, and renaming operations.
  • n8n Automation Platform: Workflow design and execution.

Target Users and Value

  • Individual users needing automated duplicate file organization in their personal Google Drive to free up storage space.
  • Enterprises and teams managing shared drives to avoid confusion and storage waste caused by duplicate files.
  • IT administrators and automation engineers seeking to automate duplicate file detection and handling to improve operational efficiency.
  • Any users or teams aiming to simplify the Google Drive deduplication process.

By combining flexible configuration with automated execution, this workflow significantly enhances the intelligence and convenience of Google Drive file management, allowing users to focus on more important tasks.