Skip to content
  • There are no suggestions because the search field is empty.

Create Bulk Operations in gPanel

The gPanel Bulk Operations feature is the essential automation tool for Google Workspace administrators, enabling massive, hands-free updates to user profiles, group memberships, and shared contacts. Easily manage domain-wide changes, including onboarding thousands of new users from a single spreadsheet, all while the system provides real-time progress monitoring and error logging.

The Bulk Operations feature within the Automation module allows administrators to update settings and fields for multiple users, groups, or shared contacts simultaneously using a customized Google Sheet.

Administrators can use this tool to perform mass updates to user profiles, group memberships, and shared contact directories by importing a single spreadsheet, which significantly reduces the manual work required for large-scale domain changes.

The feature supports both creating new entries such as onboarding over 2,000 users at once and updating existing records to ensure consistent data across the entire organization.

Because these jobs run behind the scenes, the tool enables "hands-free" management of complex daily tasks while providing real-time progress monitoring and error logging for every batch operation.

  1. Select the ‘Create Bulk Op’ Button on the top Right of the table. The image shows a user interface with a section titled 'Bulk Operations' at the top. Below the title, there are two buttons labeled 'COLUMNS' and 'FILTERS'.
  2. Fill out the basic information and Email notifications: 

    This section is used to define the administrative details and the type of bulk task being performed:

    • Identification: You must provide a Name for the operation and have the option to add a Description for internal tracking.
    • Bulk Import Type: A mandatory dropdown menu where you select the specific category of the operation (such as updating user profiles or group memberships).

    The following are the bulk import types:

    Calendar

    • Abandoned Calendar Events - run a massive process to delete all the events, recurring meetings or resources that have previously been booked by users no longer in the domain
    • Calendar Events - quickly create multiple calendar events in one action. This feature streamlines bulk scheduling by eliminating the need to enter appointments manually
    • Calendar Permission Setting - allows you to set Calendar permissions for bulk users
    • Remove from Calendar Events - will remove the selected room from all calendar events within the selected time

    Drive

    • Drive Transfer - allows you to transfer all documents from one user to another
    • Remove User from Shares - removes the selected users from all shares
    • Remove User's Shares -  removes all shares on files owned by the selected users

    Group

    • Clear Users From Group - allows you to remove all users from a specified group
    • Group Deletion - allows you to delete multiple groups at once
    • Group - allows you to make group settings changes to multiple groups at once
    • Group Removal - allows you to remove a select group of users from all groups
    • Group Member Settings Update - allows you to update group member's Role and / or Email Delivery setting

    User

    • Bulk Assign Archive User Licenses - allows bulk assignment of Archive User Licenses
    • Bulk Upload Profile Pictures - allows to bulk upload profile pictures from drive
    • Bulk Upload Users - allows to bulk upload users from drive
    • Force Password Reset - allows you to force a select group of users to reset their account passwords
    • Force Sign Out - allows you to sign out the selected group of users
    • gPanel Role Permissions - allows you to update permissions for multiple roles at once
    • Multiple User Vacation Responder - allows you to add a vacation responder to one or more users
    • Personal Contact Deletion - allows you to delete all personal contacts from a selected set of users
    • Shared Contact - allows you to update the information of many shared contacts at once
    • Shared Contact Deletion -  will delete all shared contacts from your domain. This process is irreversible
    • Signature Template Block List Status -  gives the blocklisted status for users.
    • Update User Profiles -  allows you to make user profile changes to many users at once.
    • Email Notifications: This feature allows you to search for and select specific users or groups who should receive an automated email notification once the bulk operation has finished processing.The image shows a user interface for creating a bulk operation. It includes sections for basic information, such as providing a name and choosing a bulk import type, and for email notifications, with an option to search for a user or group to be notified.

     

              3.  Choose Spreadsheet: This step enables you to provide the data for your bulk operation by uploading a spreadsheet of your choice. You have the option to download and use a preformatted template to ensure data accuracy before re-uploading, or you may simply upload your own custom spreadsheet. The image displays a user interface for creating a bulk operation in Google Sheets. It includes options for basic information, choosing a spreadsheet, and reviewing the operation

     

              4.  Review and Save. Carefully review your configured Bulk Operation to ensure accuracy. Once confirmed, click 'Finish' to save your settings.The image displays a user interface for creating a bulk operation, specifically for importing a calendar events template.