𝗦𝗲𝘁𝘂𝗽 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗹𝗼𝘂𝗱 𝗖𝗿𝗲𝗱𝗲𝗻𝘁𝗶𝗮𝗹𝘀 𝗢𝗔𝘂𝘁𝗵 𝟮.𝟬 𝗶𝗻 𝗼𝗿𝗱𝗲𝗿 𝘁𝗼 𝗮𝗰𝗰𝗲𝘀𝘀 𝗚𝗼𝗼𝗴𝗹𝗲 𝗦𝗵𝗲𝗲𝘁𝘀 𝗔𝗣𝗜𝘀 - 𝗣𝗮𝗿𝘁 𝟭
HTML-код
- Опубликовано: 22 авг 2024
- 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 console.cloud....
** 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)
developers.goo...
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)
developers.goo...
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 (www.youtube.co...)
======================================================
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 R...
Extent Report
********************************************************************
• 𝗥𝗲𝘀𝘁 𝗔𝗣𝗜 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝘂𝘀...
Builder Pattern
********************************************************************
• 𝗛𝗼𝘄 𝘁𝗼 𝘂𝘀𝗲 𝗕𝘂𝗶𝗹𝗱𝗲𝗿 𝗣𝗮𝘁...
GIT Repository: github.com/sac...
Facebook Group: / 2281575021954417
LinkedIn Group: / 10311201
Telegram Group: t.me/joinchat/...
Nice video
Very clear and nice presentation skill
good old indian guy tutorials :) thanks!
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?
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.
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?
Thanks a lot!
Hi sir
How can we get refresh token and access token using postman, kindly help me
can u make for google assistant
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.
Any posiblity to do it on android studio
why my drive auth is in restricted page?