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

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:
** 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)

Range: SheetName(that will allow whole sheet access) OR A1:G10

======================================================
======================================================

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
********************************************************************

[KoTuK]

good old indian guy tutorials :) thanks!

[nirbhaydeeptrigunayat]

Hi Sachin
this is very helpful for me. Can you an another video
Access dada from the Google spreadsheet with the help of service account. I don't want use Oauth 2.0.

[kulvinder]

how I send data from one google sheet to another google sheet without sharing (from one google account to another google account) by this method.

[marinebocquet]

Hi, this helped me a lot except for one thing. Some context: my work asked me to make work an old external app we used for sheet modifications
By looking into the config files, I found it was using a service account for the api, I managed to set a new one up, but I'm missing something in another file called "Access token" and I just have no idea how to get that thing? Can you help?

[sweetysnehith]

Hi sir


How can we get refresh token and access token using postman, kindly help me

[agent]

Any posiblity to do it on android studio

[yusufardiansyah]

why my drive auth is in restricted page?

[siddharthsrivastava]

Hi Sachin Gupta, thanks for sharing these videos. Could you please tell if we test these api's from our personal account, will it going to charge any money?