To turn on notifications for a Google Sheet, open the spreadsheet, click Tools > Notification settings > Edit notifications, then choose when and how often you want to receive notifications (e.g., daily digest or right away) and click Save.
You can only set up notifications for changes made by other people, not for your own edits.
