Excel-like for free! How to use Google Sheets
Last time, I prepared a remote work environment with Google Drive and a spreadsheet. As you work, you want to know if someone else has updated the spreadsheet you shared? "However, it is not always possible to immediately contact members who are far away."
Let's change the settings of the spreadsheet so that we can receive an email notification when the file is updated. You can also see what has changed.
You can be notified by email when the spreadsheet is updated
Email yourself with "Notification Rules"
To send an email when the spreadsheet is updated, change the "Notification Rules" settings. With the shared spreadsheet open, each of the sharing members does it. When someone updates it, I will have the spreadsheet email me.
Click [Tools] - [Notification Rules]. The [Notification Rules Settings] screen appears. Click [When changes are made]. The notification method can be set to select from [once a day] or [every time]. Click the [Finish] button. If you want to change the settings, you can operate from this screen[Every time] is the timing when someone updates the spreadsheet. If you are bothered by being notified many times, you should select [Once a day].
To change or delete the settings, click [Tools]-[Notification Rules] again and select [Edit] or [Delete] from the [Notification Rule Settings] screen.
Check the notification email
Below is the notification email received. See who updated when. If you want to confirm the changes, please click the "Confirm changes" link.
This link is for checking the update history and cannot be edited as is. Here we review the changes and then view the latest version of the spreadsheet.
Click the "Check for updates" link in the notification email. If you want to edit immediately, "Open latest" opens the updated spreadsheet The updated part was highlighted. It cannot be edited in this state. Click [View entire spreadsheet] The latest spreadsheet is displayedIn addition, the message [Do you want to stop receiving this email? ] link to stop email notifications.