Tech Tip: Get Notified About Your Google Sheet Edits

 Tech Tip: Get Notified About Your Google Sheet Edits

We love the form notifications add-on that emails us when someone fills out a Google Form. However, what about when someone makes a change on a Google Sheet?

Marissa Rodriguez asked me the other day about this, and I thought it was a great tip to share with others. 

In Google Sheets, you can click on "tools" and "notification rules"  (see the picture above). This will let you create a rule.

In this box, you can choose if you want any changes made (which means anything added, edited, or deleted) on the spreadsheet or a user submits a form (if this spreadsheet is tied to a Google Form). 

Then the "notify me with" option lets you get an email daily digest (this means you would get one email with all the changes for the day) or an email right away (this means every time a change is made).

When you are finished, you will be able to edit the rule or delete the rule at any time. You also can add another notification rule, as well.

After you set this rule, then any time someone makes a change on the spreadsheet, an email (according to your rule) will be sent to you. This is what the email will look like (see the picture below), and this is how it shows you what changes have been made (second picture below).

*This can come in handy when you have a class sign up, project sign up, topic sign up, parent information, class supply sign up, or anything else you use spreadsheets for in and out of your classroom. You don't have to think about going to the spreadsheet to check for changes. Instead you will get emailed when a change has been made to your spreadsheet.