0

I am fetching data from ndtv profit, I would like to get an alert for any new row updated in the table. I have 'send mail' functions. which the event funtion needs to use to get the data on increase row from importhtml.

enter image description here

1 Answer 1

1

I got the solution.

var inc1=IoI.getRange(13,9).getValue();----------- Got row count cell
  var inc2=IoI.getRange(14,9).getValue(); 

if(inc1!==inc2)

  {
 IOincincsendMail();
    IoI.getRange("i14").setValue(inc1)
  }
1
  • The answer will be better if you describe how the code solves the issue and even better is you include a complete function in order to show how do your script assigns a sheet object to IoI. Commented Mar 1, 2018 at 0:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.