Skip to content

Instantly share code, notes, and snippets.

View smarthomenow's full-sized avatar

smarthomenow

2 followers · 16 following
View GitHub Profile
@smarthomenow
smarthomenow / listGoogleDriveSharedDocuments.js
Created December 9, 2021 14:46 — 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.getFolderById("folder_id_copied_from_the_url_without_the_google_drive_domain");
recursiveListSharedFiles(folder, sheet);
}
function recursiveListSharedFiles(folder, sheet) {