コンテンツにスキップ

Driveにフォルダを作成する

function createFolder() {
  var folder = DriveApp.getFolderById(sh.getRange(xx").getValue());
  var arr = [];
  var last_row = sh.getLastRow();
  for(var i = 2; i < last_row+1; i++){
    arr.push(sh.getRange(i,1).getValue() + "_" + sh.getRange(i,2).getValue());
  }
  var folder1 = [];
  for (var i = 0; i < arr.length; i++){
    folder1[i] = folder.createFolder(arr[i]);
  }
}