You might be running an organization where files are created automatically or by other employees/collaborators.  Have you been troubled by google’s feature that allows ? files with the same name Then this blog is for you. You’ll get a script to delete the duplicate files and also be able to automate the process. Hi, this is Nibesh Khadka. . This blog is meant for both coders and non-coders, so, please do humor the over-explanation. I am a freelancer that helps clients with jobs related to Google Workspace Products and Google Apps Script Intro First of all, you have to understand that we are talking about files with the same name. We won't be checking the contents of the files in the script. So, we'll write a script: That'll target a folder. Check the contents of the folder. Compare the names and sizes of files with each other. If both matches then consider them duplicate file. Remove the duplicate files, if they exist. Create a trigger to automate this task. Apps Script Let's first go to your script project and create a new script. Add these codes there after emptying the file. home code.gs // Add id of the folder to check for duplicate
const FOLDER_ID = "";

/**
 * Function looks for duplicate file names in designated folder and removes them.
 * @param {String} fileName
 */
function removeDuplicateFile() {
  let folder = DriveApp.getFolderById(FOLDER_ID);

  let files = folder.getFiles();

  let fileList = [];

  // if no file is found return null
  if (!files.hasNext()) {
    return;
  }

  // else
  while (files.hasNext()) {
    let file = files.next(),
      name = file.getName(),
      size = file.getSize();

    // checking this way always leaves first file not deleted
    if (isDuplicateFile(fileList, name, size)) {
      file.setTrashed(true);
    } else {
      fileList.push([name, size]);
    }
  }
}

/**
 * Function is helper function of removeDuplicateFile function.
 * It checks if theres already a file in the given lst with same name and size and returns true or false
 * @param {List} lst
 * @param {String} name
 * @param {Number} size
 * @returns {Boolean}
 */
function isDuplicateFile(lst, name, size) {
  for (let i = 0; i < lst.length; i++) {
    if (lst[i][0] === name && lst[i][1] === size) return true;
  }
  return false;
}


/**
 * Delete all the triggers if there are any
 */
var deleteTrigger = () => {
  let triggersCollection = ScriptApp.getProjectTriggers();
  if (triggersCollection.length <= 0) {
    console.log(`Event doesnot have trigger id`);
  } else {
    triggersCollection.forEach((trigger) => ScriptApp.deleteTrigger(trigger));
  }
  return;
};

/**
 * Create a trigger function for file which also deletes previous triggers if there are.
 */
function removeDuplicateFileTrigger() {
  // First Delete existing triggers
  deleteTrigger();

  // now remove duplicate files 
  removeDuplicateFile();
} removeDuplicateFileTrigger() is a function that prevents installable triggers to accumulate and cause errors. If you  don’t want to automate you should run the removeDuplicateFile() function in the script instead. You can find your folder’s ID from the URL when you're in your folder in google drive as highlighted in the image below. Non-coders: You can see the second line in code→ . You’re supposed to add your folder id from here inside quotes. const FOLDER_ID = "" Setup Trigger You can now set up a time-based trigger to automate this task. Now, follow the steps indicated in the image above. In your script,  on the left panel, press the clock button. Remember to select the function in step 2. removeDuplicateFileTrigger Pick time driven event in the 3rd step. In 4th step, you can of course select hourly, weekly, monthly, and more options to choose when to run the trigger. Choose the time which will appear different based on your selection in the 4th step. Hit and you’re done. Save Warning: This script does not take into account the of google apps script for triggers and script run time. So, this script probably won't work for very large and old folders with many files. limitation Reference Inspired by StackOverflow answer. this Thank You for Your Time I make Google Add-Ons and can also write Google Apps Scripts for you. If you need my services let me . know

2022 - Tech Tutorial Teacher of the Year

Subscribe To Our News Letter For Free Contents

Hire Me

Newsletter

Buy Me a Coffee

Nominated for 2022 - Tech Tutorial Teacher of the Year

Developer 

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

How To Find and Delete Duplicate Files in Google Drive

Too Long; Didn't Read

Khadka's Coding Lounge.

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

How To Find and Delete Duplicate Files in Google Drive

Too Long; Didn't Read

Khadka's Coding Lounge.

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES