email notification if cell is changed

by

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)

More Related Contents:

  1. Copying a spreadsheet copies all linked files as well
  2. GAS “On edit” trigger not running when edited from API
  3. Moving google apps script to v8 file upload stopped working from sidebar
  4. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  5. How do I make a Sidebar display values from cells?
  6. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  7. button click is only working on Windows & not working on Android mobile sheet
  8. No permission to call msgBox in Google Apps Scripting
  9. Custom functions intermittently hang with “Error – Loading Data”
  10. How to define global variable in Google Apps Script
  11. Periodically refresh IMPORTXML() spreadsheet function
  12. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  13. Format a Google Sheets cell in plaintext via Apps Script
  14. UiApp has been deprecated. Please use HtmlService instead
  15. Google app scripts: email a spreadsheet as excel
  16. Is there a way to keep two sheets synchronized?
  17. Selecting the last value of a column
  18. Google apps script to email google spreadsheet excel version [duplicate]
  19. How to get filtered values from Filter after using setColumnFilterCriteria?
  20. Difference between getValue() and getDisplayValue() on google app script
  21. How to allow onEdit function to affect protected cell in a Google Sheet?
  22. Measurement of execution time of built-in functions for Spreadsheet
  23. onEdit() doesn’t catch all changes
  24. Google Spreadheets Scripts: check if cell is empty
  25. Custom Functions with add-ons?
  26. How to prefill Google form checkboxes?
  27. Converting .xls to google spreadsheet in google apps script
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment