๐ฆ๐ฒ๐๐๐ฝ ๐๐ผ๐ผ๐ด๐น๐ฒ ๐๐น๐ผ๐๐ฑ ๐๐ฟ๐ฒ๐ฑ๐ฒ๐ป๐๐ถ๐ฎ๐น๐ ๐ข๐๐๐๐ต ๐ฎ.๐ฌ ๐ถ๐ป ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ ๐๐ผ ๐ฎ๐ฐ๐ฐ๐ฒ๐๐ ๐๐ผ๐ผ๐ด๐น๐ฒ ๐ฆ๐ต๐ฒ๐ฒ๐๐ ๐๐ฃ๐๐
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.
