Google Sheets ZW App Script old

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Menu')
    .addItem('Import Text Files', 'importTextFiles')
    .addItem('Extract Markdown Info', 'extractMarkdownInfo')
    .addToUi();
}

function importTextFiles() {
  var ss = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1rFVnOALJjVzS-RUwVxt6TFwCvjOlyFFP3CFjXeBHtso/edit#gid=0');
  var sheet = ss.getSheetByName('ZW import'); // Change Sheet1 to your sheet's name if it's different
  var folder = DriveApp.getFolderById('1o743ScrSFmnztwL5PBbxmd2mFclPiidO'); // Change 'folderID' with your Google Drive Folder ID where the text files are located
  var files = folder.getFilesByType(MimeType.PLAIN_TEXT);
  var i = 2; // Start at cell A2
  while (files.hasNext()) {
    var file = files.next();
    var text = file.getBlob().getDataAsString();
    sheet.getRange('A' + i++).setValue(text);
  }
}

function extractMarkdownInfo() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('ZW import'); // change this to the name of your sheet if different

  var dataRange = sheet.getRange("A2:A");
  var data = dataRange.getValues();

  for (var i = 0; i < data.length; i++) {
    var markdownText = data[i][0];
    var lines = markdownText.split("\n");

    for (var j = 0; j < lines.length; j++) {
      var line = lines[j];

      if (line.startsWith("@ Main model used:")) {
        sheet.getRange(i + 2, 2).setValue(line.replace("@ Main model used:", "").trim());
      } else if (line.startsWith("@ OpenAI Status:")) {
        sheet.getRange(i + 2, 3).setValue(line.replace("@ OpenAI Status:", "").trim());
      } else if (line.startsWith("@ Settings used:")) {
        sheet.getRange(i + 2, 4).setValue(line.replace("@ Settings used:", "").trim());
      } else if (line.startsWith("@ Midjourney AI Image Prompt:")) {
        sheet.getRange(i + 2, 5).setValue(line.replace("@ Midjourney AI Image Prompt:", "").trim());
      } else if (line.startsWith("@ Meta Description:")) {
        sheet.getRange(i + 2, 7).setValue(line.replace("@ Meta Description:", "").trim());
      } else if (line.startsWith("# ")) {
        sheet.getRange(i + 2, 8).setValue(line.replace("#", "").trim());
      }
    }
  }
}