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);
    }
  }
}