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:
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:
Fill the form on the
OAuth consent screen
tab.
Click
Save
.
Select
Application type
as
Other
.
Enter the
Name
.
Click
Create
.
The Client ID and Client Secret appears on the screen. Copy the Client ID and Client secret values.
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 OAuthu 2.0 access tokens. You will need to enter these details when you create a Google Sheets connection in