Not so Magic Apps
•  178,776
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.
Reviews
Language:
Sort by:
Profile Picture
A User of Magic Cell Notifications
June 16, 2020
I have a google form collecting data. Am I able to have the email sent back based on accept/reject to the email that submitted the request?
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
June 15, 2020
ESTOU TENDO USAR AGORA
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
April 25, 2020
I like this product but it looks to be tied to the Google service quota of 100 emails per day - how can I get to send more than 100 emails per day ?. My requirement is around 250 Emails per day.
Is this review helpful?
Yes
No
Profile Pciture
A user of Magic Cell Notifications
May 14, 2020
Hi. Yes I am afraid it is tied to Google's quotas and I cannot do anything about this. If you have a G Suite Education/Business account you can send up to 1500 a day.
Profile Picture
A User of Magic Cell Notifications
April 23, 2020
Great add on - love it.
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
April 22, 2020
Not sure if it works on a mac
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
April 6, 2020
It Works Thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
March 29, 2020
great
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
March 10, 2020
Is it possible to schedule triggers to run at a specific time of the day? I want three separate triggers to run once a day at three different times
Is this review helpful?
Yes
No
Profile Pciture
A user of Magic Cell Notifications
May 25, 2020
+1 for this one
Profile Pciture
Sam Smith
May 3, 2020
Thinking about this –– Couldn't you create a trigger that says "when cell says 11:00am" run the trigger, then create some kind of formula that updates the cell every minute to whatever the time of day is? There's got to be a formula out there for that. Seems liek that would do it
Profile Pciture
A user of Magic Cell Notifications
April 17, 2020
I also want to use this for time and date. Happy, if this feature is added.
Profile Pciture
A user of Magic Cell Notifications
April 12, 2020
I am afraid this is not currently a feature of MCN. I will add it to the list of requested improvements. Many thanks. Hywel
Profile Picture
A User of Magic Cell Notifications
March 9, 2020
TypeError: Cannot call method “getRange” of null. I get this error when I do a notification
Is this review helpful?
Yes
No
Profile Picture
A User of Magic Cell Notifications
February 13, 2020
How do you edit a current rule?
Is this review helpful?
Yes
No
Profile Pciture
A user of Magic Cell Notifications
March 6, 2020
Hi. You can edit directly on the rules sheet worksheet
1-10 of 50
Additional information
Not so Magic Apps
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu