Tuesday 18 July 2023

Bulk create Drive folders with subfolders

The following Google Apps Script is designed to bulk create Google Drive folders with multiple subfolders. You control the naming convention of each folder and exactly how many you want.

Use this tool to bulk create folders with subfolders
Use this tool to bulk create folders with subfolders

Features

  1. Runtime control - currently set to 5 minutes 30 seconds. Will ignore rows that have a 'Folder Link' so you can continue from where you left off and append further folders should you require.
  2. More subfolders - the Google Sheet has columns for 10 subfolders but you can technically add more (columns) and the code will account for this automatically.
  3. Toast popups to inform you of the progress as folders are created.
  4. 'Log' sheet and popup error messages if something goes wrong.
  5. Concatenation - create those useful descriptive folder/file names so items are easier to search for in the future. Concatenate will let you combine values that may exist in different columns in another spreadsheet for example, or take those folder names and prepend/append words around them. Concatenate guide webpage.



Download

Bulk create Drive folders with subfolders download (please use 'File' > 'Make a copy' for your own version).



No comments:

Post a Comment