Google Sheets provides an email notification tool that allows you to get email notifications for changes to a Google Sheet or when a Google Form that is connected to your Google Sheet receives a submission. You can set your email notifications to be received when each change occurs or as a daily summary.
There are some really good use-cases where you might need to receive notifications of changes to a Google Sheet. Here are two common examples that I have used notifications for in the past:
- Tech Support: I have had a form connected to a sheet and then had my team use notifications to get an email when a user submits a tech support issue. We set it up so that the first responder adds their initial to a column related to the lastest form submission so that everyone knows that it is being addressed.
- Project Management: I’ve run a Gantt chart for project management and when someone from a project I have assigned has completed a portion of a task and is ready for review, they check a box. At the end of each day, I get an email notification summarising the changes in the chart.
Check out the details below on how to get notifications on a Google Sheet and how to read the email notification summary.
In this tutorial, I’ll cover,
- What are Notifications in Google Sheets. 00:27
- Adding in a Notification Rule. 00:42
- Notification from a Google Form. 01:00
- How Forms link to get Notifications. 01:25
- How Notifications are received in email. 02:10
- Creating a daily digest as a Notification Rule. 02:53
- What a daily digest looks like in email form. 03:20
- Other Notification Rules you can add. 03:55
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*
*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.