In Google Sheets, I would like to create an email notification rule whenever a new row contains a specific text, e.g. ".de".

However, as far as I can see, it is not possible to achieve this using the notification rules interface:

enter image description here

  • Please make an effort to follow the guidelines on How to Ask, otherwise looks that you are delegating the whole work to others, and that is not nice.
    – Rubén
    Feb 5 '17 at 17:17
  • Apologies, Ruben. I see your point and edited my question to improve it.
    – orschiro
    Feb 6 '17 at 13:31

I would do this with a google apps script tied to the onEdit trigger:

function onEdit(e) {
  var myWord = '.de';
  var myEmail = 'me@example.com';
  var cellData = e.range.getValue();
  if (cellData.indexOf(myWord)>-1){
    MailApp.sendEmail(myEmail, 'subject string', 'body string');
  • I haven't thought of a Google Apps Scripts approach but it works great. Thanks! :-)
    – orschiro
    Feb 6 '17 at 13:31

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .