notification when google sheet is edited?
Turn on Spreadsheet Notifications Notifications are very useful if you need to know when a change has been made to a Google spreadsheet you own or are collaborating on. Go to the Tools menu and select Notification rules. You can choose to be notified when; any changes are made or when a user submits a form.