[Bulk Operations] Group

 Group Operations allow you to modify many different settings for multiple groups in one bulk job.  
 Begin by clicking Add Bulk Operation.

 





Setup Group Operations

 1)  Give the Bulk Operation a name and, optionally, a description.  Select Group for the Operation type.


 2)  Once complete click Next

   



 Select your Path

 3)  Select your path by selecting either Guide Me or Advanced.
  • Guide Me - The Guided bulk operation process will walk you through making bulk updates to users, groups, or shared contacts in your Google Apps domain.
  • Advanced - The Advanced bulk operation process will allow you to immediately start an update process using an already created and/or modified Google Spreadsheet.

  

 4)  After you select your path click Next

   


 Guide Me Path


 Select Columns

 5)  From the Available Columns list, select those columns you wish to have in the spreadsheet template you will
      use for the import.  Once you have selected the columns you wish to modify, click Add Selected.

   
 
 Note: Group Email is added by default. This is required for the import and must not be edited.

 6)  Once the columns are added click Next.

   


 Sources

 You will now select the source groups for the bulk import.  As you type in the search field, potential matches will 
 populate in the sources list below.  Alternatively, by selecting the Browse tab, you can select the sources from 
 all of the options available in your domain.


 7) Select the source groups for the bulk import, then click Add Selected.

   

 8)  Once the source groups are added, click Next.

   


 Review

 The final setup screen will allow you to review your configuration choices.  If you would like to send email notifications 
 on completion of the import, check the corresponding box to Send Email Notifications and enter the 
 user(s) who will receive the notifications.


 9)  Review your selections, and add users to notify if so desired.

   

 10)  After your done reviewing, click Submit to create the spreadsheet template that will be used for the import.

   

 11)  After clicking submit the bulk operation will be saved and the spreadsheet can be viewed by clicking the here link in the pop up.

   

 12)  When your done click Close.

   


 Advanced Path


 Choose a Spreadsheet

 5)  Select the Google sheet to use for this bulk operation by clicking Select File.

   

 6)  Select the sheet from the Select a file pop up window, then click Select.

  

 7)  After the sheet has been selected, click Next.

   


 Review

 The final setup screen will allow you to review your configuration choices.  If you would like to send email notifications 
 on completion of the import, check the corresponding box to Send Email Notifications and enter the 
 user(s) who will receive the notifications.

 8)  Review your selections, and add users to notify if so desired.

   

 9)  After your done reviewing, click Submit to run this bulk operation.

   

 10)  After clicking submit the bulk operation will be saved and a pop up will appear notifying you that the operation is running.

   

 11)  To close the pop up click the Close button.

   


 Update the Spreadsheet

 Once you have setup the import, it will appear in the list of Bulk Imports. Select View Spreadsheet by selecting the import and clicking the three vertical dots.

   

 This will open your customized Google Sheet template in a new browser tab.  The Sheet will contain the groups and columns you selected during
 the setup step.

 The first column, Group Email, is required for the import and must not be edited.
  
 Important! If the Group Email is changed, the import will fail for all changes to that group.

   



The remaining columns can all be modified and are described below:
  • Name: The name of the group as it appears in Google Apps
  • Description: The description for the group
  • Aliases: The email aliases for the group.  
    • If you wish to add more than one alias, separate each alias with a comma
  • Add Members:  Add new members to the group
    • If you wish to add more than one member, each email address must be separated with a comma
  • Remove Members:  Remove members from the group
    • If you wish to remove more than one member, each email address must be separated with a comma
  • Custom Reply To:  A custom address for sending replies to posts
  • Default Message Deny Notification Text: A default message used to notify authors when moderators reject their posts
  • Max Message Bytes: This option limits the size of messages to this group. Use one of the following values:
    • 10240 = 10 KB
    • 102400 = 100 KB
    • 1048576 = 1 MB
    • 5242880 = 5 MB
    • 10485760 = 10 MB
    • 26214400 = 25 MB
  • Allow Web Posting: Allows group members to post from the Group web interface (as opposed to just email)
    • Should be set to TRUE or FALSE
  • Show in Group Directory: List the group in the Google Groups directory in the web interface
    • Should be set to TRUE or FALSE
  • Allow External Members: Allow group members outside of your domain
    • Should be set to TRUE or FALSE
  • Send Message Deny Notification: Enable notifications to authors when moderators reject their posts
  • Is Archived: Controls if group messages are archived
    • Should be set to TRUE or FALSE
  • Primary Language: This is the language emails from the Google groups service will be sent in
  • Who Can View Membership: Specify who can view the group membership list. Use one of the following values:
    • Managers of the group
    • All members of the group
    • All organization members
  • Who Can Post Messages: Specify who can post messages to the group.  Use one of the following values:
    • Managers of the group
    • All members of the group
    • All organization members
    • Public
  • Who Can Join: Specify who can join the group.  Use one of the following values:
    • Anyone in the organization
    • Anyone in the organization can ask
    • Only invited users
  • Who Can View: Specify who can view the group's topics. Use one of the following values:
    • Managers of the group
    • All members of the group
    • All organization members
    • Public
  • Who Can Invite: Specify who can invite new members to the group. Use one of the following values:
    • Managers of the group
    • All members of the group
  • Spam Moderation Level: Specify how suspected spam messages be handled. Use one of the following values:
    • Send them to the moderation queue and send notification to moderators
    • Send them to the moderation queue but do not send notification to the moderators
    • Immediately reject them
    • Skip the moderation queue and post to the group
  • Message Moderation Level: Specify how messages to the group are handled. Use one of the following values:
    • Moderate all messages
    • Moderate messages by new members
    • Moderate messages by non members
    • Don't moderate messages
  • Reply To: Specify where replies to posts should be sent. Use one of the following values:
    • To the entire group
    • To the author of the message only
    • To the owners of the group
    • To the managers of the group
    • Users decide where their replies are sent
    • Use a custom address to send replies to
  • Include in Global Address List: When included in the list, the group becomes available to Google Apps Sync for Microsoft Outlook users
    • Should be set to TRUE or FALSE
  • Allow Google Communication: All Google to contact the administrator of the group
    • Should be set to TRUE or FALSE
  • Members Can Post as the Group: Allow members to post topics and replies from the group email address
    • Should be set to TRUE or FALSE
  • Message Display Font: Specify the font to use for the Google Groups web interface
    • Default Font
    • Fixed Width Font



 Once you have made the desired changes to the groups in the spreadsheet, select Run Now by clicking the three vertical dots
 for that import job.  

   

 A review screen will appear listing the first five rows of the spreadsheet to be used for the import.  Click the Run Operation button
 at the bottom of the screen to begin the import.  The import will run and will make any necessary updates to the groups that
 are listed in the spreadsheet.