Get file names from gdrive and save file names on gsheet

getNamesGdrive.gs

function myFunction() {
  var foldername = 'fotosh';
  var folderlisting = 'listing of folder ' + foldername;
  
  var folders = DriveApp.getFoldersByName('fotosh');
  while (folders.hasNext()) {
    var folder = folders.next();
    var contents = folder.getFiles();

    var ss = SpreadsheetApp.create(folderlisting);
    var sheet = ss.getActiveSheet();
    sheet.appendRow( ['name', 'link'] );
    
    var file;
    var name;
    var link;
    var row;
    
    while (contents.hasNext()) {
      file = contents.next();
      name = file.getName();
      link = file.getUrl();
      Logger.log(file.getName());
      sheet.appendRow( [name, link] );
    }
  }
};