coronatracker.gs

//inspired by https://www.benlcollins.com/apps-script/api-tutorial-for-beginners/

// custom menu
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Load Corona')
      .addItem('Get New Data','loadAllData')
      .addToUi();
}
 
function callAPI(country) {
  
  // Call Covid API
  var response = UrlFetchApp.fetch("https://api.covid19api.com/total/country/" + country + "/status/deaths");
  
  // Parse the JSON reply
  var json = response.getContentText();
  return JSON.parse(json);
  
}
 
 

function displayCountryData(country) {
  
  var sheet = SpreadsheetApp.getActive().getSheetByName(country)
  
  var results = callAPI(country);
  
  var output = []
  
  var index = 1;
  results.forEach(function(elem,i) {
    if(elem["Cases"] >= 20)
    {
       output.push([index,elem["Cases"],elem["Country"]]);      
       index++;
    }
  });
  
  
  
  var len = output.length;
  
  // clear any previous content
  sheet.getRange(2,1,1000,3).clearContent();
  
  // paste in the values
  sheet.getRange(2,1,len,3).setValues(output);  
}

function loadAllData()
{
    var countries = ["Brazil","Spain","Us","Italy","Israel"];
    countries.forEach(function(elem,i) {
         displayCountryData(elem);
    });
}