𝗦𝗲𝘁𝘂𝗽 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗹𝗼𝘂𝗱 𝗖𝗿𝗲𝗱𝗲𝗻𝘁𝗶𝗮𝗹𝘀 𝗢𝗔𝘂𝘁𝗵 𝟮.𝟬 𝗶𝗻 𝗼𝗿𝗱𝗲𝗿 𝘁𝗼 𝗮𝗰𝗰𝗲𝘀𝘀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗦𝗵𝗲𝗲𝘁𝘀 𝗔𝗣𝗜𝘀 - 𝗣𝗮𝗿𝘁 𝟭

Описание: 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...