NotebookLM用向け複数のPDF→Doc変換をSpreadSheet上で管理する

const tempName = '本文取得用一時ファイル';
const directory_id = '...................';
const directory_name = 'NotebookLM';
const spreadsheet = SpreadsheetApp.openById("...................");

function pdfToDocsWithBuiltInOCR(source) {
  Logger.log("変換対象:" + source + ".pdf")
  let fileId = getFileIdByName(source + ".pdf")
  let lmdoc = null
  let docs = null
  try {
    const resource = { title: tempName, parents: [{id: directory_id}]};
    const options = {
      ocr: true,
      ocrLanguage: "ja",
      fields: "id,title,parents",
      supportsTeamDrives: true, 
    };
    const tempFile = Drive.Files.copy(resource, fileId, options);
    docs = DocumentApp.openById(tempFile.getId());

    var files = DriveApp.getFilesByName(source);
    if (!files.hasNext() || files.next().getParents().next().getName() != directory_name) {
      Logger.log(source + "の作成を開始します。")
      let doc = DocumentApp.create(source);
      let file = DriveApp.getFileById(doc.getId());
      let destFolder = DriveApp.getFolderById(directory_id);
      file.moveTo(destFolder);
    }
    Logger.log(source + " DocにPDF内を転写します")
    lmdoc = DocumentApp.openById(getFileIdByName(source))
    lmdoc.getBody().setText(docs.getBody().getText())
    Logger.log(source + '.pdfをDocsに変換しました: ' + docs.getUrl());

    DriveApp.getFileById(docs.getId()).setTrashed(true)
  } catch (e) {
    if (docs != null) DriveApp.getFileById(docs.getId()).setTrashed(true)
    Logger.log('エラー: ' + e);
  }
  return lmdoc;
}

function getFileIdByName(fileName) {
  var files = DriveApp.getFilesByName(fileName);
  let fileId = null;
  try {    
    // ファイルが存在するか確認
    while (files.hasNext()) {
      var file = files.next();
      if (file.getName() != fileName) continue
      if (file.getParents().next().getName() == directory_name) {
        fileId = file.getId();
        Logger.log('ファイルID取得対象:' + file.getName())
        Logger.log('ファイルID: ' + fileId);
        break;
      }
    }
  } catch (e) {
    Logger.log('エラー: ' + e);
  }
  if (fileId == null) {
    Logger.log('ファイルが見つかりませんでした: ' + fileName);
  }
  return fileId;
}

function flattenArray(arr) {
  return arr.reduce((flat, toFlatten) => {
    return flat.concat(Array.isArray(toFlatten) ? flattenArray(toFlatten) : toFlatten);
  }, []);
}

function getSourceList() {
  let converter = spreadsheet.getSheetByName("Convert");
  let data_range = converter.getDataRange();
  const file_list = converter.getRange(2,1,data_range.getLastRow() - 1).getValues();
  return flattenArray(file_list);
}

function main() {
  let index = 1
  getSourceList().forEach(source => {
    let lmdoc = pdfToDocsWithBuiltInOCR(source)
    let converter = spreadsheet.getSheetByName("Convert");
    converter.getRange(index + 1, 2).setValue(lmdoc.getUrl());
    index += 1;
  });
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('カスタムメニュー')
      .addItem('Doc変換', 'main')
      .addToUi();
}