Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function listFilesInFolder(folderName) {
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Get_Link');
- //sheet.appendRow(["File Name","URL"]);
- var folderID = [];
- folderID = SpreadsheetApp.getActive()
- .getRange('Folder_ID!A2:B')
- .getValues()
- .reduce(function(p, c) {
- if (c[0] !== '' && c[1] !== '') {
- p.push( DriveApp.getFolderById(c[1]).getFiles() );
- return p; }
- }, []);
- //var searchTerm = Browser.inputBox("Masukkan Folder ID:");
- //var folder = DriveApp.getFolderById(searchTerm);
- //var contents = folder.getFiles();
- var cnt = 0;
- var file;
- while (folderID.hasNext()) {
- var file = folderID.next();
- cnt++;
- data = [
- file.getName(),
- file.getUrl(),
- ];
- sheet.appendRow(data);
- };
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement