{"id":17146,"date":"2025-01-14T15:44:42","date_gmt":"2025-01-14T06:44:42","guid":{"rendered":"https:\/\/84office.jp\/?p=17146"},"modified":"2025-01-14T15:44:43","modified_gmt":"2025-01-14T06:44:43","slug":"bulk-deletion-gas-files","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/bulk-deletion-gas-files\/","title":{"rendered":"Bulk Delete Files in Google Drive with Google Apps Script: Organize with Spreadsheets"},"content":{"rendered":"
<\/div>\n

In previous articles, we introduced how to modify access permissions and bulk copy files within a folder using Google Apps Script. This time, we\u2019ll explain how to bulk delete files in Google Drive<\/strong>.<\/p>\n\n\n\n

Using two Google Apps Scripts, you can list files within a folder or across your entire Drive and efficiently delete unnecessary ones in bulk.<\/p>\n\n\n\n

Manually deleting files one by one in Google Drive can be time-consuming, but with this method, you can streamline the process and save time.<\/p>\n\n\n

\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tGoogle\u30c9\u30e9\u30a4\u30d6\u306e\u30d5\u30a9\u30eb\u30c0\u5185\u30d5\u30a1\u30a4\u30eb\u3092\u307e\u3068\u3081\u3066\u30b3\u30d4\u30fc\uff01\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u00d7GAS\u3067\u4f5c\u696d\u52b9\u7387\u5316<\/a>\n\t\t\t\t\t\t\u3053\u306e\u8a18\u4e8b\u3092\u304a\u3059\u3059\u3081\u306e\u65b9 \u4e00\u3064\u306e\u30d5\u30a9\u30eb\u30c0\u5185\u306b\u30d5\u30a1\u30a4\u30eb\u304c\u591a\u6570\u3042\u308b\u65b9 \u30d5\u30a9\u30eb\u30c0\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u30b3\u30d4\u30fc\u3092\u81ea\u52d5\u5316\u3057\u305f\u3044\u65b9 Google\u30c9\u30e9\u30a4\u30d6\u3084\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f7f\u3063\u3066\u3044\u3066\u3001\u300c\u30d5\u30a9…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n
\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tEffortlessly Manage and Modify Spreadsheet Permissions Using Google Apps Script: Preparation Guide<\/a>\n\t\t\t\t\t\tHave you ever struggled with the tedious task of reviewing and modifying sharing settings for individual files, such as spreadsheets or documents? This proce…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n

Example Output<\/h2>\n\n\n\n

List Files in Google Drive (Script \u2460)<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Bulk Delete Selected Files (Script \u2461)<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n
    \n
  • Specify a folder name or ID to list target files in a spreadsheet.<\/strong><\/strong><\/li>\n\n\n\n
  • Select files for deletion using checkboxes and execute bulk deletion.<\/strong><\/strong><\/li>\n\n\n\n
  • Record a history of deleted files for reference.<\/strong><\/strong><\/li>\n<\/ul>\n\n\n\n

    This script moves files in Google Drive to the Trash<\/strong>, so they are not permanently deleted.
    To completely remove the files, you will need to manually empty the Trash in Google Drive as needed.<\/p>\n\n\n\n

    Steps<\/h2>\n\n\n\n

    Script 1: File Listing<\/strong><\/h3>\n\n\n\n

    This script lists the files you want to delete, allowing you to select which files to remove.<\/p>\n\n\n\n

    \n
    STEP<\/span><\/div>
    Open the Spreadsheet<\/strong><\/div>
    \n
    \"\"<\/figure>\n<\/div>\n\n\n

    Open a Google Spreadsheet.<\/p>\n\n\n\n

    (Both existing or new files are supported.)<\/p>\n\n\n\n

    Since the items are automatically created by Google Apps Script, no manual input is required.<\/p>\n\n\n\n

      \n
    • A new sheet named “Bulk File Deletion”<\/strong> will be created.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
      STEP<\/span><\/div>
      Open Apps Script Editor<\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Open a Google Spreadsheet and click on \u201cExtensions<\/strong>\u201d in the menu, then \u201cApps Script<\/strong>\u201d to open the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n

      STEP<\/span><\/div>
      Create the Script<\/strong><\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Since the default function myFunction() {}<\/code> is present, delete it and replace it with the script below.<\/p>\n\n\n\n

      <\/path><\/path><\/svg><\/span>
      function<\/span> <\/span>listFilesForDeletion<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> ui <\/span>=<\/span> SpreadsheetApp.<\/span>getUi<\/span>();<\/span><\/span>\n  <\/span>const<\/span> response <\/span>=<\/span> ui.<\/span>prompt<\/span>(<\/span><\/span>\n    <\/span>'Specify a Folder'<\/span>,<\/span><\/span>\n    <\/span>'Enter "All Files in Drive" or provide a folder name or folder ID:'<\/span>,<\/span><\/span>\n    ui.ButtonSet.OK_CANCEL<\/span><\/span>\n  );<\/span><\/span>\n<\/span>\n  <\/span>if<\/span> (response.<\/span>getSelectedButton<\/span>() <\/span>===<\/span> ui.Button.CANCEL) {<\/span><\/span>\n    ui.<\/span>alert<\/span>(<\/span>'Operation cancelled.'<\/span>);<\/span><\/span>\n    <\/span>return<\/span>;<\/span><\/span>\n  }<\/span><\/span>\n<\/span>\n  <\/span>const<\/span> input <\/span>=<\/span> response.<\/span>getResponseText<\/span>().<\/span>trim<\/span>();<\/span><\/span>\n<\/span>\n  <\/span>\/\/ If "All Files in Drive" is entered, list all files; otherwise, list files in the specified folder<\/span><\/span>\n  <\/span>if<\/span> (input <\/span>===<\/span> <\/span>'All Files in Drive'<\/span>) {<\/span><\/span>\n    <\/span>listAllFilesForDeletion<\/span>();<\/span><\/span>\n  } <\/span>else<\/span> {<\/span><\/span>\n    <\/span>listFilesInFolderForDeletion<\/span>(input);<\/span><\/span>\n  }<\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction<\/span> <\/span>listAllFilesForDeletion<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> <\/span>setupDeletionSheet<\/span>();<\/span><\/span>\n  <\/span>const<\/span> files <\/span>=<\/span> DriveApp.<\/span>getFiles<\/span>();<\/span><\/span>\n  <\/span>let<\/span> row <\/span>=<\/span> <\/span>2<\/span>;<\/span><\/span>\n<\/span>\n  <\/span>while<\/span> (files.<\/span>hasNext<\/span>()) {<\/span><\/span>\n    <\/span>const<\/span> file <\/span>=<\/span> files.<\/span>next<\/span>();<\/span><\/span>\n    <\/span>appendFileDataForDeletionToSheet<\/span>(sheet, file, row);<\/span><\/span>\n    row<\/span>++<\/span>;<\/span><\/span>\n  }<\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction<\/span> <\/span>listFilesInFolderForDeletion<\/span>(<\/span>folderNameOrId<\/span>) {<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> <\/span>setupDeletionSheet<\/span>();<\/span><\/span>\n  <\/span>let<\/span> folder;<\/span><\/span>\n<\/span>\n  <\/span>try<\/span> {<\/span><\/span>\n    folder <\/span>=<\/span> DriveApp.<\/span>getFolderById<\/span>(folderNameOrId);<\/span><\/span>\n  } <\/span>catch<\/span> (e) {<\/span><\/span>\n    <\/span>const<\/span> folders <\/span>=<\/span> DriveApp.<\/span>getFoldersByName<\/span>(folderNameOrId);<\/span><\/span>\n    <\/span>if<\/span> (folders.<\/span>hasNext<\/span>()) {<\/span><\/span>\n      folder <\/span>=<\/span> folders.<\/span>next<\/span>();<\/span><\/span>\n    } <\/span>else<\/span> {<\/span><\/span>\n      SpreadsheetApp.<\/span>getUi<\/span>().<\/span>alert<\/span>(<\/span>'Folder not found.'<\/span>);<\/span><\/span>\n      <\/span>return<\/span>;<\/span><\/span>\n    }<\/span><\/span>\n  }<\/span><\/span>\n<\/span>\n  <\/span>const<\/span> files <\/span>=<\/span> folder.<\/span>getFiles<\/span>();<\/span><\/span>\n  <\/span>let<\/span> row <\/span>=<\/span> <\/span>2<\/span>;<\/span><\/span>\n<\/span>\n  <\/span>while<\/span> (files.<\/span>hasNext<\/span>()) {<\/span><\/span>\n    <\/span>const<\/span> file <\/span>=<\/span> files.<\/span>next<\/span>();<\/span><\/span>\n    <\/span>appendFileDataForDeletionToSheet<\/span>(sheet, file, row);<\/span><\/span>\n    row<\/span>++<\/span>;<\/span><\/span>\n  }<\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction<\/span> <\/span>setupDeletionSheet<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> sheetName <\/span>=<\/span> <\/span>'Bulk File Deletion'<\/span>;<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>().<\/span>getSheetByName<\/span>(sheetName) <\/span>||<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>().<\/span>insertSheet<\/span>(sheetName);<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Clear and reset the sheet<\/span><\/span>\n  sheet.<\/span>clear<\/span>();<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Set headers<\/span><\/span>\n  <\/span>const<\/span> headers <\/span>=<\/span> [<\/span><\/span>\n    <\/span>'Folder Name'<\/span>, <\/span><\/span>\n    <\/span>'File Name'<\/span>, <\/span><\/span>\n    <\/span>'Owner'<\/span>, <\/span><\/span>\n    <\/span>'Last Updated'<\/span>, <\/span><\/span>\n    <\/span>'Delete Target'<\/span><\/span>\n  ];<\/span><\/span>\n<\/span>\n  sheet.<\/span>appendRow<\/span>(headers);<\/span><\/span>\n  <\/span>const<\/span> headerRange <\/span>=<\/span> sheet.<\/span>getRange<\/span>(<\/span>1<\/span>, <\/span>1<\/span>, <\/span>1<\/span>, headers.length);<\/span><\/span>\n  headerRange.<\/span>setHorizontalAlignment<\/span>(<\/span>'center'<\/span>);<\/span><\/span>\n  headerRange.<\/span>setVerticalAlignment<\/span>(<\/span>'middle'<\/span>);<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Set background color for headers (light green)<\/span><\/span>\n  headerRange.<\/span>setBackground<\/span>(<\/span>'#B7E1CD'<\/span>);<\/span><\/span>\n<\/span>\n  <\/span>return<\/span> sheet;<\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction<\/span> <\/span>appendFileDataForDeletionToSheet<\/span>(<\/span>sheet<\/span>, <\/span>file<\/span>, <\/span>row<\/span>) {<\/span><\/span>\n  <\/span>const<\/span> folderName <\/span>=<\/span> <\/span>getFolderName<\/span>(file);<\/span><\/span>\n  <\/span>const<\/span> fileName <\/span>=<\/span> file.<\/span>getName<\/span>();<\/span><\/span>\n  <\/span>const<\/span> fileLink <\/span>=<\/span> file.<\/span>getUrl<\/span>();<\/span><\/span>\n  <\/span>const<\/span> owner <\/span>=<\/span> file.<\/span>getOwner<\/span>() <\/span>?<\/span> file.<\/span>getOwner<\/span>().<\/span>getEmail<\/span>() <\/span>:<\/span> <\/span>'No Owner'<\/span>;<\/span><\/span>\n  <\/span>const<\/span> lastUpdated <\/span>=<\/span> file.<\/span>getLastUpdated<\/span>();<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Add data to the sheet (file name as a hyperlink)<\/span><\/span>\n  sheet.<\/span>getRange<\/span>(row, <\/span>1<\/span>).<\/span>setValue<\/span>(folderName);<\/span><\/span>\n  sheet.<\/span>getRange<\/span>(row, <\/span>2<\/span>).<\/span>setFormula<\/span>(<\/span>`=HYPERLINK("<\/span>${<\/span>fileLink<\/span>}<\/span>", "<\/span>${<\/span>fileName<\/span>}<\/span>")`<\/span>);<\/span><\/span>\n  sheet.<\/span>getRange<\/span>(row, <\/span>3<\/span>).<\/span>setValue<\/span>(owner);<\/span><\/span>\n  sheet.<\/span>getRange<\/span>(row, <\/span>4<\/span>).<\/span>setValue<\/span>(lastUpdated);<\/span><\/span>\n  sheet.<\/span>getRange<\/span>(row, <\/span>5<\/span>).<\/span>insertCheckboxes<\/span>(); <\/span>\/\/ Add checkboxes for delete targets<\/span><\/span>\n}<\/span><\/span>\n<\/span>\nfunction<\/span> <\/span>getFolderName<\/span>(<\/span>file<\/span>) {<\/span><\/span>\n  <\/span>const<\/span> parents <\/span>=<\/span> file.<\/span>getParents<\/span>();<\/span><\/span>\n  <\/span>return<\/span> parents.<\/span>hasNext<\/span>() <\/span>?<\/span> parents.<\/span>next<\/span>().<\/span>getName<\/span>() <\/span>:<\/span> <\/span>'Root'<\/span>;<\/span><\/span>\n}<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
      \n
      Script 1 Description<\/span><\/i><\/i><\/span><\/summary>
      \n
      \n
      listFilesForDeletion<\/code> Function<\/strong><\/strong><\/dt>\n\n\n\n
      \n
      This function prompts the user to specify a folder name, folder ID, or select “All Files in Drive”<\/strong>. It then lists all files within the specified folder or across the entire Drive.<\/p>\n\n\n\n
      <\/path><\/path><\/svg><\/span>
      function<\/span> <\/span>listFilesForDeletion<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> ui <\/span>=<\/span> SpreadsheetApp.<\/span>getUi<\/span>();<\/span><\/span>\n  <\/span>const<\/span> response <\/span>=<\/span> ui.<\/span>prompt<\/span>(<\/span><\/span>\n    <\/span>'Specify a Folder'<\/span>,<\/span><\/span>\n    <\/span>'Enter "All Files in Drive" or provide a folder name or folder ID:'<\/span>,<\/span><\/span>\n    ui.ButtonSet.OK_CANCEL<\/span><\/span>\n  );<\/span><\/span>\n<\/span>\n  <\/span>if<\/span> (response.<\/span>getSelectedButton<\/span>() <\/span>===<\/span> ui.Button.CANCEL) {<\/span><\/span>\n    ui.<\/span>alert<\/span>(<\/span>'Operation cancelled.'<\/span>);<\/span><\/span>\n    <\/span>return<\/span>;<\/span><\/span>\n  }<\/span><\/span>\n<\/span>\n  <\/span>const<\/span> input <\/span>=<\/span> response.<\/span>getResponseText<\/span>().<\/span>trim<\/span>();<\/span><\/span>\n<\/span>\n  <\/span>\/\/ If "All Files in Drive" is entered, list all files; otherwise, list files in the specified folder<\/span><\/span>\n  <\/span>if<\/span> (input <\/span>===<\/span> <\/span>'All Files in Drive'<\/span>) {<\/span><\/span>\n    <\/span>listAllFilesForDeletion<\/span>();<\/span><\/span>\n  } <\/span>else<\/span> {<\/span><\/span>\n    <\/span>listFilesInFolderForDeletion<\/span>(input);<\/span><\/span>\n  }<\/span><\/span>\n}<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
        \n
      • The function uses ui.prompt()<\/code> to request user input, allowing the user to specify a folder name or folder ID to determine the scope of the file listing.<\/li>\n\n\n\n
      • If the input is “All Files in Drive”<\/strong>, the listAllFilesForDeletion()<\/code> function is called to list all files in the Drive.<\/li>\n\n\n\n
      • For any other input, the listFilesInFolderForDeletion()<\/code> function is called to list files within the specified folder.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n
        listAllFilesForDeletion<\/code> Function<\/strong><\/dt>\n\n\n\n
        \n
        This function lists all files in Google Drive.<\/p>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        function<\/span> <\/span>listAllFilesForDeletion<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> <\/span>setupDeletionSheet<\/span>();<\/span><\/span>\n  <\/span>const<\/span> files <\/span>=<\/span> DriveApp.<\/span>getFiles<\/span>();<\/span><\/span>\n  <\/span>let<\/span> row <\/span>=<\/span> <\/span>2<\/span>;<\/span><\/span>\n<\/span>\n  <\/span>while<\/span> (files.<\/span>hasNext<\/span>()) {<\/span><\/span>\n    <\/span>const<\/span> file <\/span>=<\/span> files.<\/span>next<\/span>();<\/span><\/span>\n    <\/span>appendFileDataForDeletionToSheet<\/span>(sheet, file, row);<\/span><\/span>\n    row<\/span>++<\/span>;<\/span><\/span>\n  }<\/span><\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
          \n
        • It uses DriveApp.getFiles()<\/code> to retrieve all files in Google Drive and adds them to the spreadsheet.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n
          listFilesInFolderForDeletion<\/code> Function<\/strong><\/strong><\/dt>\n\n\n\n
          \n
          This function lists the files within the specified folder.<\/p>\n\n\n\n
          <\/path><\/path><\/svg><\/span>
          function<\/span> <\/span>listFilesInFolderForDeletion<\/span>(<\/span>folderNameOrId<\/span>) {<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> <\/span>setupDeletionSheet<\/span>();<\/span><\/span>\n  <\/span>let<\/span> folder;<\/span><\/span>\n<\/span>\n  <\/span>try<\/span> {<\/span><\/span>\n    folder <\/span>=<\/span> DriveApp.<\/span>getFolderById<\/span>(folderNameOrId);<\/span><\/span>\n  } <\/span>catch<\/span> (e) {<\/span><\/span>\n    <\/span>const<\/span> folders <\/span>=<\/span> DriveApp.<\/span>getFoldersByName<\/span>(folderNameOrId);<\/span><\/span>\n    <\/span>if<\/span> (folders.<\/span>hasNext<\/span>()) {<\/span><\/span>\n      folder <\/span>=<\/span> folders.<\/span>next<\/span>();<\/span><\/span>\n    } <\/span>else<\/span> {<\/span><\/span>\n      SpreadsheetApp.<\/span>getUi<\/span>().<\/span>alert<\/span>(<\/span>'Folder not found.'<\/span>);<\/span><\/span>\n      <\/span>return<\/span>;<\/span><\/span>\n    }<\/span><\/span>\n  }<\/span><\/span>\n<\/span><\/code><\/pre><\/div>\n\n\n\n
            \n
          • It retrieves the target folder based on the folder ID or folder name provided by the user.<\/li>\n\n\n\n
          • The files within the specified folder are then fetched using the getFiles()<\/code> method and listed in the spreadsheet.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n
            setupDeletionSheet<\/code> Function<\/strong><\/strong><\/dt>\n\n\n\n
            \n
            This function sets up the spreadsheet to be used for listing files.<\/p>\n\n\n\n
            <\/path><\/path><\/svg><\/span>
            function<\/span> <\/span>setupDeletionSheet<\/span>() {<\/span><\/span>\n  <\/span>const<\/span> sheetName <\/span>=<\/span> <\/span>'Bulk File Deletion'<\/span>;<\/span><\/span>\n  <\/span>const<\/span> sheet <\/span>=<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>().<\/span>getSheetByName<\/span>(sheetName) <\/span>||<\/span> SpreadsheetApp.<\/span>getActiveSpreadsheet<\/span>().<\/span>insertSheet<\/span>(sheetName);<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Clear and reset the sheet<\/span><\/span>\n  sheet.<\/span>clear<\/span>();<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Set headers<\/span><\/span>\n  <\/span>const<\/span> headers <\/span>=<\/span> [<\/span><\/span>\n    <\/span>'Folder Name'<\/span>, <\/span><\/span>\n    <\/span>'File Name'<\/span>, <\/span><\/span>\n    <\/span>'Owner'<\/span>, <\/span><\/span>\n    <\/span>'Last Updated'<\/span>, <\/span><\/span>\n    <\/span>'Delete Target'<\/span><\/span>\n  ];<\/span><\/span>\n<\/span>\n  sheet.<\/span>appendRow<\/span>(headers);<\/span><\/span>\n  <\/span>const<\/span> headerRange <\/span>=<\/span> sheet.<\/span>getRange<\/span>(<\/span>1<\/span>, <\/span>1<\/span>, <\/span>1<\/span>, headers.length);<\/span><\/span>\n  headerRange.<\/span>setHorizontalAlignment<\/span>(<\/span>'center'<\/span>);<\/span><\/span>\n  headerRange.<\/span>setVerticalAlignment<\/span>(<\/span>'middle'<\/span>);<\/span><\/span>\n<\/span>\n  <\/span>\/\/ Set background color for headers (light green)<\/span><\/span>\n  headerRange.<\/span>setBackground<\/span>(<\/span>'#B7E1CD'<\/span>);<\/span><\/span>\n<\/span>\n  <\/span>return<\/span> sheet;<\/span><\/span>\n}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n