## Retrieve Your Files from a Specific Google Drive Folder in Google Sheets ### Description This Google Apps Script allows you to retrieve all files owned by you from a specific Google Drive folder and list them in a Google Sheet. It extracts the **File ID, Name, and URL** of each file inside the folder and displays them in a structured format. This is useful for organizing and managing files within a particular folder in your Drive. ### Instructions 1. **Create a Google Sheet** named `FilesFromSpecificfolder`. 2. **Set Up the Sheet Structure**: - **Cell A1**: Enter the name of the folder from which you want to retrieve files. - **Columns B, C, and D**: These will be automatically filled with **File ID, Name, and URL** after running the script. 3. **Add the Script**: - Open your Google Sheet. - Go to `Extensions > Apps Script`. - Delete any existing code in the script editor. - Paste the script below and save it. 4. **Run the Script**: - Click the play button (▶️) in the Apps Script editor. - The script will search for the specified folder, retrieve files owned by you, and populate the sheet with their details. ### Apps Script Code ### Copy Code Click the button below to copy the code easily: ```html function getMyFilesFromDrivefolder() { // Get folder name from Cell A1 of the active sheet var sheet = SpreadsheetApp.getActive().getSheetByName("FilesFromSpecificfolder"); var folderName = sheet.getRange("A1").getValue(); // Get the folder by name var folders = DriveApp.getFoldersByName(folderName); // Check if folder exists if (folders.hasNext()) { var folder = folders.next(); // Get files in the folder var myFiles = folder.searchFiles('"me" in owners'); // Clear existing data in the sheet var lastRow = sheet.getLastRow(); if (lastRow > 1) { sheet.getRange(2, 1, lastRow - 1, 3).clearContent(); } var rows = []; rows.push(["ID", "Name", "Url"]); // Iterate over each file while (myFiles.hasNext()) { var file = myFiles.next(); rows.push([file.getId(), file.getName(), file.getUrl()]); } // Write data to the spreadsheet sheet.getRange(2, 2, rows.length, 3).setValues(rows); } else { Logger.log("Folder not found: " + folderName); } } ```