Let's learn, how to access Google APIs i.e Google Sheets, Gmail, Drive, etc
#googlesheets #googleapi #googleauthenticator #googlecloudcredentialsetup #OAuth2ClientIDs #googleServiceAccount
*****************Access Google Sheet API via OAuth Client ID*********************
Step 1:
Open this [ Ссылка ]
** Create a new project ----} Select top drop-down OR Quick Start Project
And select the project
Step 2:
** Enabled APIs and services
----} Select Google Sheets and Enable it
Step 3:
** Create Credentials ----} OAuth Client ID ----} OAuth consent screen ----} App name should be the same as the Project name else you will get an error
** Scope
----} Select './auth/spreadsheets' - this will give all the permission
----} And select './auth/drive'
Step 4:
----} Credentials ----} Application type as Web app ----} Give any name(Google Sheet API) ----} Download OAuth client JSON file
Step 5:
Follow this document: (Quick start project)
[ Ссылка ]
Step 6:
Create the new sheet and follow Step 5 (Google Sheet APIs)
Sheet data can be accessed via the below link (Go to the 'spreadSheet.values' section and select 'get' API)
[ Ссылка ]
Range: SheetName(that will allow whole sheet access) OR A1:G10
======================================================
Please watch previous tutorials, in case you have missed them, and subscribe to this channel ([ Ссылка ])
======================================================
ChatGPT Tutorial Series
********************************************************************
[ Ссылка ]
POSTMAN Tutorial Series
********************************************************************
[ Ссылка ]
API Security Testing with Pynt in existing Postman Collections
********************************************************************
[ Ссылка ]
Selenium 4 Features
********************************************************************
[ Ссылка ]
API Testing using by Rest-assured library
********************************************************************
[ Ссылка ]
Extent Report
********************************************************************
[ Ссылка ]
Builder Pattern
********************************************************************
[ Ссылка ]
GIT Repository: [ Ссылка ]
Facebook Group: [ Ссылка ]
LinkedIn Group: [ Ссылка ]
Telegram Group: [ Ссылка ]
![](https://i.ytimg.com/vi/EUDua8s3eQA/maxresdefault.jpg)