---
title: "Bulk create Shared drives with permissions"
author: "Phil Bainbridge"
date: 2021-06-24T07:46:42+00:00
modified: 2021-06-24T07:46:46+00:00
canonical_url: https://pulse.appsscript.info/p/2021/06/bulk-create-shared-drives-with-permissions/
markdown_url: https://pulse.appsscript.info/p/2021/06/bulk-create-shared-drives-with-permissions.md
categories:
  - "Beginner"
  - "Drive"
  - "Snippet"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2021/06/BulkcreateShareddrives.png
description: "The following Google Apps Script is designed to bulk create Google Shared drives all from data in a Google Sheet. It has been packaged into a downloadable tool that you can easily use."
---

# Bulk create Shared drives with permissions

![Bulk create Shared drives with permissions](https://pulse.appsscript.info/files/2021/06/BulkcreateShareddrives.png)

> Bulk create Google Shared drives with permissions all from a Google Sheet.
> [https://www.pbainbridge.co.uk/2021/06/bulk-create-shared-drives-with.html](https://www.pbainbridge.co.uk/2021/06/bulk-create-shared-drives-with.html)Bulk create Shared drives from a Google Sheet

- Provide the name of the Shared drive on each row in column A.
- Provide the email address(es) of the Google Account(s) under the relevant Access level column (Manager, Content Manager, Contributor, Commenter, Viewer). Use a comma and a space to separate multiple email addresses, eg: example1@example.com, example2@example.com, example3@example.com.
- Ensure you include at least one Manager – the script will check for this – so as to prevent creating a Shared drive that you are then unable to access.
- On the ‘Config’ sheet provide the column numbers – leave the default values unless you change the structure of the ‘Data’ sheet and move columns around.
- The ‘Log’ sheet should help to troubleshoot any errors you experience, but there will also be a popup message should the script fail at some point.

Source: *[The Gift of Script: Bulk create Shared drives with permissions*](https://www.pbainbridge.co.uk/2021/06/bulk-create-shared-drives-with.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/06/bulk-create-shared-drives-with-permissions/](https://pulse.appsscript.info/p/2021/06/bulk-create-shared-drives-with-permissions/)*