Python Google Sheets API Tutorial - 2019

This tutorial shows you how to use Google Sheets with Python. Google Sheets is a very simple, lightweight and easy to use alternative to a database in python. It is completely free and great for small hobby projects.

SCOPE:

◾◾◾◾◾
💻 Enroll in The Fundamentals of Programming w/ Python

◾◾◾◾◾◾

⚡ Please leave a LIKE and SUBSCRIBE for more content! ⚡

Tags:
- Tech With Tim
- Pygame
- Python Tutorials
- Google sheets api tutorial
- Google sheets
- Google sheets python

[Sckhar]

If Google doesn't download the JSON file automatically, go to API and Servides - Service Accounts and click Manage Service Accounts. Go to Actions - Manage Keys - ADD KEY - Create new Key and choose Json. Took me some time to find it hehe

[kapilchhabria]

4am on a Tuesday Morning and this dude just helped me eliminate 20 minutes of daily tasks. Awesome stuff!

[Swonke]

This video was way over my head when I first watched it. Then, after trying to make sense of Google's mind numbing documentation, reviewing this video is a breathe of fresh air. Finally making progress!

[erenhan]

after several annoying api errors, access denied errors, 1 hour StackOverflow, finally got it with your video, thank you so much

[raghavendraviswanath]

This video is just made perfect. In 12 mins Tim covers everything that is required. I was struggling with few pieces of code for more than a day and this video came as a perfect help. Thanks a ton Tim

[robopandax]

THANK YOU MY GUY. I have spent almost 4 hrs. Smashing my head into my desk. With authorization errors. I've watched three entire vids on this. But thank god urs worked and u deserve a like and sub.

[OconoorFR]

For anyone having a "No Access Token in Response" after trying to open a sheet,
+remove the second scope (sprea...) entirely
+add "drive.file" at the end of the 3rd, worked for me

[HostDotPromo]

This is gonna be super helpful for my project, thank you dude.

[Loppy]

This is a hundred times better than Google's own documentation.

[mightye]

i love you bro. best tech youtuber hands down. anytime i need tutorial i look for tim <3

[imretuvi]

I was struggling getting OAuth 2.0 Client IDs for authentication working. Your video gave me work-around and I can now use it properly but it is using Service Accounts instead. Looking through your code I figured out why I couldn't authenticate. Now I got both working. Thanks, I mean really thanks, Tim! Back to the project ...

[andtarov]

I'm from Russia and my English not well. I tried to read documentation, but didn't understand it. But your video help me to understand everything what i wanna get to know. Thank you (Спасибо)

[iamakifislam]

In 5:30, if you copy from description, it will not copy the whole address. Here is the full address. I am writing it with spaces to avoid auto short from google. Please remove all the spaces between this whole list/strings/address.

scope = [" https ://spread sheets.google. com/feeds",
'https: //www.googleapis. com/ auth/spreadsheets'
, "https:// www.googleapis. com/ auth/drive.file"
, "https:// www.googleapis. com /auth/ drive" ]

[CadenDavidson]

This is incredibly helpful, you covered every method I needed to know how to use. Thanks!

[fernandogurgel]

That is great. I was able to follow thru and make it run! I am working in a report automation project and now I have the background information to generate google slides from google sheets data. Thanks a lot.

[felixbrauliovieracastello]

Hola Tim realmente valoro mucho tus videos, eres un excelente profesor, una persona muy joven que tiene un gran conocimiento y el don de llegar facilmente a la gente, siendo directo conciso y sobre todo sencillo, muchos exitos y bendiciones en tu vida Tim, un abrazo.

[sameershinde]

Usually I don't comment to videos but this one is really nice Thank you man..!!

[crazyminecrafter]

You teach better than my university professor

[Oriactim]

Nice tutorial, I appreciate that you show an easy way to handle Google Sheets API for Python. Even the official documentation is obsolete and hard to follow.

[VirtualCrickets]

For anyone who didn't get the json file to automatically download, just go to Keys -> Add Key -> Create new key -> JSON