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.)
2
-
1You 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 EinhornJun 7, 2018 at 2:32
-
@AronEinhorn Importrange has a refresh rate set on 30min– user0Jun 7, 2018 at 5:40
Add a comment
|
2 Answers
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.
-
1The OP mentioned that the Notifications menu is greyed out (not available).– Rubén ♦Jun 7, 2018 at 21:41
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.
