9/11/2023 0 Comments Bulk rename app![]() ![]() Set the new file name with tName().Ĭode snippet: const SPREADSHEET_ID = "SPREADSHEET_ID" // Change according to your preferencesĬonst SHEET_NAME = "Sheet1" // Change according to your preferencesĬonst FOLDER_ID = "DRIVE_FOLDER_ID" // Change according to your preferencesĬonst ss = SpreadsheetApp.openById(SPREADSHEET_ID) Ĭonst sheet = ss.getSheetByName(SHEET_NAME) Ĭonst folder = DriveApp.getFolderById(FOLDER_ID) Ĭonst values = sheet.getRange("A2:B" + sheet.getLastRow()).getValues() // If there's no header row, use "A:B" insteadĬonst fileIter = folder.Use the in-app file browser to easily select the input files. Rename or group all your files in three simple steps: 1. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |