How to Find Shared Files in Google Drive and Manage Permissions for Former Employees

Ensuring data security and managing access to confidential company information is paramount, especially when employees transition out of the organization. A common concern for Google Workspace users, particularly those working with sensitive Google Sheets or Drive files, is how to effectively track and revoke sharing permissions for former team members. This community insight addresses a user's critical question on how to find shared files in Google Drive and review historical access.

Google Sheets document with Activity dashboard showing recent user interactions
Google Sheets document with Activity dashboard showing recent user interactions

Tracking Google Drive Sharing History: A Critical Need

The original poster faced a common challenge: a former employee might still have access to confidential Google Sheets. The user sought a comprehensive history of everyone they'd ever shared files with, aiming to review and remove outdated permissions, even for users whose access might have already been revoked. This highlights a crucial aspect of data governance within Google Workspace.

Google Workspace Admin console displaying Drive log events for auditing sharing permissions
Google Workspace Admin console displaying Drive log events for auditing sharing permissions

Key Solutions for Managing Google Drive Sharing Permissions

For Individual Users: The Activity Dashboard

For immediate and recent insights into file activity, Google Drive's built-in Activity dashboard is your first stop. This feature allows you to see who has viewed, commented on, or edited your Google Docs, Sheets, and Slides. While it primarily shows current activity and recent changes, it can help you identify active collaborators and understand recent interactions with your files.

  • How to access: Open your Google Drive, select a file, and click the "i" icon (Details & Activity) in the top right corner. Navigate to the "Activity" tab.
  • Limitations: The Activity dashboard is excellent for current and recent activity. However, it may not provide a comprehensive historical log of all past sharing permissions, especially if they were removed a long time ago. For deeper historical data, especially regarding removed permissions, administrative tools are often necessary.

Reference: View the activity on your Google Docs, Sheets & Slides

Where Workalizer helps: For a more structured overview of activity, Workalizer's How to Use the Activity Dashboard for Google Drive guide provides insights into leveraging this feature for team and individual productivity analysis.

Activity Dashboard for Google Drive widget in Workalizer showing key metrics and filters.
The Activity Dashboard for Google Drive widget in context with period and scope filters.
Detail view for Activity Dashboard for Google Drive.
Additional context for using the Activity Dashboard for Google Drive widget.

For Workspace Administrators: Comprehensive Auditing and Control

When dealing with organizational data security and compliance, especially concerning former employees, Google Workspace administrators have access to more powerful tools for auditing and managing shared files. These tools offer a deeper, more historical view of sharing permissions and file access.

  • Drive Log Events: Administrators can utilize the Google Workspace Admin console to review Drive log events. These logs provide detailed records of sharing changes, file access, and other critical activities across the organization's Google Drive. This is the most robust way to track historical sharing, including when permissions were granted or revoked.
  • Contact Google Workspace Support: If you are the Workspace administrator and require assistance with complex auditing or data recovery related to sharing history, Google Workspace Customer Care Support is equipped to provide expert guidance.

References:

Where Workalizer helps: For organizations needing to proactively manage access and understand data flow, Workalizer offers robust reporting. The How to Use the Google Drive Usage Report and especially the How to Use the Google Drive Shared Files Report provide critical insights into who is sharing what, with whom, and how often. These reports are invaluable for identifying over-shared files, monitoring external sharing, and ensuring compliance. Furthermore, How to Use Document Alerts in Workalizer can notify you of suspicious sharing activities or changes to sensitive documents, providing an extra layer of security.

Google Drive Usage Report widget in Workalizer showing key metrics and filters.
The Google Drive Usage Report widget in context with period and scope filters.
Detail view for Google Drive Usage Report.
Additional context for using the Google Drive Usage Report widget.
Document Alerts Configuration section: list of alert rules and options to add, edit, enable, or disable.
Document Alerts Configuration: manage which documents and actions trigger alerts.
Document Alert Configuration modal: select documents, triggers, and exceptions.
Configuration modal: define documents, triggers, and exceptions for an alert.

Ensuring Data Security and Compliance

The ability to effectively manage and audit sharing permissions is fundamental to maintaining data security and compliance within any organization using Google Workspace. While individual users can leverage the Activity dashboard for recent insights, administrators hold the keys to comprehensive historical data and robust control over how to find shared files in Google Drive and manage their access. Regularly reviewing sharing policies and utilizing administrative tools, alongside productivity analytics platforms like Workalizer, ensures that sensitive information remains secure, even after employees depart.

GmailGoogle Chat

|

 Sign Up for Free TrialRequires Google Workspace Admin Permission
Live Demo
Communication performance dashboard