1. Extensions
  2. Google Sheets Add-on
  3. Sign in to Google Sheets Add-on
  4. Select authentication type for the Google Sheets Add-on

Choose whether to sign in to the Anaplan Google Sheets Add-on using your standard Anaplan log in credentials or Single Sign-On.

Self Service SAML must be configured in order to sign in to the Google Sheets Add-on with SSO. Talk to your tenant administrator to confirm if Self Service SAML is configured.

If Self Service SAML is not configured, sign in with your Anaplan email address and password.

You need to install the add-on before you select your authentication type. 

If this is first time you sign in after you've installed the add-on, the Authentication Type Selection dialog displays automatically. 

If not, you can navigate to the Authentication Type Selection dialog via Settings.

Note: Once a connection has been created in a spreadsheet, only the connection owner can change the settings. If you're not the connection owner, open a new spreadsheet to access Settings.

To navigate to the Authentication Type Selection dialog after you sign in:

  1. In the Anaplan sidebar, select Settings.
    The Settings menu displays.
A Google Sheets worksheet with the Settings menu open in the sidebar.
  1. Select Reset authentication type.
    The Authentication type selection dialog displays.

To select an authentication type:

  1. In the Authentication type selection dialog:
    • choose Anaplan username and password to sign on to the add-in with the same email address and password you use for Anaplan.
    • choose Single Sign On (SSO) if your organization uses single sign-on.
      If you choose single sign-on, enter your SSO friendly name in the SSO friendly name field. Your tenant administrator can provide this for you.
      To sign using Google Cloud Platform, select Other from the drop-down menu under the SSO friendly name field.
  2. Click Next.
    The Sign in page for the authentication type you selected displays.
  3. Sign in to use the add-on.