How to Automatically Create Multiple Sub-Folders in Google Drive

by

How to automatically create multiple sub-folders in Google Drive for each student and their subjects using Google Sheets and Docs Studio.

A teacher may want to create separate Google Drive folders for each student in their class. Within each student’s folder, there will be additional subfolders for different subjects. This folder structure makes it easy for students to submit their assignments in appropriate subject subfolders.

We have prepared a Google sheet with the names of the students and the subjects they have taken. For example, consider a student named Emily Johnson, who is studying math, science, and English. In this case, you need to create a total of four new folders with one main folder named ‘Emily Johnson’ and three subfolders for each subject: Math, Science and English.

Create multiple folders in Google Drive

Install the Docs Studio add-on for Google Sheets. Open the spreadsheet with the student data and click Extensions > Document Studio > Open to launch the add-on.

Create a new workflow within Document Studio, give it a descriptive name Student Folders. Next, select the source worksheet that contains the student data and click on Continue button to move to the next step.

On the next screen, you can specify conditions for creating folders in Google Drive. For example, you can create folders just for students taking a particular subject or in a particular class. press Continue button to move to the next step.

select Google Drive Select Actions and then Create Folder From the dropdown menu. Next, select the parent folder in Google Drive where the student folders should be created. You can choose to create folders within your personal Google Drive or a shared drive.

Folders and Subfolders Naming Student Folders

Now that you have selected the parent folder, you need to define the name of the child folder along with its subfolder structure.

for the Subfolder Name Field, we will keep {{ Full Name }} / {{ Subject 1 }} And it will do two things:

  1. Create a new folder for each student with the student’s name in the parent folder. A folder is created only if it does not already exist.

  2. Within the Students folder, create a subfolder for Subject 1 which students are taking. the value of Subject 1 The actual subject name from the Google Sheet has been replaced.

You can also keep {{Email Address}} column in Editors A field to automatically share student folders with their email addresses when a folder is created in Google Drive.

Create additional topic subfolders

Now that you have defined a task to create subfolders for the first topic, you can add more tasks to create subfolders for other topics as well.

Instead of creating a new task, you can simply copy and modify an existing task Subfolder Name to field {{ Full Name }} / {{ Subject 2 }} To create subfolders for the remaining topics.

Now that the workflow is ready, select Save and Run Option to create folders and subfolders in Google Drive. Folders will be created and a link to the folder will be placed in the spreadsheet. If the folder already exists, a link to the existing folder is placed in the spreadsheet.

The folder structure in Google Drive looks like this:

See also: Create folders for Google Form responses

Leave a Comment