just an update option as the one from @marcelo Guerra is using a deprecated method (addFile)
//create a new google sheet within managerFolder
var ss = SpreadsheetApp.create(fileName);
var ssId = ss.getId();
var ssFile = DriveApp.getFileById(ssId);
ssFile.moveTo(destinationFolder);