Arrow
Back to guides
Google Sheets Tips

How to Set Up Notifications in Google Sheets

In this article, you will learn how to change notification settings in Google Sheets.

Learn what notifications are and how to collaborate with other editors in Google Sheets.

What is a notification in Google Sheets?

A notification in Google Sheets is a message or alert triggered by a specific event in a spreadsheet, such as when a cell is edited or a form is submitted. Notifications can be sent to your email address.

Notifications can help keep track of changes in a spreadsheet and alert other people when certain events occur. For example, you could set up a notification to alert your team when a new row is added to a data tracking sheet or when a form is submitted with new customer information.

To set up notifications in Google Sheets, you can use the "Notification settings" feature in the "Tools" menu. This allows you to create rules for different events and recipients, and to customize the delivery method for each rule. You can learn how to change the settings in the following section.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

How to change notification settings in Google Sheets

To set up notifications in Google Sheets, follow these steps:

  1. Open the Google Sheets file that you want to receive notifications for.

  1. Click on the "Tools" menu at the top of the screen, and then click on "Notification settings".

  1. Select “Edit notifications” or “Comment notifications”. The former item brings up the “Set notification rules” window. The latter choice shows the “Notification settings” window.

  1. In the "Set notification rules" field, you can change the timing and frequency of receiving notifications (see the picture below for available choices)

  1. In the "Notification settings" field, you can determine what type of comments are informed of to you. (see the picture below for available choices)

  1. Click the "Save" or “OK” button to save the notification rule.

You can change the notification settings whenever you want.

change notification settings from the menu bar
How to change notification settings from the menu bar in Google Sheets

“Set notification rules” window looks like
What the “Set notification rules” window looks like in Google Sheets

“Notification settings” window looks like
What the “Notification settings” window looks like in Google Sheets

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below