Description

This Google Apps Script helps you gather all files you own from a chosen Google Drive folder and display them in a Google Sheet. It collects the File ID, Name, and URL for each file in that folder, presenting them in an organized way. This tool is great for keeping track of and managing files stored in a specific Drive folder.

Retrieve Your Files from a Specific Google Drive Folder in Google Sheets

Instructions

1 Create a Google Sheet and name it FilesFromSpecificfolder.

2 Prepare the Sheet:
In Cell A1, type the name of the folder you want to pull files from.
Columns B, C, and D will automatically show the File ID, Name, and URL once the script runs.

3 Insert the Script:
Open your Google Sheet.
Navigate to Extensions, then Apps Script.
Clear out any code already in the script editor.
Copy and paste the script provided below, then save it.

4 Execute the Script:
Press the play button in the Apps Script editor.
The script will locate the folder, find files you own, and fill the sheet with their details.

Apps Script Code

function getMyFilesFromDrivefolder() {
  var sheet = SpreadsheetApp.getActive().getSheetByName("FilesFromSpecificfolder");
  var folderName = sheet.getRange("A1").getValue();
  var folders = DriveApp.getFoldersByName(folderName);
  if (folders.hasNext()) {
    var folder = folders.next();
    var myFiles = folder.searchFiles('"me" in owners');
    var lastRow = sheet.getLastRow();
    if (lastRow > 1) {
      sheet.getRange(2, 1, lastRow - 1, 3).clearContent();
    }
    var rows = [];
    rows.push(["ID", "Name", "Url"]);
    while (myFiles.hasNext()) {
      var file = myFiles.next();
      rows.push([file.getId(), file.getName(), file.getUrl()]);
    }
    sheet.getRange(2, 2, rows.length, 3).setValues(rows);
  } else {
    Logger.log("Folder not found: " + folderName);
  }
}

Posts