---
title: "How to audit Google Shared Drive permissions in Google Sheets with Apps Script"
author: "Martin Hawksey"
date: 2024-02-22T22:39:47+00:00
canonical_url: https://pulse.appsscript.info/p/2024/02/how-to-audit-google-shared-drive-permissions-in-google-sheets-with-apps-script/
markdown_url: https://pulse.appsscript.info/p/2024/02/how-to-audit-google-shared-drive-permissions-in-google-sheets-with-apps-script.md
categories:
  - "Drive"
  - "Intermediate"
  - "Sheets"
  - "Solutions"
tags:
  - "Medium"
  - "nwaarbroek"
featured_image: https://pulse.appsscript.info/files/2024/02/ezgif-4-5dbadaacc1.png
description: "This post from Niek Waarbroek highlights the important of auditing Google Shared Drive permissions. This can be a challenge to do using the Google Workspace Admin Console, especially if you have lots of Shared Drives. To help Niek has shared a Google Sheet with Apps Script code that automatically generates a list of all shared drives and their associated root level permissions. Shared Drive auditing is bit of a niche subject, but I encourage you to have a look at the post and script as it has some nice features which could be applicable to other projects. For example, there is a gaspTimeManager to make sure the script doesn't go beyond the script execution limit."
---

# How to audit Google Shared Drive permissions in Google Sheets with Apps Script

![How to audit Google Shared Drive permissions in Google Sheets with Apps Script](https://pulse.appsscript.info/files/2024/02/ezgif-4-5dbadaacc1.png)

> Are you looking for an efficient way to get an overview of all shared drives and their access permissions within your organization? Whether you’re navigating a company reorganization or implementing security procedures, accessing this information can be challenging.

This post from Niek Waarbroek highlights the important of auditing Google Shared Drive permissions. This can be a challenge to do using the Google Workspace Admin Console, especially if you have lots of Shared Drives.

To help Niek has shared a Google Sheet with Apps Script code that automatically generates a list of all shared drives and their associated root level permissions.

Shared Drive auditing is bit of a niche subject, but I encourage you to have a look at the post and script as it has some nice features which could be applicable to other projects. For example, there is a `gaspTimeManager` to make sure the script doesn’t go beyond the script execution limit.

Source: [*How to audit shared drive permissions in Google Drive***](https://medium.com/@nwaarbroek/how-to-audit-shared-drive-permissions-in-google-drive-a864c3e1d847)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2024/02/how-to-audit-google-shared-drive-permissions-in-google-sheets-with-apps-script/](https://pulse.appsscript.info/p/2024/02/how-to-audit-google-shared-drive-permissions-in-google-sheets-with-apps-script/)*