cedroid

Google Apps Script create Workspace groups

Dec 22nd, 2023
1,205
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function createOudergroepLeerling() {
  2.   var sheetName = 'testnieuweaccount';
  3.   var groupSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  4.   var data = groupSheet.getDataRange().getValues();
  5.  
  6.   for (var i = 1; i < data.length; i++) {
  7.     var groupName = data[i][7];
  8.     var groupEmail = data[i][4];
  9.     var description = 'ouders van...';
  10.  
  11.     if (groupName && groupEmail) {
  12.       var group = {
  13.         email: groupEmail,
  14.         name: groupName,
  15.         description: description
  16.       };
  17.  
  18.       try {
  19.         AdminDirectory.Groups.insert(group);
  20.         Logger.log('Group created successfully: ' + groupName);
  21.       } catch (e) {
  22.         Logger.log('Error creating group: ' + groupName + ', Error: ' + e.toString());
  23.       }
  24.     } else {
  25.       Logger.log('Error creating group: Incomplete data for group ' + groupName);
  26.     }
  27.   }
  28. }
  29.  
Advertisement
Add Comment
Please, Sign In to add comment