Google Sheets - Notifications

Google Sheets icon




Have you ever wondered how you can get notifications when changes are made by others to a Google Spreadsheet?  It's very easy to setup.

If you go to the Tools Menu, select Notification rules... -
location of notification rules

You have 2 options to select from in the pop-up window.  The first is if you want all changes made to the spreadsheet or just when a form is submitted (this second option can also be set up in the form, if one is connected to the spreadsheet).  The second is if you want a daily notification or an email each time a changes occurs.  Once setting these, click Save -
set notification rules window

After you have set the notifications, you will receive an email that looks like this -
sample email sent when changes are made

If the email is not in your inbox, check your Spam/Junk as it is coming from Good Docs, not the person that made the changes.  Also, you will not receive notifications for the changes you make yourself.

Popular posts from this blog

Google Script - Create a Drop-Down List from Spreadsheet Column

Google Calendar - How to Share Your Calendar Via Link

2019 MACUL Conference Tipsheet #1 - Food Tips & Special Events

Google Contacts - Newest Area to Get Some "Google Love"

Google Slides - Rulers & Guides