Shared File Finder for Google Drive

An Apps Script that finds all files/folders on Google Drive that are shared with others and adds them to a Google Sheet.

Usage

1. Create a new Google Sheet.
2. Open the Script Editor (Extensions > Apps Script).
3. Copy and paste the code from shared-file-finder.js into the Script Editor.
4. Enable Drive API in the Advanced Services list for the project (see here for instructions). The API version should be v2 and the identifier should be Drive.
5. Save the project and run the runSharedFileFinder() function.

Notes:

• Files must be owned by the current Google Drive user.
• If a folder is shared, both the folder and its files will be shown in the list.
• There may be bugs. Use at your own risk.

Contributing

Contributions, issues, and forks are welcome. SemVer is used for versioning.

License

Inspired by a similar script by @danjargold (https://gist.github.com/danjargold/c6542e68fe3a3b46eeb0172f914641bc) and @woodwardtw (https://gist.github.com/woodwardtw/22a199ecca73ff15a0eb). This version uses the Drive API v2 to get info for multiple files at once (which makes it substantially faster).

This project is licensed under the MIT License. See LICENSE for details.