How to update Department for Google SSO


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
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:
- Google Cloud Directory Sync
- Google Admin (multiple accounts)
- Google Admin (single account)
Update using Google Cloud Directory Sync (GCDS)
- Sign in to the server hosting GCDS (usually the AD Server).
- Launch GCDS.
- In General Settings, confirm User Profiles is checked.
- Go to User Profiles and map the department to Department. For additional mapping options, see: Google User Profile Help and User Profile Attributes Guide
- 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)
- Sign in to your Admin Console.
- Click on the Users tile.

- Select the required organisational unit in the menu on the left, then click Download users.

- Choose all user info columns and currently selected columns and Comma-separated values (.csv), then click Download.

- Click Download CSV in the left Admin task area.

- Open the CSV file with user information you downloaded.
- Under the Department column, enter values such as Staff for staff or year group (e.g., Year 7, Year 8) for students.

- 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).
- Save the CSV file.
- Return to Admin Console and click Bulk upload users.

- Click ATTACH CSV, select your updated CSV file, then click Upload.

- The spreadsheet will be merged with user accounts (no new accounts created).
Update in Google Admin (single account)
- Sign in to your Admin Console (https://admin.google.com).
- Click on Users.

- Select the user to update the Department field for.
- Click User Information under Basic Information.

- Scroll to Department, select it, and add values like Staff or year group (Year 7, Year 8).

Frequently asked questions
Get in touch
If you’re having trouble finding the right topics or videos, just reach out! Our team - 

Akhil, Daniel, Jalaj, 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 Google Workspace SSO for your School using the new SAML process
Summary How do I set up Google Workspace SAML SSO for ClickView at my school? To set up SAML SSO for ClickView, create a custom SAML app in your Google Workspace Admin console and send your SSO URL, Entity ID, and certificate to ClickView Support, who will reply with your school-specific ACS URL and Entity […]
