In this article we will show how to send an email when a google sheet is updated in just a few simple steps using the notifications feature. Simply follow the steps below:
To see notification settings, click Tools then choose Notification settings. You will get two options: edit notifications and comment notifications.
Select Edit notifications. The other option is for getting notifications when comments are made in your spreadsheet.
A box containing the notification rules will appear. You can set the notifications to be sent to your email; if there are other users with editing rights to the spreadsheet, they have to set them on their own.
There are two options to set. For the Notify me at email when, the two options are the following:
Two options are also available under Notify me with:
For this example we will choose to be notified whenever changes are made to the spreadsheet in a daily email.
Once the notification options are set, click Save. The notification rule will be listed. Click Done to close the box.
You are now done!
Whenever an edit is made to the spreadsheet, you will be notified via email: