Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function createOudergroepLeerling() {
- var sheetName = 'testnieuweaccount';
- var groupSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
- var data = groupSheet.getDataRange().getValues();
- for (var i = 1; i < data.length; i++) {
- var groupName = data[i][7];
- var groupEmail = data[i][4];
- var description = 'ouders van...';
- if (groupName && groupEmail) {
- var group = {
- email: groupEmail,
- name: groupName,
- description: description
- };
- try {
- AdminDirectory.Groups.insert(group);
- Logger.log('Group created successfully: ' + groupName);
- } catch (e) {
- Logger.log('Error creating group: ' + groupName + ', Error: ' + e.toString());
- }
- } else {
- Logger.log('Error creating group: Incomplete data for group ' + groupName);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment