Get data from cell and pass to app script and run API when cell gets update

Viewed 13

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 Answers
Related