Google Sheets Connector

A quick and simple way to make spreadsheets that also has plenty of integration. Google sheets may be a low hanging option to getting data into Perceptif.

📘 Instructions

There are two viable of Authentication credentials, OAuth and a Service Account Key

1. To get the OAuth credentials

   1. In Google Cloud Console navigate to APIs and Services → Credentials

   2. Under Credentials there is a category called OAuth 2.0 Client IDs

   3. Click “Create Credentials” a button at the top of the page

   4. Create a new OAuth 2.0 Client ID

      1. No additional details are needed besides the name

   5. Copy and paste the Client ID and Secret

2. Refresh token

   1. Add in Redirect URIs for your OAuth credential

   2. Open OAuth 2.0 Playground

   3. Click on gear -> OAuth 2.0 configuration, options must be set to:

      1. Force prompt -> Select Account Screen

      2. Access Type -> Offline

      3. Check - > Use your own OAuth credentials

      4. OAuth Client ID - from Google Cloud Console

      5. OAuth Client secret - from Google Cloud Console

   4. On Step 1 select “Google Sheets API v4” and necessary scopes -> Click Authorize APIs

   5. Choose acсount in prompt

   6. On Step 2 click -> Exchange authorization code for tokens

   7. Refresh token will appear

      1. Make sure to save the token somewhere

Both methods should work equally as well

2. To get your service account key its a similar process to the BigQuery Connector

   1. In Google Cloud Console navigate to APIs and Services → Credentials

   2. Under Credentials there is a category called Service Accounts

   3. Click “Create Credentials” a button at the top of the page

   4. Click Service Account

   5. Enter the service account details

   6. Give the Project Viewer Role OR Share the Spreadsheet with the Service Account

   7. When the Service account is created, open the service account

   8. Go to the keys page

   9. Click add key

      1. select JSON

   10. The JSON file should automatically download

   11. Open the JSON file and copy all of the text

   12. Paste the text into the Service account key field

https://developers.google.com/identity/protocols/oauth2