appsscript_api.gs

function addMenu() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Datanews API')
      .addItem('Get News','myFunction')
      .addToUi();
}

function myFunction() {
  var API_KEY = "your api key";
  var url = "http://api.datanews.io/v1/headlines?q=travel&apiKey=" + API_KEY;
  var response = UrlFetchApp.fetch(url);
  var data = JSON.parse(response.getContentText());
  var results = data.hits;

  var sheet = SpreadsheetApp.getActiveSheet();
    
  var header = ["Title", "Description", "URL", "Published Date"]
  var items = [header];

  results.forEach(function (result) {
      items.push([result.title, result.description, result.url, result.pubDate]);
  });
  sheet.getRange(1,1,items.length,items[0].length).setValues(items);
}

I have a question, line 13, hits? My code is not running, forEach is undefined. I guess hits is incorrect...