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.

Click Tools, Notification Rules

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.”

Set up a notification rule in Google Sheets

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.

Notification email

Advertisement

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.”

Edit, Delete, or Add a Notification Rule

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.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.