function getFileIdAndNames() {
var FileFolderID = '1wPcxm9jYoxbsbXqYOLxkGBstlSoZHmF6'; // the ID of the folder with files var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var urlCol = 1; var urlRow = 1; var folder = DriveApp.getFolderById(FileFolderID); var files = folder.getFiles();
sheet.clear();
while (files.hasNext()) { var file = files.next(); if (file.getName().indexOf(".jpg") != -1) { sheet.getRange(urlRow, urlCol).setValue(file.getName()); sheet.getRange(urlRow, urlCol+1).setValue(file.getId()); sheet.getRange(urlRow, urlCol+2).setValue('https://drive.google.com/uc?export=view&id='+ file.getId()); sheet.getRange(urlRow, urlCol+3).setValue('JPG'); sheet.getRange(urlRow, urlCol+4).setValue(Math.round(file.getSize()/1000) + " KB"); sheet.getRange(urlRow, urlCol+5).setValue(file.getName().slice(0, -4)); } else if (file.getName().indexOf(".png") != -1) { sheet.getRange(urlRow, urlCol).setValue(file.getName()); sheet.getRange(urlRow, urlCol+1).setValue(file.getId()); sheet.getRange(urlRow, urlCol+2).setValue('https://drive.google.com/uc?export=view&id='+ file.getId()); sheet.getRange(urlRow, urlCol+3).setValue('PNG'); sheet.getRange(urlRow, urlCol+4).setValue(Math.round(file.getSize()/1000) + " KB"); sheet.getRange(urlRow, urlCol+5).setValue(file.getName().slice(0, -4)); } urlRow = urlRow+1; } sheet.sort(1, true); sheet.sort(4, true); sheet.insertRows(1); var title = [["Filename","File ID","Direct Link to View","File Type","File Size (KB)","Description"]]; var fontStyles = [ [ "bold", "bold", "bold", "bold", "bold","bold" ]]; var titleRange = sheet.getRange("A1:F1"); titleRange.setValues(title); titleRange.setFontWeights(fontStyles); }
//for AI2 appfunction doGet(e) { deleteImage(e) return ContentService.createTextOutput("Image File Deleted").setMimeType(ContentService.MimeType.TEXT);}
//for PC browserfunction doPost(e) { deleteImage(e) return ContentService.createTextOutput("Image File Deleted").setMimeType(ContentService.MimeType.TEXT);}
function deleteImage(e) { DriveApp.getFileById(e.parameter.id).setTrashed(true); //##This section just for the example - to allow images to be replaced from trash //var ss = SpreadsheetApp.getActiveSpreadsheet(); //var sheet = ss.getSheets()[1]; //sheet.appendRow([e.parameter.id]); //##end of example section getFileIdAndNames();}
function getFileIdAndNames() {
var FileFolderID = '1wPcxm9jYoxbsbXqYOLxkGBstlSoZHmF6'; // the ID of the folder with files var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var urlCol = 1; var urlRow = 1; var folder = DriveApp.getFolderById(FileFolderID); var files = folder.getFiles();
sheet.clear();
while (files.hasNext()) { var file = files.next(); if (file.getName().indexOf(".jpg") != -1) { sheet.getRange(urlRow, urlCol).setValue(file.getName()); sheet.getRange(urlRow, urlCol+1).setValue(file.getId()); sheet.getRange(urlRow, urlCol+2).setValue('https://drive.google.com/uc?export=view&id='+ file.getId()); sheet.getRange(urlRow, urlCol+3).setValue('JPG'); sheet.getRange(urlRow, urlCol+4).setValue(Math.round(file.getSize()/1000) + " KB"); sheet.getRange(urlRow, urlCol+5).setValue(file.getName().slice(0, -4)); } else if (file.getName().indexOf(".png") != -1) { sheet.getRange(urlRow, urlCol).setValue(file.getName()); sheet.getRange(urlRow, urlCol+1).setValue(file.getId()); sheet.getRange(urlRow, urlCol+2).setValue('https://drive.google.com/uc?export=view&id='+ file.getId()); sheet.getRange(urlRow, urlCol+3).setValue('PNG'); sheet.getRange(urlRow, urlCol+4).setValue(Math.round(file.getSize()/1000) + " KB"); sheet.getRange(urlRow, urlCol+5).setValue(file.getName().slice(0, -4)); } urlRow = urlRow+1; } sheet.sort(1, true); sheet.sort(4, true); sheet.insertRows(1); var title = [["Filename","File ID","Direct Link to View","File Type","File Size (KB)","Description"]]; var fontStyles = [ [ "bold", "bold", "bold", "bold", "bold","bold" ]]; var titleRange = sheet.getRange("A1:F1"); titleRange.setValues(title); titleRange.setFontWeights(fontStyles); }