Teachers using Drive often need to set up folders for their class and for their individual students. Doing it in Drive is not the most exciting job to do. So, to make your life easier, here’s a script, which will set up your folders for you. I’ve made it so there is a little bit of flexibility depending on what folders you need, but of course the beauty of having the script is that you can always tinker with it to meet your exact needs.
It will create a class folder in My Drive, a folder for each student, and if you want a separate classwork folder and a separate homework folder. It will share the class, classwork, and homework folders with all the students, but only share the individual folders with the specific students.
Class Folder Creator sheet
Here’s the Sheet that we will use to fill out the information required and to run from the script from.
At the top, you add the class name, and then Y or N (yes or no), as to whether you want a classwork folder or homework folder or not.
Underneath you add the students’ names and email addresses. These could easily be pasted in if you already have a list.
Here are the main steps of the code:
- The code will get the details entered on the Sheet and store them in the variables.
- Then create the Class folder in My Drive.
- Add the students as editors to that folder.
- Check to see if you want a classwork folder or a homework one, and if so, create them.
- Finally, it will create the individual student folders.
There are some similarities to the code I used in my post “Multiple folder maker“, so here, I will focus more on the new parts. Let’s look at it line by line:
Lines 1 and 2: First we set up the function and get the Sheet.
Line 5: We then get the sheet called “ClassFolders”.
Line 6: We get the class name we entered in cell B2. Here I’ve used the number of rows and columns, i.e. (2, 2). I could have in fact just used “B2” in the brackets.
Line 9: Here we find out if the user wants a classwork folder or not by getting the value in cell B3, i.e. (3,2). We store it in the variable classwork.
Line 10: Similarly, we find out if the user wants a homework folder. We store this in the variable homework.
Line 13: We get the row with the last student name and student email on it, which will the last row on the Sheet.
Line 14: Now we need to get the list of students. Here we start at row 6 and column 1 (A) and go down until the last row minus 5 (we don’t count the first 5 rows as we started on row 6), and we are just getting 1 column so we finish the range with a 1, then get the values in that range. We store these values in the variable studentsNames.
Lines 17 and 18: We repeat the same for the students’ email addresses, which are in column 2 (B). We store these in the variable studentsEmails.
Now we need to create the class folder.
Line 21: We’re going to create it in My Drive, so we use the DriveApp class followed by the createFolder() method. Then we add the class name variable, className. Then we store this in the variable newFolder.
Line 22: We then get the ID of that new folder. Note, we could save a line of code here, by just adding .getId() on the end of line 21, like this:
But, I’ll leave the steps in, so you can see what’s happening more clearly.
Line 23: Then we need to get that folder by its ID to be able to use it. We use getFolderById() to do so. Then we store it in the variable classFolder.
Now, we add the students as editors of that folder. We do this by looping through the students’ emails and adding them one by one to the folder.
Line 26: We set up a simple for loop and continue it while its less than the number of email addresses (using the length of the array studentEmails).
Line 27: Each time we go around the loop, we want to add a student as an editor to the folder. We get the folder (classFolder) and use the addEditor() to add them. We use the variable s in square brackets to show where in the array we are. So, it will start in position 0 and continue to the end of the list.
Now we want to see if the user wants to create a classwork folder and if so, create one in the class folder we recently created.
Line 31: We use an If statement to see if the classwork cell contains a “Y”.
Lines 32: This is similar to line 21, except here we’re going to create the folder not in My Drive but in the class folder. So, we get the classFolder variable and create the folder using that, and call it “Classwork”.
Lines 36-38: We do exactly the same for the homework folder.
Now we want to create the individual student folders. The folder creation is similar to before, except this time we will be looping down the list of student names previously stored in the variable studentsNames.
Line 41: We set up a for loop to go down the list of student names, using the i variable to track where we are in the list.
Line 43: We then create a folder in the class folder and name it with the current student name we are at in the loop. We do that by using studentsNames[i].
Lines 44-45: Then we get the ID of the student just created and get the folder by that ID.
Now, we need to change the access rights for the student folders. As the student folders will be created in the class folder, they automatically assume the same access rights as the class folder. So, for each individual folder, we need to remove all the students except for the one who needs access to their personal folder. To do that we remove all the students as editors, then add the specific student.
Line 48: We set up a second loop, this time using the variable j to keep count. This will loop down the list of student emails.
Lines 49-50: Every time the loop goes around, it will remove a student email from being an editor of this folder. To do this we use the removeEditor() method and pass the studentsEmails variable to it. Then we close the j loop.
Lines 51-52: Then we need to add the student we want, who is the same as the student we created the folder for. So, we use addEditor() to add them and we use the i variable to identify which student it is. Then we close the i loop.
Lines 55-56: Finally, I think it’s good to tell the user that the process has finished. So, here we display a toast message, using the toast method. Then in line 56 we close the function.
To run the code from a menu on the Sheet, I’ve also added this onOpen function (explained in previous posts):
Running the code
Now let’s run an example with the information entered as below:
Click on the “Folders” menu and then “Make & share class folders”.
The first time you’ll be asked to authorise the script, Just click the blue boxes.
This will take about 10 seconds and once you see the toast message, we will see the new folder called “Maths 101″in our My Drive.
Double-clicking on that, we can see the sub folders we have created. There are the classwork, homework, and student ones.
If we look at the access rights the class folder has (and also the Classwork and Homework have), we’ll see it’s been shared with everyone on my little list. Note, as I included myself in the list of “students”, I’m both a student and owner of the folder.
Looking at the access rights of the “Baz Roberts” folder we’ll see it’s only been shared with me (Barrie Roberts-the owner) and the student “Baz Roberts”.
The students get an automatic invite to the class folder and an invite to their individual folder.
Hopefully, this will save you some time and effort. You can make a copy of the file and code here. In the same file, I’ve included this script, and the ones from previous posts: file maker and folder maker.
Here’s the full code:
eBooks available on Drive, Forms, Sheets, Docs, Slides, and Sheet Functions:
- “Beginner’s Guide to Google Drive” – iBooks store / Kindle store
- “Beginner’s Guide to Google Forms” – iBooks store / Kindle store
- “Beginner’s Guide to Google Sheets” – iBooks store / Kindle store
- “Beginner’s Guide to Google Docs” – iBooks Store / Kindle store
- “Beginner’s Guide to Google Slides” – iBooks Store / Kindle store
- “Google Sheet Functions – A step-by-step guide” – iBooks Store / Kindle Store
Follow my Google+ Learning Google Apps Script Collection