Google Sheets API with Python requests library (OAuth 2.0)

Показать описание

This video details how to access/connect a Google service such as Google Sheets to your Python script. Specifically it deals with updating a group of cells in Google Sheets. The code itself can be accessed below and hopefully it is detailed enough to be read on your own. If it isn't let me know!

Link to script:

Timestamps:
0:00 Intro
0:31 Demonstrating Google Sheets update from Python script
2:00 How to connect Google Sheets API
2:15 Step 1: Go to Google Cloud Platform (GCP)
3:31 Step 2: Configure consent screen
4:39 Step 3: Create credentials
5:11 Step 4: Copy client ID and secret to the Python script
5:50 Step 5: Open the link
6:52 Step 6: Add access code to script
7:09 Step 7: Add refresh token to other script
7:25 Step 8: Create the Google Sheet and add the spreadsheet ID
7:52 Step 9: Enable Google Sheets API in GCP

David Sha

Рекомендации по теме

Комментарии

this is the one of the best video ever, no one in the youtube who explain each and every thing in detail, I facing this error 15-16 day thank you bro

bloggingplaza

Thank you for making this video! Simple and easy to follow!

fromtaiwan

I do not get a refresh token in the terminal's result. I get an access token but no refreshtoken.

OlanrewajuSanni-fm

Google Sheets API with Python requests library (OAuth 2.0)

Automate Google Sheets With Python - Google Sheets API Tutorial

How to use the Google Sheets API in Python

Google Sheets API Automation in Python

Python Google Sheets API Tutorial - 2019

Google Sheets - Python API, Read & Write Data

Работаем с Google Sheets API на Python

Google Sheets API in Python | Getting Started

Google Sheets and Python - Tutorial

How to Use Python with Google Sheets (Easy Guide)

Google Sheets API Quickstart with Python

Google Sheets API in Python | Append Rows and Columns

Google Sheets API in Python | Export Google Sheets Data to Excel

Google Sheets API in Python: Create a Service Instance

How to Use Google Sheets With Python

Python, Google Sheets API Tutorial | Read and Write Data | Aryan Irani

Google Sheets API with Python requests library (OAuth 2.0)

Google Sheets API in Python | Add and Delete Worksheets

Google Sheets Python Tutorial | Read & Write With Google Sheets API

Google Sheets… Your Next Database?

Part 5 - Python + Google Sheet API (To Integrate with Flask)

Use Python To Import Data to Google Sheets

Update Google Sheets Using A Service Account With Google Sheets API In Python 🐍

Python Import / Read In Google Spreadsheet Using Pandas. Open a Google sheets document in python.

Google Sheets API in Python | Insert Rows and Columns