The best way to Create A number of Sub-folders in Google Drive Mechanically

The best way to robotically create a number of sub-folders in Google Drive for every scholar and their topics utilizing Google Sheets and Doc Studio.

A trainer want to create separate Google Drive folders for every scholar in her class. Inside every scholar’s folder, there can be further subfolders for numerous topics. This folder construction would make it simpler for college kids to submit their assignments to the suitable topic subfolders.

We’ve ready a Google Sheet with the names of scholars, and the themes they’re taking.
For instance, contemplate a scholar named Emily Johnson, who’s taking Maths, Science, and English. On this case, it’s essential to create 4 new folders in whole, with one principal folder named ‘Emily Johnson’ and three subfolders inside it for every topic: Maths, Science, and English.

Create A number of Folders in Google Drive

Set up the Document Studio add-on for Google Sheets. Open the spreadsheet with the coed information and click on on Extensions > Doc Studio > Open to launch the add-on.

Create a brand new workflow inside Doc studio, give it a descriptive identify like Pupil Folders. Subsequent, choose the supply worksheet that incorporates the coed’s information and click on on the Proceed button to maneuver to the following step.

On the following display, you’ll be able to specify the situations for creating the folders in Google Drive. As an example, it’s possible you’ll solely wish to create folders for college kids who’re taking a particular topic or are in a selected class. Press the Proceed button to maneuver to the following step.

Select the Google Drive process after which choose Create Folder from the dropdown menu. Subsequent, choose the guardian folder in Google Drive the place the coed folders must be created. You possibly can select to create folders inside your private Google Drive and even Shared Drives.

Naming Folders and SubfoldersStudent Folders

Now that you’ve chosen the guardian folder, it’s essential to outline the identify of the kid folder together with its subfolder construction.

For the Subfolder Title discipline, we’ll put {{ Full Title }} / {{ Topic 1 }} and it will do two issues:

1. Create a brand new folder for every scholar within the guardian folder with the coed’s identify. The folder is just created if it doesn’t exist already.

2. Inside the coed folder, create a subfolder for Topic 1 that the coed is taking. The worth of Topic 1 is changed with the precise topic identify from the Google Sheet.

You may additionally put the {{Electronic mail Handle}} column within the Editors discipline to share the coed folders with their electronic mail addresses robotically when the folder is created in Google Drive.

Create Further Topic Subfolders

Now that you’ve outlined the duty to create subfolders for the primary topic, you’ll be able to add extra duties to create subfolders for different topics as nicely.

As a substitute of making a brand new process, you’ll be able to merely duplicate the prevailing process and alter the Subfolder Title discipline to {{ Full Title }} / {{ Topic 2 }} to create subfolders for the remaining topics.

Now that workflow is prepared, select the Save and Run choice to create the folders and subfolders in Google Drive. The folders can be created and a hyperlink to the folder can be positioned within the spreadsheet itself. If a folder already exists, the hyperlink to the prevailing folder is positioned within the spreadsheet.

That is how the folder construction would appear to be in Google Drive:

Additionally see: Create Folders for Google Form responses