How to Use Email Notifications in Google Sheets
11In this video I'll show you how to set up and use email notifications in Google Sheets.
Timestamps:
Introduction: 0:00
Steps to Use Email Notifications in Google Sheets: 0:41
Conclusion: 1:46
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
Video Transcript:
Google makes it easy for multiple users to access and update a Google Sheets spreadsheet. However, it can be easy to quickly lose track of who changed what, and as a result potentially miss something important. If you want to keep your thumb on the pulse of what other people are doing in a Google Sheets spreadsheet, Google makes it easy to set up email notifications that you can receive every time someone makes a change, or in the form of a daily digest where you'll get a summary of changes made over the course of a day.
Now let's walk through the steps to set up and use email notifications in Google Sheets.
Step 1. Open the Google Sheets spreadsheet you want to set up email notifications for, and then click "Tools" in the menu at the top of the screen. A menu is displayed.
Step 2. Click "Notification Rules" in this menu. The See Notification Rules window is shown.
Step 3. In the top section, choose to be notified either when any changes are made or when a user submits a form. And in the lower section, choose to be notified either through a daily digest, which will include all updates over the course of a day, or to be emailed immediately.
Step 4. Click "Save" after making your selections. The See Notification Rules window is shown, displaying all of the notification rules you've set up for this specific Google Sheets spreadsheet.
Step 5. Click "Done" when you're finished. You'll start receiving your email notifications immediately.