workaround.gs

function createTempSheets() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  //指定單一 sheet
  var dataSheet = ss.getSheetByName("communitykey");
  var crKeys = dataSheet.getRange(2,1,19,3).getValues();

  for (var row=0; row<19; row++){
    
    var sheet = ss.insertSheet(crKeys[row][0]);
    sheet.getRange("A1").setValue('=query(\'表單回應 1\'!1:307,"SELECT A,B,C,'+crKeys[row][2]+'V,W,X,Y,Z,AA,AB,AC,AD,AE,AF,AG,AH,AI WHERE C=\''+crKeys[row][1]+'\'",1)');
    
  }
}


function createCopyAndShare(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var dataSheet = ss.getSheetByName("communitykey");
  var crSheet = dataSheet.getRange(2,1,19,5);
  var crKeys = crSheet.getValues();

  for (var row=0; row<19; row++){ //19
    var ssNew = SpreadsheetApp.create("COSCUP'19: "+crKeys[row][1]);
  
    //複製內容為純文字
    var orgRange = ss.getSheetByName(crKeys[row][0]).getDataRange();
    ssNew.getSheets()[0].getRange(orgRange.getA1Notation()).setValues(orgRange.getValues());
      
    //紀錄網址並分享
    var fileURL = ssNew.getUrl();
    crSheet.getCell(row+1,5).setValue(fileURL);
    DriveApp.getFolderById(fileURL.split("/")[5]).addEditors(crKeys[row][3].split(","));
  }
}

https://hackmd.io/_YLdXW8ZRGy35OB2x7Wrzw