Create a Google account to access Google Sheets.

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.

On the

Credentials

page of the Google API console, click on

Create Credentials

OAuth client ID

.

Fill the form on the

OAuth consent screen

tab.

Click

Save

.

Select

Application type

as

Other

.

Enter the

Name

.

Click

Create

.

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.

Generate the OAuth 2.0 access tokens. You will need to enter these details when you create a Google Sheets connection in

Data Integration

.