Office 365 cloud app

• Add your Workspace domain to Microsoft Office 365. For instructions, go to Add a domain to Microsoft 365.
• Install PowerShell.

• Configure ImmutableID—Office 365 uses the ImmutableID attribute to uniquely identify users. For SSO between Google and Office 365 to work, each Office 365 user must have an ImmutableID and the SAML Name ID attribute sent to Office 365 during SSO must be the same as the ImmutableID.

  An Office 365 user's ImmutableID varies according to how the user is created. Here are the most likely scenarios:

  • No users yet in Office 365—If you're going to set up Google to automatically provision users, you don't have to configure the ImmutableID attribute. It's mapped by default to the user's email address, the User Principle Name (UPN). Continue to Step 1.

  • If users were created in the Office 365 Admin console—ImmutableID should be blank. For these users, use the PowerShell Update-MgUser command to set the ImmutableID in Office 365 to match the user's UPN:

    Update-MgUser -UserPrincipalName testuser@your-company.com -OnPremisesImmutableId testuser@your-company.com

    You can also use Update-MgUser to bulk update all users. For the steps, go to the PowerShell documentation.

  • If users were created via Microsoft Entra ID sync—ImmutableID is an encoded version of the Active Directory objectGUID. For these users:
    1. Use PowerShell to retrieve the ImmutableID from Entra ID. For example, to retrieve ImmutableID for all users and export to a CSV file:

       $exportUsers = Get-MgUser -All | Select-Object UserprincipalName, OnPremisesImmutableId | Export-Csv C:csvfile

    2. Create a custom attribute in Google, then populate each user's profile with their Office 365 ImmutableID. For the steps, go to add a new custom attribute and update a user profile. You can also automate the process using GAM (an open source command line tool) or the Admin console APIs.

    For more information on ImmutableID, go to the Microsoft documentation.

1. In the Google Admin console, go to Menu AppsWeb and mobile apps.

   Go to Web and mobile apps

   You must be signed in as a super administrator for this task.

2. Click Add app Search for apps.
3. For Enter app name, enter Office 365.
4. In the search results, point to Microsoft Office 365 and click Select.
5. In the Google Identity Provider details window, for Option 2: Copy the SSO URL, entity ID, and certificate:
   1. Next to SSO URL, click Copy and save the URL.
   2. Next to Entity ID, click Copy and save the entity ID.
   3. Next to Certificate, click Copy and save the certificate.

      You need these details to complete the setup in Office 365.

Leave the Google Admin console open. You'll continue with the configuration in the Admin console after completing the setup steps in the app.

1. Open an Incognito browser window, go to the Office 365 sign-in page, and sign in with your Office 365 administrator account.
2. Using a text editor, create PowerShell variables from the data you copied in Step 1. Here are the values needed for each variable:

   Variable	Value
   $DomainName	"your-company.com"
   $FederationBrandName	"Google Cloud Identity" (or any value you choose)
   $Authentication	"Federated"
   $PassiveLogOnUrl $ActiveLogOnUri	"SSO URL" (from Step 1)
   $SigningCertificate	"Paste complete certificate here" (from Step 1)*
   $IssuerURI	"Entity ID" (from Step 1)
   $LogOffUri	"https://accounts.google.com/logout"
   $PreferredAuthenticationProtocol	"SAMLP"

   * Ensure the $SigningCertifcate variable is on one line of text or PowerShell will return an error message.
3. Using the PowerShell console, run the Update-MgDomain command to configure your Active Directory domain for federation. For the steps, go to the Microsoft PowerShell documentation.
4. (Optional) To test federation settings, use the following PowerShell command:

   Get-MgDomainFederationConfiguration -DomainName your-company.com | Format-List *

Note: If your domain is already federated and you need to change federation to Google, run the following command using the same parameters listed in the table above:
Update-MgDomainFederationConfiguration

1. Return to the Admin console browser tab.
2. Click Continue.
3. On the Service provider details page:
   1. Check the Signed response box.
   2. For Name ID format, select Persistent.
   3. For Name ID, choose an option:
      • If you created a custom attribute to add the Office 365 ImmutableID to your users' profiles, select the custom attribute.
      • If you didn't create a custom ImmutableID attribute, select Basic Information Primary email.
4. Click Continue.
5. On the Attribute mapping page, click Select field and map the following Google directory attributes to their corresponding Office 365 attributes. The IDPEmail attribute is required.

   Google Directory attribute	Office 365 attribute
   Basic Information > Primary Email	IDPEmail*

6. (Optional) To add additional mappings, click Add Mapping and select the fields that you need to map.
7. (Optional) To enter group names that are relevant for this app:
   1. For Group membership (optional), click Search for a group, enter one or more letters of the group name, and select the group name.
   2. Add additional groups as needed (maximum of 75 groups).
   3. For App attribute, enter the corresponding groups attribute name of the service provider.

   Regardless of how many group names you enter, the SAML response includes only groups that a user is a member of (directly or indirectly). For more information, go to About group membership mapping.

8. Click Finish.

1. In the Google Admin console, go to Menu AppsWeb and mobile apps.

   Go to Web and mobile apps

   You must be signed in as a super administrator for this task.

2. Click Office 365.
3. Click User access.

4. To turn a service on or off for everyone in your organization, click On for everyone or Off for everyone, and then click Save.

5. (Optional) To turn a service on or off for an organizational unit:

   1. At the left, select the organizational unit.
   2. To change the Service status, select On or Off.
   3. Choose one:
      • If the Service status is set to Inherited and you want to keep the updated setting, even if the parent setting changes, click Override.
      • If the Service status is set to Overridden, either click Inherit to revert to the same setting as its parent, or click Save to keep the new setting, even if the parent setting changes.
        Learn more about organizational structure.
6. (Optional) To turn on a service for a set of users across or within organizational units, select an access group. For details, go to Customize service access using access groups.
7. Ensure that your Office 365 user account email domains match the primary domain of your organization's managed Google account.

Office 365 supports both identity provider-initiated and service provider-initiated SSO.

Verify identity provider-initiated SSO

1. In the Google Admin console, go to Menu AppsWeb and mobile apps.

   Go to Web and mobile apps

   You must be signed in as a super administrator for this task.

2. Click Office 365.
3. In the Office 365 section, click Test SAML login.

   The app should open in a separate tab. If it doesn't, troubleshoot the error message and try again. For details on troubleshooting, go to SAML app error messages.

Verify service provider-initiated SSO

1. Close all browser windows.
2. Go to the Office 365 sign-in page and sign in with your Office 365 administrator account.
   You should be automatically redirected to the Google sign-in page.
3. Select your account and enter your password.

After your credentials are authenticated, the app should open.

As a super administrator, you can automatically provision users in the app. For details, go to Configure Office 365 user provisioning.