Keep Track of Changes in Google Sheets

This tip comes indirectly from the good folks at Seesaw who use the technique I am about to describe to keep their Seesaw Ambassadors up to date with the latest changes to the Seesaw Ambassador program which is tracked in a Google Sheets document.

A little known feature to most people is that you can enable notifications via email for any Google Sheets document. To enable the feature you use the Tools >> Notifications Rules

On the set notifications rules screen you need to choose to see when either a change is made to the form (by Editors of the sheet) or when a form is submitted (Linked Google Form).

You can also choose either a daily digest (all the updates in one daily email) or right away to receive notification as soon as an editor makes a change or a form is submitted.

You will receive a notification in your email when changes are made to the document.

A link to the document is provided in the body of the email.

In case you were wondering, this is only available in Google Sheets.

Related Posts