Use this add-on to setup email notifications on a Google Sheets when specific cells reach set values. Monitor Google Sheets with email or web hook notifications
Listing updated:March 17, 2024
Works with:
445K+
Overview
Use Magic Cell Notifications to monitor cells within your Google Sheet and automatically notify you via email or webhook such as Slack/Discord/Google Chat/Microsoft Teams 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#heading=h.2dlkaj15y0ks

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 web hooks and it has been tested and also works with Slack, IFTTT (76 characters), Zapier, Discord, Google Chat & Microsoft Teams. 

**Paid Features**

Magic Cell Notifications has now become a subscription service for all of the features available. The free version (Basic) still exists and should solve many users' needs however the Basic version is limited by the number of each type of rule you can have. 

Basic Free Version
Single & Multi Rules - Limited to 5 rules
Column, Row & Range Rules - Limited to 1 rule

Annual Subscription Chargers
£5.99 per year single user (Unlimited Rules)
£59.99 per year domain* wide subscription (Unlimited Users & Rules)

* Domain subscriptions cannot be for ‘gmail.com’ accounts but where you have a paid Google Domain and you would like all users to have Full accounts. 
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Magic Cell Notifications will ask for the permissions shown below. Learn more
Magic Cell Notifications will need access to your Google account
This will allow Magic Cell Notifications to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Ellie Clare
April 14, 2024
Magic Cell was a great solution to a communication problem I had with outsourcing tasks. It is relatively simple to set up and affordable for businesses who aren't ready or can't afford to invest in a collaboration system, like Monday or Trello etc... Highly recommend this if this is where your business is at. While I don't use it now, it was a great stepping stone in my business. Thanks
Is this review helpful?
Yes
No
Profile Picture
Daniel SIlver
March 14, 2023
Love this simple and focused little app. We use it in our issues tracking sheets. So easy to enhance it with lookup functions or any other Sheet function (for example to set an email to only go out to someone who reported an Issue.) Does exactly what we need and it's fun to play with. Also, quick and skilled support from the dev!
Is this review helpful?
Yes
No
Profile Picture
Usmani Abdullah
January 31, 2023
Great Add on! It has been beneficial for our ongoing sheet notification to our team members with low cost. Initially, it will take a bit of time to understand, but once you understand, then it'll be easy, and smooth for you. If you face any kind of problem, you can always contact the support team. They are very helpful!.
Is this review helpful?
Yes
No
Profile Picture
Leah Reynolds
January 17, 2023
This has been a great add-on for our school to manage student check-in. I had a few learning issues initially, but support was quick and very helpful. I would recommend this to anyone.
Is this review helpful?
Yes
No
Profile Picture
Blair Logan
May 13, 2023
Outstanding! Crazy fast support and a real willingness to help out. 5 stars all the way
Is this review helpful?
Yes
No
Profile Picture
Heather Kelly
March 9, 2021
Frustrated. I set this up on several workbooks, tested it and it worked great last fall. Today I learned it stopped working and I'm not sure why. I've emailed the developer. We use this to notify us of maintenance that is due on various machines and we missed maintenance on one machine by over 2,000 hours! It's great when it works but sadly, it seems to have stopped. I pushed a manual check through each of my sheets and the notifications fired but I don't want to have to manually do that, hence the use of the plug in.
Is this review helpful?
Yes
No
Profile Picture
Matt Cox
November 15, 2021
Great little Add-on that does exactly what It should with lots of customisation. One issue that makes it not quite perfect for my application is the time frame of updates being up to an hour at minimum. Would it be possible to set this to specific time frame rather than just daily or hourly? For my purpose 10 minutes, possibly even 1 minute would be ideal. I am tracking events that happy rarely, but when it does occur, I need to know asap. Thanks
Is this review helpful?
Yes
No
Profile Picture
jesus christos
May 16, 2021
Has anyone figured out why this isn't working anymore? I get an initial email but then after that the hourly and daily checks don't work. Even the manual check doesn't work. Thanks! Mike
Is this review helpful?
Yes
No
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 Picture
A User of Magic Cell Notifications
January 28, 2020
Really handy Add-on. Though I am looking for a bit more control. I want an email to be sent if a date in a column is within the next 2 weeks. I've found a formula format a cell in red when this is the case but really need an alert too. Any ideas?
Is this review helpful?
Yes
No
1-10 of 62
Search
Clear search
Close search
Google apps
Main menu