I have view-only access to a Google Sheet. Is there any way I can set up an email notification whenever there is any change to this Google Sheet?
(Right now, Tools > Notification Rules is greyed-out.)
1
-
You can IMPORTRANGE the whole sheet to one of your own where you have full access. But I haven't tested if data changes from such sources indeed trigger the notification. – Aron Einhorn Jun 7 '18 at 2:32
-
@AronEinhorn Importrange has a refresh rate set on 30min – user0 Jun 7 '18 at 5:40
0
No, there definitively isn't such a possibility if you have view-only access. The workaround would be to use IMPORTRANGE formula to import the whole sheet into your spreadsheet and then set up an email notification based on changes of your sheet. Note that due to IMPORTRANGE limitations you could experience up to a half hour delays.
-1
Try this, it may help you:
- On your computer, open a spreadsheet in Google Sheets.
- At the top, click Tools and then Notification rules.
- In the window that appears, select "how often" you want to receive notifications.
- Notify you with: Email - daily digest: Send a daily summary of all changes. Email - right away: Send an email for every change.
- Click Save.
-
The OP mentioned that the Notifications menu is greyed out (not available). – Rubén Jun 7 '18 at 21:41
