---
title: "Bulk create Google Drive folders from a Google Sheet"
author: "Phil Bainbridge"
date: 2019-11-23T23:39:25+00:00
modified: 2019-11-25T22:20:06+00:00
canonical_url: https://pulse.appsscript.info/p/2019/11/bulk-create-google-drive-folders-from-a-google-sheet/
markdown_url: https://pulse.appsscript.info/p/2019/11/bulk-create-google-drive-folders-from-a-google-sheet.md
categories:
  - "Drive"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
description: "The following Google Apps Script code was developed to bulk create Google Drive folders with data from a given spreadsheet (eg to name the folders and add permissions). It uses the Module Name and Marker..."
---

# Bulk create Google Drive folders from a Google Sheet

> The following Google Apps Script code was developed to bulk create Google Drive folders with data from a given spreadsheet (eg to name the folders and add permissions). It uses the Module Name and Marker to form the folder name as it iterates through each row in turn. At the same time it takes the Marker Email Address and uses the ‘DriveApp’ to provide edit access to the folder. Finally it creates another sub-folder in each folder as an extra.

Source: *[The Gift of Script: Bulk create Google Drive folders*](https://www.pbainbridge.co.uk/2019/04/bulk-create-google-drive-folders.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/2019/11/bulk-create-google-drive-folders-from-a-google-sheet/](https://pulse.appsscript.info/p/2019/11/bulk-create-google-drive-folders-from-a-google-sheet/)*