How to update Department for Google SSO

Single Sign-On

Summary

  • Sign in to your Admin Console
  • Update Department using Google Cloud Directory Sync
  • Edit multiple accounts with a spreadsheet in Admin Console
  • Edit a single account using Admin Console
  • ‘Department’ can be set to ‘Staff’ or year group, such as Year 7, Year 8
star icon
Quick tip
Why is it important to keep the Department field accurate for ClickView access?
ClickView uses the Department field during Google SSO to determine whether a user is staff or a student and, for students, which year group they belong to. Keeping this field up to date helps ensure users are placed into the correct access level automatically and prevents sign-in or permission issues later on.

Methods for updating the Department field

You can update the Department field for Google user accounts using one of three recommended methods. Choose the method that best fits your organisation’s needs:

  1. Google Cloud Directory Sync
  2. Google Admin (multiple accounts)
  3. Google Admin (single account)

Update using Google Cloud Directory Sync (GCDS)

  1. Sign in to the server hosting GCDS (usually the AD Server).
  2. Launch GCDS.
  3. In General Settings, confirm User Profiles is checked.
  4. Go to User Profiles and map the department to Department. For additional mapping options, see: Google User Profile Help and User Profile Attributes Guide
  5. Ensure Active Directory has a value in the Department field (e.g., Staff for staff members, or the year group—such as Year 7, Year 8—for students).

Note: Synchronization with Active Directory will override changes made in Google Admin Console.

Update in Google Admin (multiple accounts)

  1. Sign in to your Admin Console.
  2. Click on the Users tile.
    Users tile screenshot
  3. Select the required organisational unit in the menu on the left, then click Download users.
    Download users screenshot
  4. Choose all user info columns and currently selected columns and Comma-separated values (.csv), then click Download.
    Download CSV screenshot
  5. Click Download CSV in the left Admin task area.
    Admin task screenshot
  6. Open the CSV file with user information you downloaded.
  7. Under the Department column, enter values such as Staff for staff or year group (e.g., Year 7, Year 8) for students.
    CSV editing screenshot
  8. Note:
    • Leave untouched columns, delete if not required, or clear information as needed.
    • For non-required columns left blank, existing data remains unchanged.
    • To keep passwords unchanged, ensure the Password column contains **** (four asterisks).
  9. Save the CSV file.
  10. Return to Admin Console and click Bulk upload users.
    Bulk upload screenshot
  11. Click ATTACH CSV, select your updated CSV file, then click Upload.
    Attach and upload screenshot
  12. The spreadsheet will be merged with user accounts (no new accounts created).

Update in Google Admin (single account)

  1. Sign in to your Admin Console (https://admin.google.com).
  2. Click on Users.
    Users tile screenshot
  3. Select the user to update the Department field for.
  4. Click User Information under Basic Information.
    User Information screenshot
  5. Scroll to Department, select it, and add values like Staff or year group (Year 7, Year 8).
    Department field screenshot

Frequently asked questions

Enter their year group, such as Year 7 or Year 8, in the Department field.
Yes. Any changes in Active Directory will override updates in Google Admin Console if synchronization is used.

Get in touch

If you’re having trouble finding the right topics or videos, just reach out! Our team - Andrew photoNischal photoJanice photoPfreya photo Andrew, Nisch, Janice, Pfreya, or any of us at ClickView - will be happy to help you get sorted.

Give feedback

Was this guide helpful?

Up Next

How to set up Okta SAML SSO with ClickView

This article explains how to configure a SAML 2.0 application in Okta for use with ClickView and submit the required metadata so the SSO instance can be set up.