You can be notified when someone edits the contents of a Google Sheet, or if someone fills out a form using Google Forms. Author Jess Stratton shows you how to create, edit, and delete notification rules for a sheet.
- [Instructor] Google Sheets comes with…a built-in notification system, you just need to turn it on.…Sometimes,…there's a Google Sheet that contains sensitive data,…that you need to know if it's changed or added to.…You can also use this in conjunction with Google Forms.…Here's our hotel guest feedback form.…This survey is only good,…if we know that people are actually filling it out.…So, we can be notified when there's a new entry.…To use notifications in Google Sheets,…from any sheet that you want to be notified about,…from the top menu, click Tools.…
From here, select Notification Rules.…Here's where your choices are.…You can be notified at your Gmail address when…any changes are made to the form.…That is, any time there's any edits.…Or in this case, when a user submits a form.…This way, you can be notified when…our survey results come in.…After you decide when you want to be notified,…you can chose how you want to be notified.…You can either get an email, with a daily digest.…Or, an email right away, as each change happens.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons