How To Bulk Upload Users in gPanel

You can now bulk upload users in gPanel. This will allow you to add multiple users from a Google Sheet.

Before you begin

  • This process can only be run once. If the process fails, you will need to start over.
  • The same sheet cannot be used more than once. For every Bulk Upload User operation you wish to complete, you will need to create a new spreadsheet and a new Bulk Operation.

How to bulk upload users in gPanel

1. Hover over Tools and then click Bulk Operations.

Bulk operations selected on the Tools menu section in gPanel

 

2. Click the + icon in the top right corner.

Plus sign icon circled in gPanel bulk operations

 

3. Give the operation a name and description. Then select Bulk Upload Users from the dropdown menu. Once this is done, click Next.

Setup bulk operation fields circled in gPanel

 

4. Next, you will need to select a Google Sheet from your Google Drive.

The sheet must contain these column headers: First Name, Last Name, Email Address, Password, and Org Unit Path. Below is an example of how the sheet should be set up.

Example of Google sheet with first name, last name, email address, password, and org unit path as column headers

 

5. Once you have your Google Sheet set up, click Select File.

Select file button circled on the choose a spreadsheet screen in gPanel

 

6. Select the spreadsheet you are wanting to use and click Select.

Select button circled in the select file popup for bulk upload users in gPanel

 

7. Click Next.

 

8. In the review section, you have the option to send a notification on completion. If you would like to do this, check the box next to “Send email notifications on completion?” Enter the user that you want to notify and click the + icon to add them. You can add multiple users to the notification list. If you do not want to send a notification on completion, leave the box unchecked.

Review page of bulk upload users creation in gPanel

 

9. Once you have reviewed everything, click Submit at the bottom of the page.

 

10. The Bulk Operation is now running. A popup box will appear notifying you that the Bulk Operation has been saved.

 

11. The popup also includes a link to the Google Sheet that you uploaded. Click on the “here” link to open the sheet and see the status of the operation. If you see any errors, you can open the Errored Rows tab at the bottom of the sheet.

Bulk upload users Google sheet with errored rows circled

 

12. You will also see a notification in the top right corner of gPanel telling you that the process has been completed. The message will also notify you of any errors.

Check out more gPanel resources here.

 

Was this article helpful?