问使用google应用程序脚本从web地址的pdf文件中提取文本，并将其插入Google工作表中。

EN

const FOLDER_ID = ""; //Folder ID of all PDFs
const SS = "";//The spreadsheet ID
const SHEET = "MSCI";//The sheet tab name


function OpenFile() {
 var url = "https://www.yardeni.com/pub/mscipe.pdf";
  
  var blob = UrlFetchApp.fetch(url).getBlob();
  var resource = {
    title: blob.getName(),
    mimeType: blob.getContentType()
  };

  // Enable the Advanced Drive API Service
  var file = Drive.Files.insert(resource, blob, {ocr: true, ocrLanguage: "en"});

  // Extract Text from PDF file
  var doc = DocumentApp.openById(file.id);
  var text = doc.getBody().getText();
  
return text;

const identifier = {
    start: `Emerging Markets (`,
    start_include: false,
    end: `)`,
    end_include: false
  };
  let results = getDocItems(docID, identifier);
  return results;
  }

function importToSpreadsheet(results){
  const sheet = SpreadsheetApp.openById(SS).getSheetByName(SHEET);
 
  var cell = sheet.getRange("B2");
  cell.setValue(results);
}