NSF data additions in Google Sheets via Google Script and the NSF API

nsf-data-adding.js

function writeEstimates() {
  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheets = ss.getActiveSheet();
  let allIds = sheets.getRange('a2:a100').getValues();
  var row = 2;
  allIds.forEach((element) => {
    //Logger.log(element[0].toFixed(0))
    let estimate = fetchData(element)
    sheets.getRange("z"+row).setValue(estimate);
    row++;
  })


}


function fetchData(id){
  let url = `https://api.nsf.gov/services/v1/awards.json?id=${id}&printFields=awardee,title,fundsObligatedAmt,date,abstractText,awardee,id,agency,fundProgramName,estimatedTotalAmt`;
  let response = UrlFetchApp.fetch(url);
  let json = JSON.parse(response.getContentText());
  let est = json.response.award[0].estimatedTotalAmt;
  return est;
}