FolderにSpreadsheetを作成¶
function createSpreadsheetInfolder(folderID, fileName) {
var folder = DriveApp.getFolderById(folderID);
var newSS=SpreadsheetApp.create(fileName);
var originalFile=DriveApp.getFileById(newSS.getId());
var copiedFile = originalFile.makeCopy(fileName, folder);
DriveApp.getRootFolder().removeFile(originalFile);
return copiedFile;
}