//updated 2016-08-20
// Add a custom menu to the active spreadsheet.
function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [];
  // When the user selects "Get URLs" menu, and clicks "Run Script", the function getURLs is executed.
  menuEntries.push({name: "Run Script", functionName: "getURLs"});
  ss.addMenu("Get URLs", menuEntries);
}

function getURLs() {
  
  // https://developers.google.com/apps-script/
  var folderID = '0B6DMMA0K5cJkCSUTUnNsVGRieEk' // <- Put the Google Drive folderID here
  
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  
  var folder = DriveApp.getFolderById(folderID);
  var contents = folder.getFiles();
  
  sheet.clearContents()
    
  while(contents.hasNext()) {
    var file = contents.next();
    var name = file.getName();
    var link = file.getUrl().replace('file/d/','uc?export=download&id=').replace('/view?usp=drivesdk','');
    sheet.appendRow( [name, link] );    
  }
  
  sheet.sort(1, true);
}