---
title: "Use Google Apps Script to pull all Google Shared Drives and permissions into Google Sheets"
author: "Martin Hawksey"
date: 2022-03-31T11:09:15+00:00
modified: 2022-03-31T11:09:28+00:00
canonical_url: https://pulse.appsscript.info/p/2022/03/use-google-apps-script-to-pull-all-google-shared-drives-and-permissions-into-google-sheets/
markdown_url: https://pulse.appsscript.info/p/2022/03/use-google-apps-script-to-pull-all-google-shared-drives-and-permissions-into-google-sheets.md
categories:
  - "Drive"
  - "Intermediate"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@techupover"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2022/03/shared-drive-sheets.png
description: "\"If you’re a Google Workspace Super Admin, you’ve probably been thinking of ways to inventory and keep a handle on Google Shared Drives. They are a really great addition to the Workspace offering, but there are still some gaps in reporting & oversight that some people have wanted. This solution uses Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet. Then, it uses the Drive API again to loop through all the drives and get the top-level permissions.\""
---

# Use Google Apps Script to pull all Google Shared Drives and permissions into Google Sheets

![Use Google Apps Script to pull all Google Shared Drives and permissions into Google Sheets](https://pulse.appsscript.info/files/2022/03/shared-drive-sheets.png)

> If you’re a Google Workspace Super Admin, you’ve probably been thinking of ways to inventory and keep a handle on Google Shared Drives. They are a really great addition to the Workspace offering, but there are still some gaps in reporting & oversight that some people have wanted. This solution uses Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet. Then, it uses the Drive API again to loop through all the drives and get the top-level permissions.

For Google Workspace admins Nick Young has provided a nice solution for auditing Google Shared Drives within your Workspace domain. This post covers all the steps to setup, a link to the code on GitHub and some notes on limitations to be aware of.

Source: *[Use Apps Script to pull all Google Shared Drives and permissions into a Google Sheet*](https://www.techupover.com/google-shared-drives-and-permissions-into-google-sheet/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/03/use-google-apps-script-to-pull-all-google-shared-drives-and-permissions-into-google-sheets/](https://pulse.appsscript.info/p/2022/03/use-google-apps-script-to-pull-all-google-shared-drives-and-permissions-into-google-sheets/)*