Step 1:

Open this https://console.cloud.google.com/

Click on - Create a New project

Select top drop-down OR Quick Start Project And select the project

Step 2: Note- First Pinned your APIs & Services.

Click on Enabled APIs and services

Select Google Sheets API and Enable it.

Step 3:

Create Credentials

Click on OAuth Client ID

Click on - OAuth consent screen ( App name should be the same as the Project name else you will get an error)

Add Scope - Select './auth/spreadsheets' - this will give all the permission

And select './auth/drive'

Step 4:

Create Credentials - Application type as Web app

Give any name(Google Sheet API) ---- Download OAuth client JSON file.

Step 5:

Create one Google Sheet- Save that google sheet - copy Link of Google sheet

Step 6:

Sheet data can be accessed via the below link (Go to the 'spreadSheet.values'

section and select 'get' API)

https://developers.google.com/sheets/api/reference/rest

Note: click on Try this Method you will know about your access token

Range: Sheet-name (that will allow whole sheet access) OR A2:C2.