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:
When you save your settings, the dialog changes to allow you to edit or delete your email alerts:
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.