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.…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.