Notifications in a spreadsheet
You can set notifications to find out when other people have modified your spreadsheets, and learn what they've modified. You can also choose how often you'd like to be notified.
- Open the spreadsheet where you want to set notifications.
- Click Tools > Notification rules.
- In the window that appears, select when and how often you want to receive notifications.
- “Any changes are made”
- “A user submits a form”
- How often:
- “Email - daily digest”
- “Email - right away”
- Click Save.
What you will see in notifications
When receiving notifications, you and other editors will see the usernames of people who have made changes. Viewers can set notifications but can't see usernames. You won't be sent notifications about your own changes.Note: If you want to set more specific rules to be notified about, for example when someone modifies a certain range of cells, you can use Apps Script.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.