Email Notification from Google Sheets

Sometimes, when you have multiple spreadsheets and multiple colleagues collaborating on them, or when you’re collecting form data this way, it can be tough to keep track of everything that’s going on.

Thankfully, in the Sheets spreadsheet app you can choose to receive customised notifications via email when something is changed on your spreadsheet.

To set up a notification, choose Tools > Notification rules … and in the dialog you can set up the alert exactly as you wish:

Click image to enlarge

Click image to enlarge

When you save your settings, the dialog changes to allow you to edit or delete your email alerts:

Click image to enlarge

Click image to enlarge

Don’t forget that the notifications can be triggered by change to any cell on the sheet or just to a specific range, depending on your needs.