Google Drive’s spreadsheets are liable to be shared and edited by many people.
This can potentially compromise the integrity of their data, so it’s a good idea to keep track of the changes made. Fortunately, Google provides a notifications service so the spreadsheet’s owner can do just that.
To access the notification rules, open the spreadsheet you want to track and select Tools > Notification Rules…. The resulting dialogue allows you to choose what changes to track. If only some data is critical, you can choose to only track a specific sheet or cell range. If you’ve set up a form to feed its result into your spreadsheet, you can choose to be notified whenever somebody submits the form. Choosing email – daily digest will add the notification to a daily email that contains all of your notifications that have this rule selected. Email – right away immediately sends the specific notification to you.
Click Save when you are done. Your new notification rule will be the first on a list of all the notification rules for that spreadsheet. From the list you can add new rules, or edit or delete an existing one.