When you share a spreadsheet in Google Sheets, youâll want to see the changes others make. You could check the version history, but to stay on top of things in real-time, getting notifications about each change is much more efficient.
Set Up Notifications in Google Sheets
You can enable notifications for changes to Google Sheets with a couple of options. So, open your spreadsheet and click Tools> Notification Rules from the menu.
Now youâll see that you have the option to receive an email when any changes are made or when a user submits a form (if you have a Google Form connected to your Google Sheet).
You can also choose to receive a daily digest or an email right away. The daily digest will wrap up the changes or submissions into one email whereas the other will immediately notify you.
Make your selections and hit âSave.â
Receive the Notification Email
To see an example of the notification youâll receive, check out the screenshot below. It displays the user who made the change along with the date and time. You can also use the âClick Hereâ links to view the edits or see the current version of the spreadsheet.
Again, if you choose to receive a daily digest instead of an immediate email, youâll see all changes made in a single message.
Edit, Remove, or Add Notifications
You can edit a notification rule you create, delete one, or add more. Head to the same spot, Tools> Notification Rules.
- To change an existing rule, click âEditâ next to it, make your changes, and click âSave.â
- To remove a rule, click âDeleteâ and then confirm by clicking âOKâ in the pop-up window.
- To set up another rule, click âAdd Another Notification Rule,â make your selections, and click âSave.â
Notifications in Google Sheets keep you up to date with any changes others make. And remember, you can also see changes to a particular cell in Sheets.