Skip to content

Instantly share code, notes, and snippets.

@rheajt
Created November 30, 2016 07:11
Show Gist options
  • Select an option

  • Save rheajt/ca5e28578482fb869f784352017de12c to your computer and use it in GitHub Desktop.

Select an option

Save rheajt/ca5e28578482fb869f784352017de12c to your computer and use it in GitHub Desktop.
create folders and save links to a google sheet
function createFolders(student) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var emails = sheet.getRange(2, student, sheet.getLastRow() - 1, sheet.getLastColumn());
var data = emails.getValues();
for(var i = 0; i < data.length; i++) {
if(!data[i][2]) {
var folder = DriveApp.getFolderById(REPORTS_ID)
.createFolder(data[i][0])
.addEditor(data[i][0])
.setShareableByEditors(false);
data[i][2] = folder.getUrl();
}
}
emails.setValues(data);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment