Make Folders from Spreadsheet Data in Google Drive? -
i beginning learn javascript , google apps script. have looked @ , played few scripts, , attempting create own. want take list of students (name , email) , run script create "dropboxes", or folders uses name , shared email address. way, can submit work me in organized manner. have written rough script, know not work. i wondering if can give me tips? function createdropbox () { // current spreadsheet var ss = spreadsheetapp.getactivespreadsheet(); var data = sh1.getdatarange().getvalues(); // each email address (row in spreadsheet), create folder, name data class , name column, share email for(n=1;n<data.length;++n){ var class = sheet.getsheetvalues(n, 1, 1, 1); var name = sheet.getsheetvalues(n, 2, 1, 1); var email = sheet.getsheetvalues(n, 3, 1, 1); var folder = docslist.createfolder('dropbox'); folder.createfolder(class . name); var share = folder.addeditor(email); } } you've got basic structure of script right, it's semantics...