Google Sheets Connector

Google Sheets Connector

Administration of Google Sheets Connector

Administration of Google Sheets Connector

Before you use Google Sheets Connector, you must complete the following prerequisite tasks:
  1. Create a Google account to access Google Sheets.
  2. On the
    Dashboards
    page of the Google API Console, https://console.developers.google.com/, enable the
    Google Sheets API
    for your project. Google Sheets Connector uses the Google APIs to integrate with Google Sheets.
    The following image shows the
    Dashboard
    page where you can enable the APIs:
    The image shows the Dashboard page where you can enable the Google APIs.
  3. On the
    Credentials
    page of the Google API console, click on
    Create Credentials
    OAuth client ID
    .
    The following image shows the
    Credentials
    page where you can create the credentials for your project:
    The image shows the Credentials page where you can create a service account and obtain a service account key.
  4. Fill the form on the
    OAuth consent screen
    tab.
  5. Click
    Save
    .
  6. Select
    Application type
    as
    Other
    .
  7. Enter the
    Name
    .
  8. Click
    Create
    .
    The Client ID and Client Secret appears on the screen. Copy the Client ID and Client secret values.
  9. In the OAuth 2.0 Client IDs section, download the JSON file corresponding to your OAuth client ID that contains the client_id, project_id, auth_uri, token_uri, auth_provider_x509_cert_url, client_secret, and redirect_uris values.
  10. Generate the OAuthu 2.0 access tokens. You will need to enter these details when you create a Google Sheets connection in
    Data Integration
    .
    For more information on generating the OAuth 2.0 access tokens, click the following URL: https://developers.google.com/identity/protocols/OAuth2WebServer#obtainingaccesstokens