email notification if cell is changed

Question

need help with google script. I have multiple row spreadsheet. Need a script that does the following: If any cell in column G has been changed, then send email notification to custom address with information from this row: information from cell D and new value of cell G. UPD I found useful information: ``` function emailNotification() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var cell = ss.getActiveCell().getA1Notation(); var cellvalue = ss.getActiveCell().getValue().toString(); var recipient = "me@gmail.com"; var subject = 'Update to '+sheet.getName(); var body = sheet.getName() + ' has been updated. Visit ' + ss.getUrl() + ' to view the changes on cell: «' + cell + '» New cell value: «' + cellvalue + '»'; MailApp.sendEmail(recipient, subject, body); }; ``` This script tracks the changes in the entire table. And I would like track changes only in column G, and get values ​​from column D. Question: How to get the value of the cell in column D w…

Accepted Answer

You should search this forum before posting questions; I did search on email+cell and got a few results :

For example, this post answer does almost exactly what you want to do.

EDIT following your edit :

use an `IF` condition.

Something like this :

```
    var cellG = ''
    if(cell.indexOf('D')!=-1){ // = if you edit data in col D
cellG = sheet.getRange('G'+ sheet.getActiveCell().getRowIndex()).getValue()
// add more condition if necessary and/or send your mail (cellG contains the value in column G of the active row
}
    Logger.log(cellG)
```

email notification if cell is changed

Solution

Problem