Filename fromfile id

Description

This Apps Script function allows you to retrieve file names from their corresponding Google Drive file IDs and populate them into a Google Sheet. It helps automate the process of identifying files based on their IDs, saving time and effort.

Instructions

Create a Google Sheet:

Name a sheet FileNameFromFileId.

In column B, starting from row 2, list the file IDs you want to retrieve names for.

Column C will be used to display the corresponding file names.

Add the Script:

Open your Google Sheet.

Go to Extensions > Apps Script.

Delete any code in the script editor and replace it with the script provided below.

Run the Script:

Save the script and give it a name (e.g., GetFileNames).

Click the run button to execute the script.

Authorize the script to access your Google Drive if prompted.

View the Results:

After running the script, the file names will appear in column C next to their respective IDs.

Script

function getFileNameFromId() { var ss = SpreadsheetApp.getActive(); var sh = ss.getSheetByName('FileNameFromFileId'); var lr = sh.getLastRow(); var rgIds = sh.getRange("B2:B" + lr); var vIds = rgIds.getValues(); var rgNames = sh.getRange("C2:C" + lr); var vNames = rgNames.getValues(); for (var i = 0; i < vIds.length; i++) { if (vIds[i][0] !== "") { // Proceed only if the cell is not empty var fileId = vIds[i][0]; try { var fileName = DriveApp.getFileById(fileId).getName(); vNames[i][0] = fileName; // Update file name in the corresponding cell } catch (error) { vNames[i][0] = "Error: File not found"; // Handle case where file is not found } } } rgNames.setValues(vNames); // Set updated file names back to the spreadsheet }

Feel free to leave a comment if you have any questions or run into any issues. 

---