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]
(https://support.google.com/googleapi/answer/6158841?hl=en) 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.
![gcp_hamburger.png 296](https://files.readme.io/6421a6a-gcp_hamburger.png)
The App ID is listed on the following page as the Project Number.
![appID_01_GCP_IAM.png 1725](https://files.readme.io/1df01cb-appID_01_GCP_IAM.png)
Set this value as GSHEETS_APP_ID
in the Polytomic environment.
Generating the API Key
- Before you generate the API Key, you must enable the Google Picker API for your Project.
![apiKey_01_enable_api.png 1033](https://files.readme.io/ca99397-apiKey_01_enable_api.png)
You can find the Picker API by searching the Google API Library, or by clicking here.
- After you enable the API, you’ll be take to the list of valid credentials for the Picker API.
![apiKey_02_create_credentials.png 1035](https://files.readme.io/69dceeb-apiKey_02_create_credentials.png)
Click the + Create Credentials button, and select API key
- Google will generate a new key for you to copy.
![apiKey_03_copy_key.png 522](https://files.readme.io/f8276b8-apiKey_03_copy_key.png)
Set this value as the GSHEETS_API_KEY
in your Polytomic environment.
-
We recommend you place restrictions on this key in order to avoid abuse.
Click Restrict Key to configure restrictions.
![apiKey_04_restrict_key.png 1490](https://files.readme.io/b1b7556-apiKey_04_restrict_key.png)
You can restrict the key based on HTTP referrer, enabled APIs, or both.
Updated about 3 years ago