Strategy One

Configure Google Sheets Export

Starting in Strategy One (March 2026), users can export reports and dashboards into Google Sheets. To utilize this functionality, administrators and users must perform the following:

  • An administrator must configure Google Cloud and Strategy.

  • Each user must authorize access to their Google account the first time they use the feature.

  • Each user must have the Export to Google Sheets privilege.

    For more information on editing user privileges, see Edit Existing Users and Groups.

See the following sections for more information on configuring Google Cloud and Strategy for Google Sheets export.

Create a Google Cloud Platform Project

  1. Sign in to Google Cloud.

  2. In the left navigation pane, click IAM and Admin and Create a project.

  3. Type a Project name, choose an Organization, and select a Location.

  4. Click Create.

For more information on creating a Google Cloud project, see Create a Google Cloud project.

Enable the Google Drive API

  1. In the Google Cloud left navigation pane, click APIs and Services and Enabled APIs and services.

  2. Click Enable APIs and Services.

  3. In the Search, type "Google Drive API" and press Enter.

  4. Select Google Drive API and click Enable.

Configure the OAuth Consent Screen

  1. In the Google Cloud left navigation pane, click APIs and Services and OAuth consent screen.

  2. Click Get started and follow the setup:

    1. Choose an Audience.

      If you choose Internal, your app is limited to Google Workspace users within your organization.

    2. Type an App name, User support email, and Email address.

    3. Click Next.

    4. Review the user data policy and select I agree to the Google API Services: User Data Policy.

    5. Click Continue and Create.

  3. The key application information displays on the Branding page. Go to the Clients page.

  4. Click Create Client and follow the setup:

    1. In Application type, choose Web application.

    2. Type a Name.

    3. Type temporary required URIs. You will refine the redirect URIs in the next section.

    4. Click Create.

    5. To save the Client ID and Client Secret, click Download JSON.

      The Client ID and Client Secret will be used in future steps.

Configure Redirect URIs

  1. On the Google Cloud Clients page, find the OAuth client you just created and click Edit.

  2. In Authorized redirect URIs, click Add URI.

    To create your URI, for example, if your Library URL is https://<your_envrionment>/StrategyLibrary, add /auth/DIOAuthRedirect.jsp to the end of the URL to generate the Authorized redirect URI. The final URL will be https://<your_envrionment>/StrategyLibrary/auth/DIOAuthRedirect.jsp.

    You can add multiple URIs to support multiple Library instances or applications.

  3. Click Save.

Create Authorization Configuration

  1. Connect to your Strategy environment in Workstation.

  2. In the Navigation pane, click , next to Enterprise Security.

  3. In Type, choose Gateway Authorization.

  4. Click Next.

  5. Type a Display Name.

  6. In the 1. Select an identity provider drop-down list, choose Google Export.

    Only one Google Export configuration is allowed per environment. If a Google Export configuration already exists, the option is not available.

  7. In 2. Strategy Configuration, paste the Client ID and Client Secret you noted above.

  8. Click Save.

Export to Google Sheets

  1. In Strategy Library, open a dashboard or report you want to export to Google Sheets.

  2. Click Share and choose Export to Google Sheets.

  3. If you are choosing this option for the first time, the browser redirects you to Google's OAuth consent screen:

    1. Sign in with your Google account.

    2. Click Continue.

      Future exports will reuse this authorization.

  4. The export completes and a notification displays at the bottom of your screen. Click the URL link to open the Google Sheets file.

    Exported files are created in the root folder of your Google Drive (the "My Drive" root of your Google account). Updating the target folder is not yet supported.

Update or Remove the Linked Google Account

To update the Google account linked to your Strategy user or to de-authorize it, use the following steps:

  1. Go to Google (for example, Google Drive or any Google app).

  2. Click your profile icon and choose Manage your Google Account.

  3. Go to Security or Data and privacy.

  4. Click Third-party apps and services.

  5. Find the MicroStrategy entry (for example, MSTR Export or similar).

  6. Click Remove access or Delete all connections that you have with MSTR Export.

  7. The next time a user chooses Export to Google Sheets, the user will be prompted to log in with the Google OAuth consent screen.

  8. Log in with the same Google account or a different Google account, as needed.