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. If you’ve still got the default name of an untitled document, you’ll be prompted to change the name before sharing. 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. 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. 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. 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. 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. 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. 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. The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.

Enable Email Notifications For Shared Google Docs Spreadsheets - 39Enable Email Notifications For Shared Google Docs Spreadsheets - 82Enable Email Notifications For Shared Google Docs Spreadsheets - 9Enable Email Notifications For Shared Google Docs Spreadsheets - 63Enable Email Notifications For Shared Google Docs Spreadsheets - 32Enable Email Notifications For Shared Google Docs Spreadsheets - 94Enable Email Notifications For Shared Google Docs Spreadsheets - 41Enable Email Notifications For Shared Google Docs Spreadsheets - 34Enable Email Notifications For Shared Google Docs Spreadsheets - 12Enable Email Notifications For Shared Google Docs Spreadsheets - 7Enable Email Notifications For Shared Google Docs Spreadsheets - 4Enable Email Notifications For Shared Google Docs Spreadsheets - 26Enable Email Notifications For Shared Google Docs Spreadsheets - 46Enable Email Notifications For Shared Google Docs Spreadsheets - 37Enable Email Notifications For Shared Google Docs Spreadsheets - 26Enable Email Notifications For Shared Google Docs Spreadsheets - 73