Google Sheets App Script to retrieve github jobs

github_jobs.js

function fetchGHData_(description) {
  const url = "https://jobs.github.com/positions.json?description=" + description;
  const response = UrlFetchApp.fetch(url, { 'muteHttpExceptions': true });
  const json = response.getContentText();
  return JSON.parse(json);
}

function fillInTheBlanks() {
  const TITLE_COLUMN = 0;
  const COMPANY_COLUMN = 1;
  const LOCATION_COLUMN = 2;
  const COMPANY_LOGO_COLUMN = 3;

  const dataRange = SpreadsheetApp.getActiveSpreadsheet().getRange("A:D");
  const ghValues = dataRange.getValues();

  var ui = SpreadsheetApp.getUi();
  var description = ui.prompt("Digite uma palavra da descrição do anuncio");
  const ghData = fetchGHData_(description.getResponseText());

  for (let row = 0; row < ghData.length; row++) {
    const url = ghData[row].company_logo;

    ghValues[row][TITLE_COLUMN] = ghData[row].title;
    ghValues[row][COMPANY_COLUMN] = ghData[row].company;
    ghValues[row][LOCATION_COLUMN] = ghData[row].location;
    ghValues[row][COMPANY_LOGO_COLUMN] = `=IMAGE("${url}")`;
  }
  dataRange.setValues(ghValues);
}