Skip to content

Instantly share code, notes, and snippets.

@rzrbld
rzrbld / tellmeyoursecrets.js
Last active November 25, 2020 20:29 — forked from woodwardtw/tellmeyoursecrets.js
google script that lists a lot of info about the files in a particular folder/sub folder structure including viewers, editors, and sharing permissions
function listFolders(folder) {
var sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow(["Name","Folder Name" ,"Sharing Access", "Sharing Permission", "Get Editors", "Get Viewers", "Date", "Size", "URL", "Download", "Description", "Type"]); //writes the headers
// var folder = DriveApp.getFolderById("ID");//that long chunk of random numbers/letters in the URL when you navigate to the folder
var folders = DriveApp.getFolders();
while (folders.hasNext()) {
var folder = folders.next();
Logger.log(folder.getName());