Loading existing users

The query filters available for loading existing users include:

User Type

  • is Active or Suspended (default)
  • is Active
  • is Suspended
  • is Recently Deleted

Org Unit Path

  • is any value (default)
  • equals
  • contains

Last Login Time

  • is any value (default)
  • is before <date>
  • is after <date>
  • is never

 

These provide a powerful combination user querying options not easily available via the G Suite Admin Panel, however for even more filtering power, the "More Filters" button explains how to use native Sheets filters on your import.

Checking the "Include group membership" box will populate an additional Current group membership column listing all domain groups each user is a member of.  Note that for performance reasons, a maximum of 100 groups will return for each user.