๐ฆ๐ฒ๐๐๐ฝ ๐๐ผ๐ผ๐ด๐น๐ฒ ๐๐น๐ผ๐๐ฑ ๐๐ฟ๐ฒ๐ฑ๐ฒ๐ป๐๐ถ๐ฎ๐น๐ ๐ข๐๐๐๐ต ๐ฎ.๐ฌ ๐ถ๐ป ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ ๐๐ผ ๐ฎ๐ฐ๐ฐ๐ฒ๐๐ ๐๐ผ๐ผ๐ด๐น๐ฒ ๐ฆ๐ต๐ฒ๐ฒ๐๐ ๐๐ฃ๐๐ - ๐ฃ๐ฎ๐ฟ๐ ๐ญ
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 https://console.cloud.google.com/
** 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)
https://developers.google.com/sheets/...
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)
https://developers.google.com/sheets/...
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 (https://www.youtube.com/SachinGuptaIT...)
======================================================
ChatGPT Tutorial Series
********************************************************************
ย ย ย โขย ChatGPTย ย
POSTMAN Tutorial Series
********************************************************************
ย ย ย โขย POSTMANย TUTORIALย ย
API Security Testing with Pynt in existing Postman Collections
********************************************************************
ย ย ย โขย Pyntย ย
Selenium 4 Features
********************************************************************
ย ย ย โขย Seleniumย 4ย Featureย ย
API Testing using by Rest-assured library
********************************************************************
ย ย ย โขย APIย Testingย usingย byย Restย Assuredย Libraryย ย
Extent Report
********************************************************************
ย ย ย โขย ๐ฅ๐ฒ๐๐ย ๐๐ฃ๐ย ๐๐๐๐ผ๐บ๐ฎ๐๐ถ๐ผ๐ปย ๐๐๐ถ๐ป๐ดย ๐ฏ๐ย ๐ฅ๐ฒ๐๐-๐๐๐๐๐ฟ๐ฒ๐ฑย ...ย ย
Builder Pattern
********************************************************************
ย ย ย โขย ๐๐ผ๐ย ๐๐ผย ๐๐๐ฒย ๐๐๐ถ๐น๐ฑ๐ฒ๐ฟย ๐ฃ๐ฎ๐๐๐ฒ๐ฟ๐ป?ย ย
GIT Repository: https://github.com/sachinguptait/
Facebook Group: ย ย /ย 2281575021954417ย ย
LinkedIn Group: ย ย /ย 10311201ย ย
Telegram Group: https://t.me/joinchat/ONh25RUYqfBjsCt...