danjargold

Recently created

Least recently created

Recently updated

Least recently updated

danjargold / whatFilesHaveIShared.gs

Created August 11, 2018 09:31

Google script to list (on a Google Sheet) all files shared in your google drive, including all viewers, editors, and sharing permissions. Credit goes to @woodwardtw (https://gist.github.com/woodwardtw/22a199ecca73ff15a0eb) as this is an improvement on his code which only assesses a single folder and one level of sub-folders down.

	function listFolders(folder) {
	var sheet = SpreadsheetApp.getActiveSheet();
	sheet.appendRow(["Name", "Sharing Access", "Sharing Permission", "Get Editors", "Get Viewers", "Date", "Size", "URL", "Download", "Description", "Type"]); //writes the headers

	//var folder = DriveApp.getFolderById("INSERT_YOUR_FILE_ID");//that long chunk of random numbers/letters in the URL when you navigate to the folder
	//getLooseFiles(folder, sheet);
	//getSubFolders(folder, sheet);

	//instead of getting folder by ID rather get all folders and cycle through each. Note this will miss loose files in parent directory.
	var folder = DriveApp.getFolders()