Use this add-on to setup Google Sheet notifications when specific cells reach set values. Monitor Google Sheets with email or web hook notifications
Đã cập nhật trang thông tin:21 tháng 10, 2024
Hoạt động với:
498 N+
Tổng quan
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
£9.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. 
Thông tin bổ sung
GiáKhông mất phí khi dùng các tính năng có tính phí
Chính sách quyền riêng tư
Điều khoản dịch vụ
Magic Cell Notifications sẽ yêu cầu các quyền như trình bày bên dưới. Tìm hiểu thêm
Magic Cell Notifications sẽ cần có quyền truy cập vào Tài khoản Google của bạn
Điều này sẽ cho phép Magic Cell Notifications:
Xem, chỉnh sửa, tạo và xóa tất cả bảng tính của bạn trên Google Trang tính
Hiển thị và chạy nội dung web bên thứ ba trong lời nhắc và thanh bên ở trong các ứng dụng của Google
Kết nối với dịch vụ bên ngoài
Cho phép ứng dụng này chạy khi bạn không có mặt
Gửi email với tư cách là bạn
Xem địa chỉ email chính cho Tài khoản Google của bạn
Xem thông tin cá nhân của bạn, bao gồm mọi thông tin cá nhân mà bạn đã đăng công khai
Loading
Tìm kiếm
Xóa nội dung tìm kiếm
Đóng tìm kiếm
Các ứng dụng của Google
Trình đơn chính