How to Enable Email Notifications For Shared Google Docs Spreadsheets

Jon Fisher

How-to-Enable-Notifications-For-Shared-Google-Docs-Spreadsheets

Google Docs are a great way to share information with associates or anyone in general. Although sharing is great, another feature you should implement when two or more are working together is notifications for when changes are made. With Google Docs, you can set up notification alerts to be sent out when a spreadsheet has been changed. There are a few options for how to do this, so take a look below and start sharing your Google Docs.

How to Share a Google Docs Spreadsheet

Because most Google Docs users will first share a document and then use the notification rules to email them on changes made, we’ll first list at how to share a document on Google Docs.

Look to the upper right of a document for the button called Share. If you hover your mouse over it, it specifies the sharing status, which is Private to only me by default, meaning it isn’t shared with anyone.

Click this Share button to open the dialog box for sharing with other people.

See-who-a-document-is-being-shared-with-in-Google-Docs

If you’ve still got the default name of an untitled document, you’ll be prompted to change the name before sharing.

Name-a-new-document-in-Google-Docs-before-sharing-it

Look under Who has access and you’ll find anyone you share the document with. Because the default is to not share, you will be the only person listed here.

View-who-has-access-to-a-document-in-Google-Docs

Click Change next to the Private section. This Sharing settings window is to specify how sharing should take place.

Public on the web: The document can be found in search engines and anyone can open and access it based on the Access rule.

Anyone with the link: Only those people that have the link to the document can reach it. Access is based on the Access rule.

Private: No one can view or change this document but the owner.

Say we choose the second option for Anyone with the link to have access to view the document.

Share-a-Google-Doc-so-anyone-with-the-link-can-view-or-change-it

Click Save to return to the regular Sharing settings window. From here, you can copy the link to use for sharing or use any of the social sharing buttons below the link.

Copy-the-link-to-a-Google-Doc-for-sharing

Alternative, instead of using the above options, you can send a document to someone via email right from the Sharing settings window.

At the bottom, enter an email in the Invite people section and specify an access type to the right.

Share-a-Google-Doc-over-email

Now that we’ve shared a file, let’s look at how to enable notifications to know when a user makes changes.

Enable Notifications For a Google Spreadsheet

Important note: This feature is only available in Google Docs spreadsheets and not in the documents and slides.

Navigate to Tools -> Notification rules.

Open-the-Notification-rules-in-a-Google-Spreadsheet

This will open the Set notification rules window. It’s here we’ll make all the changes necessary for email notifications.

Select any of the options for what events will need to take place for a notification. For example, choose Any changes are made to send an email when anything on the spreadsheet is altered. Alternatively, select individual cells or another option from this list.

Finally, choose when to send the email at the bottom. Under Notify me with, select to get a digest email that will be send out once a day with information regarding changes or choose Email – right away to get the notification immediately after the change is made.

Note: Email notifications are sent only to the address tied in with the Google Docs account. No additional addresses can be included in notification emails.

Set-how-a-notification-rule-should-work-in-a-Google-Doc

Click Save to ensure all the changes are submitted.

Conclusion

Sharing a spreadsheet to a colleague is a great idea for collaboration. It’s when changes are made that you’ll most likely need to check back and review them. Set up email notifications on shared spreadsheets with ease using Google Docs.

Also See
#alerts#google docs

Join the newsletter