Subeta

function onOpen(e){
  SpreadsheetApp.getUi().createMenu('Subeta')
    .addItem('Run', 'Subeta')
    .addToUi()
}

function Subeta() {
  console.time('Start20');
  const activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1')
  //const values = activeSheet.getRange(2,1,activeSheet.getLastRow() -1).getValues().flat();
  const values = activeSheet.getRange(2,1,20).getValues().flat();

  const output = [];

  values.forEach(item => {
    try{
    const res = UrlFetchApp.fetch(encodeURI(`https://www.subetalodge.us/view/item/${item}`))
    const html = res.getContentText();
    const price = /Official Price<\/b>:(.*?)sP/gmis.exec(html)[1];
    console.log(price)
    output.push([Number(price.trim().replace(',','.'))]);
    } catch (err){
      output.push(['Error'])
    }
  })

  activeSheet.getRange(2,7, output.length, 1).setValues(output);
  console.timeEnd('Start20');
}