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.

Comments

  1. Over the past few months I've been working on a free app for Google Sheets that expands on the built in functionality that Google Sheets has for sending notifications. Would love to know your thoughts or if you have any questions/feedback.

    You can see details at: https://checksheet.app

    ReplyDelete

Post a Comment

Popular posts from this blog

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

Google Sheets - Flipping Your Rows & Columns

Google Forms - Copy Summary Graph/Diagram to Use Elsewhere

Google Script - Create Calendar Events from Spreadsheet Data

Google - Reset a Form for Reuse with the new School Year