Use Python To Import Data to Google Sheets

Hey folks - in this video i'll show you how can import data to your Google Sheets using an API with Python. There's three examples to go through to give you a better understanding and you can also check out the code snippet below :)

00:00 Intro
01:00 Google Credentials Setup
10:10 Read Text File and Import to Sheets
12:30 Fetch API Data and Import to Sheets
14:20 Wrapping Up

#python #googlesheets #api

[garydunken]

Hi Mate, This video helped me today, thank you.
I needed to transfer data from CSV files to GoogleSheets. Initially I struggled to understand Google authentication method, but later with few repeated views and attempts, I got the code to work. Awesome job man.

[TimurBalt]

Tnahk you, Daniel! Simple and clear. Helped me a lot!

[ZZAudio]

Great tutorial! Simple and easy to understand.

[sreeshaiyer]

How did you configure your consent screen? I'm stuck at that point.

[alexandr]

Hello! I am following your guide step by step and faced into Error 403: access_denied. I am chosing the Google account through which I've created the new Google Sheets file. Whould you advise something to have it fixed? Thanks in advance!

[siddharthchimahiti]

What to do if we want to input data using our terminal that should be writeen in sheets

[kuppacoffee]

I get an error saying access blocked: "name" has not completed the google verification process. I get the option to select an account to login with but that's as far as it goes.

[kylelyon]

What should you do when the token expires?