Google Driveのフォルダを一括作成する前に確認｜GASのdry-run付き安全テンプレート

const FOLDER_PLAN_CONFIG = {
  ROOT_FOLDER_ID: 'ここに作成先フォルダIDを入れる',
  PLAN_SHEET: 'FolderPlan',
  LOG_SHEET: 'FolderCreateLog',
  DRY_RUN: true,
  MAX_ROWS: 50,
  MAX_DEPTH: 4
};

function runFolderPlanFree() {
  const config = FOLDER_PLAN_CONFIG;
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const planSheet = spreadsheet.getSheetByName(config.PLAN_SHEET);
  if (!planSheet) {
    throw new Error('FolderPlan シートがありません。');
  }

  const plans = readAndValidateFolderPlans_(planSheet, config);
  const rootFolder = getRootFolderSafely_(config.ROOT_FOLDER_ID);
  const logRows = [];

  plans.forEach(function(plan) {
    try {
      if (config.DRY_RUN) {
        logRows.push([new Date(), 'DRY_RUN', plan.path, '作成予定。Driveは変更していません。']);
        return;
      }

      const result = ensureFolderPath_(rootFolder, plan.parts);
      logRows.push([new Date(), result.status, plan.path, result.message]);
    } catch (error) {
      logRows.push([new Date(), 'HOLD', plan.path, String(error.message || error)]);
    }
  });

  appendFolderLogs_(spreadsheet, config.LOG_SHEET, logRows);
  const holdCount = logRows.filter(function(row) { return row[1] === 'HOLD'; }).length;
  const summary = 'mode=' + (config.DRY_RUN ? 'DRY_RUN' : 'CREATE')
    + ', plans=' + plans.length
    + ', hold=' + holdCount;
  console.log(summary);
  spreadsheet.toast(summary, 'フォルダ計画', 8);
  return summary;
}

function readAndValidateFolderPlans_(sheet, config) {
  const lastRow = sheet.getLastRow();
  if (lastRow < 2) {
    throw new Error('作成予定がありません。');
  }

  const rowCount = lastRow - 1;
  if (rowCount > config.MAX_ROWS) {
    throw new Error('一度に処理できるのは' + config.MAX_ROWS + '行までです。');
  }

  const values = sheet.getRange(2, 1, rowCount, 2).getValues();
  const seen = {};
  const plans = [];

  values.forEach(function(row, index) {
    const enabledText = String(row[1]).trim().toUpperCase();
    if (![true, false].includes(row[1]) && enabledText !== 'TRUE' && enabledText !== 'FALSE') {
      throw new Error((index + 2) + '行目: enabled はTRUEまたはFALSEで指定してください。');
    }
    const enabled = row[1] === true || enabledText === 'TRUE';
    if (!enabled) return;

    const path = String(row[0] || '').trim();
    if (!path) {
      throw new Error((index + 2) + '行目: relative_path が空です。');
    }

    const parts = path.split('/').map(function(name) { return name.trim(); });
    if (parts.length > config.MAX_DEPTH) {
      throw new Error((index + 2) + '行目: 最大' + config.MAX_DEPTH + '階層までです。');
    }

    parts.forEach(function(name) {
      if (!name || name === '.' || name === '..') {
        throw new Error((index + 2) + '行目: 空または相対指定の階層名は使えません。');
      }
      if (name.length > 100 || /[\u0000-\u001f]/.test(name)) {
        throw new Error((index + 2) + '行目: 階層名が長すぎるか制御文字を含みます。');
      }
    });

    const normalized = parts.join('/');
    if (seen[normalized]) {
      throw new Error((index + 2) + '行目: 同じパスが重複しています。');
    }
    seen[normalized] = true;
    plans.push({ path: normalized, parts: parts });
  });

  if (!plans.length) {
    throw new Error('enabled がTRUEの作成予定がありません。');
  }
  return plans;
}

function getRootFolderSafely_(folderId) {
  const id = String(folderId || '').trim();
  if (!id || id === 'ここに作成先フォルダIDを入れる') {
    throw new Error('ROOT_FOLDER_IDを設定してください。');
  }
  try {
    return DriveApp.getFolderById(id);
  } catch (error) {
    throw new Error('作成先フォルダを確認できません。IDと権限を確認してください。');
  }
}

function ensureFolderPath_(rootFolder, parts) {
  let current = rootFolder;
  const actions = [];

  parts.forEach(function(name) {
    const matches = current.getFoldersByName(name);
    if (!matches.hasNext()) {
      current = current.createFolder(name);
      actions.push('作成:' + name);
      return;
    }

    const found = matches.next();
    if (matches.hasNext()) {
      throw new Error('同名フォルダが複数あります: ' + name);
    }
    current = found;
    actions.push('再利用:' + name);
  });

  return {
    status: actions.some(function(action) { return action.indexOf('作成:') === 0; }) ? 'CREATED' : 'EXISTS',
    message: actions.join(' / ')
  };
}

function appendFolderLogs_(spreadsheet, sheetName, rows) {
  let logSheet = spreadsheet.getSheetByName(sheetName);
  if (!logSheet) {
    logSheet = spreadsheet.insertSheet(sheetName);
    logSheet.appendRow(['executed_at', 'status', 'relative_path', 'message']);
  }
  if (rows.length) {
    logSheet.getRange(logSheet.getLastRow() + 1, 1, rows.length, 4).setValues(rows);
  }
}