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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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