App Icon
Not so Magic Apps
•  313,924
Overview
Use this add-on to setup email notifications on a Google Sheet when specific cells reach set values.
Use Magic Cell Notifications to monitor cells within your Google Sheet and automatically notify you via email or Slack when pre-set criteria or values are reached. The applications for this add-on are vast and the additional options allow for personalisation and flexibility to meet your needs.

There are 4 different types of monitoring that you can setup using MCN

1. Single cell notifications (Monitor one specific cell)
2. Row (Monitor an entire row)
3. Column (Monitor an entire column)
4. Range (Monitor a specific range of cells)

Each one of these methods allows you to monitors cells using the following criteria:

equal to
greater than  
less than  
not equal to
changes
contains

When using this add-on you can load a sidebar menu to set up notification rules on your Google Sheet. You can add as many rules as you like and the add-on will keep a track of them on a dedicated worksheet. You can view this worksheet and even amend the rules directly on the sheet. 

Once the spreadsheet is changed and the values reach the notification rules you have set you will automatically receive an email/Slack notification to inform you. You can also add multiple email addresses to one notification rule simply by separating them by a comma. If you are using email notifications you can now also add CC and BCC addresses to your notifications easily 

MCN runs on 4 occasions, which you can turn on and off using the menu, and these are the triggers of the add-on. 

1. Edit (A user edit to the Google Sheet)
2. Form Submission (A linked Google Form is submitted)
3. Hourly (Once per hour)
4. Daily (Once a day)

You can also personalise the email or Slack notifications using your own text and can even use HTML to format and improve the look and layout of your messages. MCN also gives you the ability to insert fields from your Google Sheet directly into the email but please see the user guide for more information on what fields you can insert:

https://docs.google.com/document/d/1-v-s7V9RKpEorHYlqfzee1USJPUSFnHs7OF33sijqoQ/edit?usp=sharing

Additional features of the add-on include the ability to turn off and deactivate rules from your rule sheets at the click of a button. You can now get MCN to highlight in your worksheets where the latest match or change has taken place. MCN does Slack webhooks and it has been tested and also works with IFTTT (76 characters) and Zapier. 

**New updates release (2/8/20) which now give extra email options of No Reply, Reply To and Sender Name**
Reviews
Language:
Sort by:
Profile Picture
Eric Lorenz
January 8, 2021
Does this only work for number values? What if I use data validation to create drop-down menus and I'd like a notification when something changes form "no" to "yes"
Is this review helpful?
Yes
No
Profile Picture
Habib Bouazzi
January 8, 2021
Habib, NGS engaged Biologist
Is this review helpful?
Yes
No
Profile Picture
Danielle Sullivan
December 15, 2020
This was an awesome add-on but stopped working. I've had to re-set the app multiple times, click on run for first time, launch etc multiple times. as soon as I close out the window and try to use it the next day, it doesn't trigger the emails and I have to go through and re-set it all over again. I'm so sad, this was an awesome add-on when it worked!
Is this review helpful?
Yes
No
Profile Pciture
Dương Phạm
February 6, 2021
Yea. I also got the same problem. Hope they can fix it soon because this is such an awesome add-on.
Profile Picture
Hailey Davis
December 9, 2020
I used this all last semester and now it won't work. It says Exception: This add-on has created too many edit triggers in this document for this Google user account. I can't find any information on this error at all anywhere
Is this review helpful?
Yes
No
Profile Pciture
Arunkumar Sivaraman
December 14, 2020
Check if in the rule you have your column as 'A1:A'. If you set it as 'A1:A100' it should work
Profile Picture
Samson Assefa
December 1, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Angelo Parao
November 22, 2020
Thank you for the awesome add-on. Is there an option to change the frequency of the (hourly) trigger for automated changes?
Is this review helpful?
Yes
No
Profile Picture
Sadiq Muhammad
October 18, 2020
How can I change the email that sends the alert email? I was editing the sheet on a personal email account, and I want to make it a work-related email account.
Is this review helpful?
Yes
No
Profile Picture
walid kheriji
September 25, 2020
Hi, The add-on is not working, this is the error I get "TypeError: Cannot call method "getLastRow" of null." Any help please? Thanks
Is this review helpful?
Yes
No
Profile Picture
Adam Miller
September 22, 2020
I am setting this up to use and I am getting. matches in the "Column Notification Rules" tab but even in the tab it is saying 0 emails sent. I don't understand why when I have a match, the emailing is not sending. I think this is a fantastic app and I am glad that it is offered but so far I cannot get it to work.
Is this review helpful?
Yes
No
Profile Pciture
Abby Fox
September 30, 2020
Did you ever get this working? I'm having the exact same issue.
Profile Picture
Bonnie Kirchoff
September 7, 2020
Was working great now when setting up to email in a new sheet I am getting "TypeError: Cannot call method "getLastRow" of null". I do not know what this means and I am not able to set up the notifications?
Is this review helpful?
Yes
No
1-10 of 59
Additional information
Not so Magic Apps
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu