0

I'm using an app script to get data from cells and pass that data to API. So whenever a color gets the change we have to take that value pass in APIs and store response in G Column. Can someone help

function callNumbers() {
   
  // Call the Numbers API for random math fact
  var response = UrlFetchApp.fetch("http://numbersapi.com/random/math");
  Logger.log(response.getContentText());
   
  var fact = response.getContentText();
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange(sheet.getLastRow() + 1,1).setValue([fact]);
   
}
function onEdit(e) {
var row = e.range.getRow();
if (row > 1 && e.source.getActiveSheet().getName() === "Sheet1") {
   e.source.getActiveSheet().getRange(row, 14).setValue(new Date());
} else {
   if ((row > 1 && e.source.getActiveSheet().getName() === "Sheet2") || (row > 1 && e.source.getActiveSheet().getName() === "Sheet3")) {
       e.source.getActiveSheet().getRange(row, 6).setValue(new Date());
   }}}

0 Answers0