AppsCare | Receive notification rules when changes are made in Google Sheets - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
18616
single,single-post,postid-18616,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

02 Jul Receive notification rules when changes are made in Google Sheets

Receive notification rules when changes are made in Google Sheets: Use notification rules to keep up to date when changes are made to a spreadsheet, or when a user submits a form and you receive a new result. 

To set up notifications, open up your Google Sheets file. Here I’ve opened up the responses Sheet from a Google Form, as I want to receive a notification every time a new form is submitted.

To turn on notifications, the first step is to head to Tools on the toolbar, and select Notification rules… from the drop down menu.

Screen Shot 2015-07-01 at 09.53.37

A new window will open, with a number of options. First you can select why you want to receive a notification – either when any changes are made or when a user submits a form. Then you can choose to receive an email straight away or to be emailed a daily digest of any updates.

Screen Shot 2015-07-02 at 09.09.18

Click Save, and your new notification will be confirmed. You can edit or delete the notification, and can come back to this window at any time by visiting Tools > Notification rules… again.

Screen Shot 2015-07-02 at 09.11.11

The message will appear in your inbox like so.

inbox-notification

When you open the message, you will have the option to view the changes made to the document. This way, you can easily keep track of what is happening in your spreadsheet, and you can flag any important responses or issues as they appear.

edited-recently

 

For more tips and tricks, visit our Google Apps Tips blog.

Claire Stead
cstead@appscare.com
No Comments

Post A Comment