Skip to content

Instantly share code, notes, and snippets.

View petrklus's full-sized avatar

Petr Klus petrklus

8 followers · 3 following
View GitHub Profile
@petrklus
petrklus / listGoogleDriveSharedDocuments.js
Created April 19, 2021 11:57 — forked from JavierCane/listGoogleDriveSharedDocuments.js
Google Spreadsheet script that lists all the shared documents inside a specified folder and all its subfolders recursively. Skips out the documents shared internally (with specified email addresses)
function start() {
const sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow(["Name", "Sharing Access", "Sharing Permission", "Get Editors", "Get Viewers", "Date", "Size", "URL", "Download", "Description", "Type"]);
const folder = DriveApp.getRootFolder();
recursiveListSharedFiles(folder, sheet);
}
function recursiveListSharedFiles(folder, sheet) {