Home

Welcome to the GSheetThumbnail wiki! Script 1 function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menuItems=[{name: 'Get Files In This Folder', functionName: 'getFiles'}]; ss.addMenu('Script', menuItems); }; function getFiles() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var ssId = ss.getId(); var folderId = DriveApp.getFileById(ssId).getParents().next().getId(); var folder = DriveApp.getFolderById(folderId); var files = folder.getFiles(); var filenames = new Array(); filenames.push(['File Name','URL']); while(files.hasNext()) { var file = files.next(); filenames.push([file.getName(),file.getUrl()]); } var s = ss.getSheetByName('Sheet1'); s.getRange('A:B').clearContent(); s.getRange(1,1,filenames.length,filenames[0].length).setValues(filenames); };

Script 2 function image() { var ss, urls, formulas; ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet2'); urls = ss.getRange('a2:a').getValues(); formulas = []; for (var i = 0, len = urls.length; i < len; i++) { if (urls[i] =='') break; formulas.push(['=image("' + urls[i] + '")']); } ss.getRange(2, 2, formulas.length, 1).setFormulas(formulas); }

=mid(B2,53, 33) http://drive.google.com/uc?export=view&id= =CONCATENATE(D2,C2)