Google Sheets – How to Set Up Notifications for Shared Documents

google sheetsgoogle-drive

My friend has shared a file with me on Google Drive and I would like to be notified whenever changes are made to the file (pretty reasonable request I'd say):

You can set notifications to find out when your
collaborators have modified your spreadsheets, and learn what sheets
or cells they've modified. You can also choose how often you'd like to
be notified. Here's how you can enable notifications:

  1. Click Share at the top right of the spreadsheet and select Set
    Notification Rules.

  2. In the window that appears, select when and how
    often you want to receive notifications:

    a. When changes are made to the
    entire spreadsheet

    b. When changes are made to a specific sheet

    c. When
    changes are made to specific cells

    d. When collaborators are added or
    removed

    e. When changes are made to forms

    f. By 'daily digest' or 'right
    away'

  3. Click Save.

(Source)

I've tried to follow the steps but I'm stuck on step 2.. for example, when I hit share I'd get this screen:

screenshot

How do we set up notifications for documents shared to us in Google Sheets?

Best Answer

@Pacerier's answer is correct — for a spreadsheet. For a word processing document or presentation, that menu does not exist.

As far as I have found, word processing and presentation documents provide notifications for updates to comments, but not the content of the document. Comment notifications seem to be enabled by default and can be changed by clicking the Comments button (next to the Share button, in the top right area of the page) and then Notification Settings.

Related Topic