Bulk update existing users' properties & attributes

The Update properties & attributes workflow will allow you to preview and push Google Workspace user updates from any of the following color-coded column groups as well as for enabled, custom-defined user attributes on your domain.

    • Basic information
      • Last name
      • First name
      • Primary email address
    • Properties
      • Org unit path
      • Suspended
      • Exclude from global contact directory
      • Force pw change at next login
    • Contact information 
      • Work phone 1
      • Home phone 1
      • Mobile phone 1
      • Work address 1
      • Home address 1

You can stage update jobs using either of the following two approaches. Both approaches operate only on the visible users in the sheet. You should use Sheets Filters to reduce your update to only those users requiring an update.

Update method 1: From difference with current admin console values

This method creates a preview of all changes based on the difference between the current Admin console values and the values in the Sheet. 

Note: This method can be very slow to load when working with large sets of 1,000 or more users. 

  1. Click the Bulk User Actions tab of the sidebar.
  2. Review the properties and attributes that will be edited.
  3. Click Next.
  4. Click Update properties & attributes.  This will open a workflow stepper.
  5. Select the From difference with current admin console values as the staging method for the update.
    UpdateStep2FromDifferenceHL.png

  6. Click Next. A preview of changes opens.
    The preview and application of updates are performed based on a cross-reference between the current value of each field in the Google Workspace Admin panel and those found in the Sheet. The preview of changes can be viewed as a list by attribute or per user.
      • List preview: This is the default view. You can filter this list by checking/unchecking a field in the left column.  For instance, unchecking the checkbox next to Suspended would remove that action from being staged, but the Google Sheet information would not be changed.

      • Per-user granular preview: Click on a user, setting the toggle in the upper right corner reveals a per-user detailed view of changes to be applied.

  7. Click Run Bulk Actions.

Update Method 2: Skip difference analysis

This method lets you simply select which Sheets columns you want to push to the Admin console, without providing any preview of the differences.  This method is faster and is recommended for larger jobs, provided you are confident in the changes you are making.

  1. Click the Bulk User Actions tab of the sidebar.
  2. Review the properties and attributes that will be edited.
  3. Click Next.
  4. Click Update properties & attributes.  This will open a workflow stepper.
  5. Select the Skip difference analysis as the staging method for the update.
    UpdateStep2SkipDifferenceHL.png

  6. Click Next. A preview panel opens.
  7. Select the Sheet columns to include in the update.
    Screen_Shot_2017-12-29_at_1.31.37_PM.png
  8. Click Run Bulk Actions.