setValues from JSON array to spreadsheet

I'm stuck trying to copy the values from my JSON scraping script to spreadsheet.

Does anyone know how to do that?

I'm stuck trying to know how to get the "longname" values to the memory and then using setValue once at the end.

I need to paste all the values here at the column B.

First I'm trying to resolve a single column, later I will need to paste a multi dimensional array to multiple columns. But that's only if I solve this.

Just a detail, on columnWithTickers I used only a range of 5 rows for testing purposes. Later I will use a dynamic value.

Code:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var page1 = ss.getSheetByName("pag1");
let columnWithTickers = page1.getRange(2, 1, 5).getValues();
let targetColumn = page1.getRange(2, 2);


function printValuesFromJSON() {
  if (!Array.isArray(columnWithTickers)) {
    columnWithTickers = [[columnWithTickers]]
  }

  return columnWithTickers.map(tickers => {
    try {

      values = tickers[0].toString().split(",");
      let url = `https://finance.yahoo.com/quote/${values}.SA/key-statistics?p=${values}.SA`;
      let source = UrlFetchApp.fetch(url).getContentText()
      let jsonString = source.match(/root.App.main = ([\s\S\w]+?);\n/)
      if (!jsonString || jsonString.length == 1) return;
      let data = JSON.parse(jsonString[1].trim());
      let longname = data.context.dispatcher.stores.QuoteSummaryStore.price.longName.split();

      /*let resultados = longname.map(vetor =>{
        return ativosResultados = vetor[0].toString();     
      })*/

    }
    catch (error) {
      return "N/A"
    }
  }

  )

}

You can try the below function:

function attDiarios(){
  var result = intervaloTickers.map(tickersAtuais => 
    {      
      ativosFinais = tickersAtuais[0].toString().split(" ")

      let url = `https://finance.yahoo.com/quote/${ativosFinais}.SA/key-statistics?p=${ativosFinais}.SA`;
      let source = UrlFetchApp.fetch(url).getContentText()
      let jsonString = source.match(/root.App.main = ([\s\S\w]+?);\n/)
      if (!jsonString || jsonString.length == 1) return null;
      let data = JSON.parse(jsonString[1].trim());    
      try{
        var longNameValue = data.context.dispatcher.stores.QuoteSummaryStore.price.longName;
        }
      catch(err){
        var longNameValue = 'N/A';
      }
      return [[longNameValue]]
    }
  )
  sImport.getRange(5, 2, result.length, result[0].length).setValues(result);
}