In this article, you will learn how to turn on Google Sheets notifications to inform you about any changes made to the spreadsheet. Additionally, you\u2019ll learn how to configure this feature based on the type of change and how you\u2019d like to be notified. You’ll also see how to switch to a daily digest, how to set up alerts for specific changes, and whether people are notified when you remove their access.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Why get Google Sheets notifications?<\/h2>\n
We tend to use Google Sheets to make use of the collaborative framework it offers. More often than not we let other people access our files and make changes. If not for the notifications, we will have to access the file ourselves and check for the changes manually in the version history. But that doesn\u2019t keep us abreast of things going in the Google Sheets file. Some of us may want to immediately get notified of any changes that any of the other users make.<\/p>\n
Notification rules track edits to the spreadsheet. Comments have separate notification settings, so if your team leaves feedback in comments, read about the differences between notes and comments in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-get-notified-when-a-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In Google Sheets, you can get notified whenever other users make changes to the spreadsheet. You can set up notification rules based on the type of change and the frequency of notification. This is how you can easily set up your own notification rules in Google Sheets.<\/p>\n Notification rules in Google Sheets are based on four options that can be combined based on your needs (see image below). Before enabling your first notification rule, you\u2019ll understand what each notification option can do for you.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-rule-options.webp” alt=”Google Sheets notifications \u2014 Set notification rules dialog with the Notify me at\u2026 when and Notify me with options” title_text=”Set notification rules dialog with the Notify me at\u2026 when and Notify me with options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The options under \u201cNotify me at X when\u2026\u201d refer to what type of change in the spreadsheet will trigger the notification. There are two options:<\/p>\n 1. \u201cAny changes are made\u201d:<\/strong> This is the preferred option in case you\u2019d like to be notified as soon as any change is made to the spreadsheet. It\u2019s also the best way to avoid redoing or undoing someone else\u2019s work.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-any-changes-are-made.webp” alt=”Google Sheets notifications \u2014 Any changes are made selected in the Set notification rules dialog” title_text=”Any changes are made selected in the Set notification rules dialog” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. \u201cA user submits a form\u201d:<\/strong> This option is useful in case you\u2019ve created a Google Form for people to sign up for an event. Each submission will create a new row of data, and you\u2019ll receive email notifications only when a user submits the form to sign up.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-rules-dialog.webp” alt=”Google Sheets notifications \u2014 Set notification rules dialog in an empty spreadsheet with Email – daily digest selected” title_text=”Set notification rules dialog in an empty spreadsheet with Email – daily digest selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this group of options, you can determine when you\u2019d like to receive the email once the user has changed the Google Sheets file. There are also two options:<\/p>\n 1. Email – daily digest:<\/strong> Select this option if you\u2019d prefer to receive a daily summary of all changes\u200c. It\u2019s especially recommended to avoid filling your inbox with emails!<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-email-daily-digest.webp” alt=”Google Sheets notifications \u2014 Email – daily digest selected under Notify me with” title_text=”Email – daily digest selected under Notify me with” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. Email – right away:<\/strong> Select this option if you\u2019d like to receive notifications on a separate email for every change as soon as it\u2019s made.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-email-right-away.webp” alt=”Google Sheets notifications \u2014 Email – right away selected under Notify me with” title_text=”Email – right away selected under Notify me with” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you\u2019ve seen what each option means, let\u2019s see how you can turn on these notification rules.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-turn-on-notifications-for-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Although it\u2019s an easy process, remember that you can only do this for yourself; other users will need to set up their own notifications.<\/p>\n 1.<\/strong> Open your spreadsheet and go to Tools > Notification settings > Edit notifications. Older versions of Google Sheets call this menu item Notification rules, as in the screenshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-tools-menu.webp” alt=”Google Sheets notifications \u2014 Tools menu open with Notification rules highlighted” title_text=”Tools menu open with Notification rules highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In the \u201cSet notification rules\u201d settings box, you can choose among the four options, as explained in the previous section. Make sure you select one of each. Once you do, click \u201cSave\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-click-save.webp” alt=”Google Sheets notifications \u2014 Any changes are made and Email – daily digest selected, with the Save button” title_text=”Any changes are made and Email – daily digest selected, with the Save button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n From then on, Google Sheets emails you when the spreadsheet changes, or once a day if you chose the daily digest. The email tells you who edited the file and links to the spreadsheet.<\/p>\n If you’re working on a Google Sheet with multiple editors that frequently update the document, you may want to review the changes by using Google Sheets Edit History<\/a>, located in File > Version history > See version history.<\/p>\n [\/et_pb_text][et_pb_text module_id=”modify-notification-rules-in-google-shee” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Making changes to the notification rules is also very easy, as there\u2019s very little to set up. Here, you\u2019ll learn how to add, edit, and delete your current notification rules.<\/p>\n Since notification rules allow for several combined options, \u200cyou can create different rules and then turn on whichever you think is relevant for a specific time or spreadsheet.<\/p>\n 1.<\/strong> Go to Tools > Notification settings > Edit notifications, as in the previous step.<\/p>\n 2.<\/strong> In the \u201cSet notification rules\u201d you should be able to see all notification rules you created.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-rule-list.webp” alt=”Google Sheets notifications \u2014 rule list showing If any changes are made then send email, with Edit and Delete” title_text=”Rule list showing If any changes are made then send email, with Edit and Delete” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> To add another notification rule, click on the \u201cAdd another notification rule\u201d and select the option you wish to add.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-add-another-rule.webp” alt=”Google Sheets notifications \u2014 Add another notification rule link below a form-submitted digest rule” title_text=”Add another notification rule link below a form-submitted digest rule” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You\u2019ll be taken to a \u201cSet notification rules\u201d window where you can customize the new notification rule.<\/p>\n Let\u2019s say you\u2019ve created a notification rule for \u201cEmail – right away\u201d and find that your inbox fills up too quickly. This is how you can easily edit a notification in Google Sheets.<\/p>\n 1.<\/strong> Go to Tools > Notification settings > Edit notifications.<\/p>\n 2.<\/strong> Click on \u201cEdit\u201d to change when or how you want to be notified of changes.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-edit-rule.webp” alt=”Google Sheets notifications \u2014 Edit and Delete links next to the If form submitted then send digest email rule” title_text=”Edit and Delete links next to the If form submitted then send digest email rule” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Select any other option to change the current notification rule. Don\u2019t forget, that this rule will overwrite the previous one. Click \u201cSave\u201d once you finish updating the changes.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-change-rule.webp” alt=”Google Sheets notifications \u2014 editing a rule to A user submits a form and Email – daily digest, then Save” title_text=”Editing a rule to A user submits a form and Email – daily digest, then Save” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In case you don\u2019t want to edit and simply remove a notification altogether, this is how.<\/p>\n 1.<\/strong> Go to Tools > Notification settings > Edit notifications.<\/p>\n 2.<\/strong> Click on \u201cDelete\u201d to remove a notification rule. Google Sheets will prompt a warning message to confirm that you actually want to proceed with the deletion. Click \u201cOK\u201d to continue.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-confirm-delete.webp” alt=”Google Sheets notifications \u2014 Heads up! dialog asking to confirm deleting the notification rule” title_text=”Heads up! dialog asking to confirm deleting the notification rule” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”google-sheets-email-digest-notifications” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n With Email – daily digest, Google Sheets sends you one email a day that sums up the changes to the spreadsheet, instead of one email per change. It suits files that many people edit throughout the day, where an email for every change would flood your inbox.<\/p>\n To switch an existing rule to a digest, go to Tools > Notification settings > Edit notifications, click Edit next to the rule, select Email – daily digest, and click Save. If you need to act on changes as they happen, keep Email – right away for that file.<\/p>\n [\/et_pb_text][et_pb_text module_id=”google-sheets-alerts” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Notification rules tell you that something changed, not what changed or whether it matters. For alerts based on the data itself, you have two options.<\/p>\n Conditional formatting colors a cell when its value meets a rule, for example when a stock level drops below 10 or a status column says Overdue. It doesn’t send an email, but anyone who opens the sheet sees the problem right away. Go to Format > Conditional formatting to set it up, or see how to apply conditional formatting based on another cell in Google Sheets<\/a>.<\/p>\n For an email about one specific change, write a short Apps Script function and attach an installable On edit trigger to it: in the Apps Script editor, open Triggers and click Add trigger. The function receives the edited range, so it can check which sheet, column, or value changed before it sends an email with MailApp. Use an installable trigger rather than a simple onEdit() function, because simple triggers can’t send email. Edit triggers also run only for changes people make in the spreadsheet, not for changes made by other scripts or by formulas that recalculate.<\/p>\n If you’re new to Apps Script, start with how to use Google Apps Script in Google Sheets<\/a>. The steps below show how to open the editor.<\/p>\n [\/et_pb_text][et_pb_text module_id=”google-sheets-notification-scripts” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you\u2019re a developer – or at least familiar with JavaScript – you can use Apps Script, which is built into Google Sheets. This is how you can access the Apps Script feature in Google Sheets.<\/p>\n 1.<\/strong> Go to Extensions > Apps Script.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-open-apps-script.webp” alt=”Google Sheets notifications \u2014 Extensions menu open with Apps Script highlighted” title_text=”Extensions menu open with Apps Script highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Once Apps Script opens, it will take you to a new untitled project. You can start typing your first function right away or use the menus on the left to access libraries and services to add to your project.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-notifications-apps-script-editor.webp” alt=”Google Sheets notifications \u2014 new untitled Apps Script project with an empty myFunction” title_text=”New untitled Apps Script project with an empty myFunction” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To learn more about this tool, and the ready-made functions, visit the Apps Script main site<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”google-sheets-notifications-faq” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nHow to get notified when a Google Sheet is updated<\/h2>\n
Set notification rules in Google Sheets<\/h3>\n
Notify me at X when\u2026<\/h3>\n
Notify me with\u2026<\/h3>\n
How to turn on notifications for Google Sheets<\/h2>\n
Modify notification rules in Google Sheets<\/h2>\n
Add a new notification rule in Google Sheets<\/h3>\n
Edit a notification rule in Google Sheets<\/h3>\n
Delete a notification rule in Google Sheets<\/h3>\n
Google Sheets email digest notifications<\/h2>\n
Google Sheets alerts<\/h2>\n
Highlight changes with conditional formatting<\/h3>\n
Send an email with an Apps Script trigger<\/h3>\n
Google Sheets notification scripts<\/h2>\n
Google Sheets notifications FAQ<\/h2>\n
If I remove someone’s access to a Google Sheet, will they be notified?<\/h3>\n
![\"Notified](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/notify1.png\")
\n\nOn doing that the Set notification rules<\/strong> window pane pops up. For the purposes of demonstration, we choose the configuration as below and click on the Save<\/strong> button, and then on the Done<\/strong> button in the subsequent window.\n\nExample<\/strong> ![\"Notified](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/notify2.png\")
\n\nOnce this configuration is set, here's the email notification that's received when the other user added a record at the end of the file. We can readily see the changes made to the file using the Click here<\/strong> hyperlink provided in the email.\n\nExample<\/strong> ![\"Notified](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/notify.png\")
\n\nIf we have very few changes made to the file, it would be okay to get notified if someone edits my Google Sheets every time. However, if there are many changes being made, there's a better way to organize these notifications. It is through the Email - daily digest<\/strong> option, which we depict in the image below. To modify the existing notification rule, we use the same navigation (Tools > Notification rules<\/strong>) again, and click on the Edit<\/strong> option against it.\n\nExample<\/strong> ![\"Notified](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/notify4.png\")
\n\nFinally, we can also choose to get notified when a user submits a form that feeds into the corresponding Google Sheets file. In the future, we may want to remove these notification rules. We can do so either by navigating to Tools > Notification rules<\/strong> and then clicking on Delete<\/strong> option against a rule that we want removed. Or, we can use the Click here<\/strong> option adjacent to the text Want to stop receiving this email?<\/strong> within the email notification.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=7227"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7227\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/7228"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=7227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=7227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=7227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}