Google Sheets add-on

The Google Sheets add-on enables you to upload requirements, tests, and defects from Google Sheets directly to OpenText Application Quality Management.

Overview

All Google Sheets requests are sent from Google cloud instead of the Google client, therefore, this add-on supports only the following:

  • OpenText Application Quality Management SaaS

  • OpenText Application Quality Management servers that are accessible over the internet, without using a VPN

    Note:

  • You cannot use this add-on to upload attachments for requirements, tests, or defects.

  • If your server is set up inside your company's internal network, the add-on does not work.

Install Google Sheets add-on

Before you install the Google Sheets add-on, ensure that Google Sheets is working properly on your machine.

Before you use the add-on, you must install it. After installation, this add-on is available in your Google Sheets spreadsheet.

Note: To install this add-in for all users, you must log in with administrator privileges.

To install the Google Sheets add-on:

  1. Open the online Google Sheets.

  2. Click Extensions > Add-ons > Get add-ons.

  3. In the Google Workspace Marketplace window, search with the keyword ALM.

  4. Click the ALM Google Sheets Add-on card to open its details page. Click Install.

  5. In the Get ready to install window, click Continue.

  6. Select your Google account to continue the installation.

    The ALM wants to access your Google Account page opens, showing the list of operations this add-on attempts to do. Review the list, and if you want to grant the permissions, click Allow.

  7. Click Done.

    You can find OpenText ALM under the Extensions menu of your worksheet.

Back to top