Google Sheets

Configuring Google Sheets with Polytomic On Premises

Configuration

Set the following environment variables if you plan to use Google Sheets connections:

  • GSHEETS_CLIENT_ID, GSHEETS_CLIENT_SECRET Google OAuth Client ID and secret, obtained by creating a OAuth 2.0 Client ID.

    The Google Drive API and Google Sheets API must be enabled for the
    associated project. See Google Help for instructions on enabling APIs.

    Your valid redirect URLs must include {POLYTOMIC_URL}/connect/gsheets.

  • GSHEETS_APP_ID, GSHEETS_API_KEY Google App ID & API Key used for displaying the Google Sheets Picker when configuring a connection. See below for step-by-step instructions for generating these values.

Finding the App ID

The Google Application ID is a numeric value associated with your Google Cloud project. To find the value, click the menu button in the upper left and select IAM & Admin.

296296

The App ID is listed on the following page as the Project Number.

17251725

Set this value as GSHEETS_APP_ID in the Polytomic environment.

Generating the API Key

  1. Before you generate the API Key, you must enable the Google Picker API for your Project.
10331033

You can find the Picker API by searching the Google API Library, or by clicking here.

  1. After you enable the API, you’ll be take to the list of valid credentials for the Picker API.
10351035

Click the + Create Credentials button, and select API key

  1. Google will generate a new key for you to copy.
522522

Set this value as the GSHEETS_API_KEY in your Polytomic environment.

  1. We recommend you place restrictions on this key in order to avoid abuse.

    Click Restrict Key to configure restrictions.

14901490

You can restrict the key based on HTTP referrer, enabled APIs, or both.