function getData() { var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");

var queryString = Math.random(); var cellFunction = '=IMPORTHTML("https://www.investing.com/technical/commodities-technical-summary","table",4)'; var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss"); sheetName.getRange('A1').setValue(cellFunction); sheetName.getRange('g2').setValue(datetime); }

function sendNotification() { var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");
//if("D13" == sheetName.range.getA1Notation() || "D12" == e.range.getA1Notation()) { if("C13" == "Strong Buy" and "h13"=now() diff 1 minutes) {

//Define Notification Details var recipients = "[email protected]"; var subject = "Update"+e.range.getSheet().getName(); var body = "cell C13 has been updated";

    var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss");
  sheetName.getRange('H13').setValue(datetime); 
  

//Send the Email MailApp.sendEmail(recipients, subject, body); } }

function getData() { 
  var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main"); 
  
  var queryString = Math.random(); 
  var cellFunction = '=IMPORTHTML("https://www.investing.com/technical/commodities-technical-summary","table",4)';
  var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss");
    sheetName.getRange('A1').setValue(cellFunction); 
  sheetName.getRange('g2').setValue(datetime);
}

function sendNotification() {
    var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");   
  //if("D13" == sheetName.range.getA1Notation() || "D12" == e.range.getA1Notation()) {
    if("C13" == "Strong Buy" and "h13"=now() diff 1 minutes) {


      
  //Define Notification Details
      var recipients = "[email protected]";
      var subject = "Update"+e.range.getSheet().getName();
      var body = "cell C13 has been updated";
      
        var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss");
      sheetName.getRange('H13').setValue(datetime); 
      
  //Send the Email
      MailApp.sendEmail(recipients, subject, body);
    }
  }

I have configured to fetch the data on every 1 min from investing wesite.

The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong sell or strong buy time on time and date column the functions are not working. please find below requirement.

1. I need to update time and date in G column when D column update from the website either Strong sell or strong buy.
2. once the time and data updated if the time and date less then 1 minute then need to get email alerts.

I have tried functions on the table but not working. kindly help me on this why the functions are not working .onchange .onedit.

I have configured to fetch the data on every 1 min from investing wesite.

The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong sell or strong buy time on time and date column the functions are not working. please find below requirement.

1. I need to update time and date in G column when D column update from the website either Strong sell or strong buy.
2. once the time and data updated if the time and date less then 1 minute then need to get email alerts.

I have tried functions on the table but not working. kindly help me on this why the functions are not working .onchange .onedit.

I am using below query but i am not getting alert.

function getData() { var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");

var queryString = Math.random(); var cellFunction = '=IMPORTHTML("https://www.investing.com/technical/commodities-technical-summary","table",4)'; var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss"); sheetName.getRange('A1').setValue(cellFunction); sheetName.getRange('g2').setValue(datetime); }

function sendNotification() { var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main");
//if("D13" == sheetName.range.getA1Notation() || "D12" == e.range.getA1Notation()) { if("C13" == "Strong Buy" and "h13"=now() diff 1 minutes) {

//Define Notification Details var recipients = "[email protected]"; var subject = "Update"+e.range.getSheet().getName(); var body = "cell C13 has been updated";

    var datetime = Utilities.formatDate(new Date(), "IST", "yyyy/MM/dd HH: mm:ss");
  sheetName.getRange('H13').setValue(datetime); 
  

//Send the Email MailApp.sendEmail(recipients, subject, body); } }