Python Google Sheets API Tutorial – 2019

///Python Google Sheets API Tutorial – 2019

Python Google Sheets API Tutorial – 2019

FavoriteLoadingAdd to favorites

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:
scope = [”

Source Code:

**************************************************************
WEBSITE:

One-Time Donations:

Support the Channel:

Podcast:

Twitter:

Join my discord server:
**************************************************************

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

source

By |2020-02-02T01:35:39+00:00February 2nd, 2020|Python Video Tutorials|42 Comments

42 Comments

  1. Daniel Levkovitz February 2, 2020 at 1:35 am - Reply

    Thank you very much for the tutorial! it helped a lot!
    One question: I'm currently trying to use gspread in my Google App Engine project using python 2.7.
    I found it challenging to import the module so it will run with GAE.
    Once I've managed to import the required libs localy in the project's folder it seems that it is not well suited to work with python 2.7.
    Any tips on how to make all the components to work together?

    Thanks again

  2. Yago Alves February 2, 2020 at 1:35 am - Reply

    Great tutorial man ! Saved much of my time

  3. Jonathan Edwards February 2, 2020 at 1:35 am - Reply

    This is WAY better than trying to follow the Google documentation. You are a Super Star Tim!

  4. Annette Hoiseter February 2, 2020 at 1:35 am - Reply

    hi! im having trouble reading from any but sheet1. If i ad another sheet and call for sheet2 it says the spreadsheet has no such attribute. Anyone else come accross this problem?

  5. Sandhya Betancourt February 2, 2020 at 1:35 am - Reply

    scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"%5D
    Is it intentional not to double " " on each scope? Does the quotation format matters? I noticed on the second scope.'

  6. Amanda Alves February 2, 2020 at 1:35 am - Reply

    In 3:48 I've got an error: Delivery Status Notification (Failure)

  7. Akshansh Shrivastava February 2, 2020 at 1:35 am - Reply

    how can I create a new sheet using api and without manually going to google sheet and creating a file

  8. Jonah Stricklin February 2, 2020 at 1:35 am - Reply

    if any of you are having trouble accessing the .json file, and getting the error "FileNotFoundError: [Errno 2] No such file or directory: 'creds.json'", enter in the full directory, not just the name. So instead of "creds.json", I put "D:\documents\Python Projects\av\creds.json".

  9. Jonah Stricklin February 2, 2020 at 1:35 am - Reply

    Great video, thanks!

  10. Fernando Chebair February 2, 2020 at 1:35 am - Reply

    There are some problems with the quotes inside of the scope.

    How come your program runs with these missing quotes?

  11. Denny Harijanto February 2, 2020 at 1:35 am - Reply

    Really helpful, thanks a bunch for sharing! 🙂

  12. aUser February 2, 2020 at 1:35 am - Reply

    The links in the scope don't work for me… I can't open them in the browser and python gives me the following error :
    "invalid_scope: https://spreadsheets.google.com/feeds is not a valid audience string." (VS Code)
    I would really appreciate any help but nice video anyway ; )

  13. Aleks P February 2, 2020 at 1:35 am - Reply

    отличный урок. а есть видео как взаимодействовать подобным образом с хмл файлами на гугл диске?

  14. MrNeurocide February 2, 2020 at 1:35 am - Reply

    Thank you Tim. Video you made, help me a lot.

  15. Vincent Cheung February 2, 2020 at 1:35 am - Reply

    Excellent content as always. Thank you, Tim.

  16. Peter Rosenberg February 2, 2020 at 1:35 am - Reply

    EOL while scanning string literal on the scope

  17. lin kevin February 2, 2020 at 1:35 am - Reply

    Hello Tim, I have some problem for your vedio, i want to post the data(crawler), l already to crawerler the data but i do not know how to post on google sheets can you tell me how to do that ????

  18. Ritchie February 2, 2020 at 1:35 am - Reply

    Awesome man, python seems way easier than Node JS ? I know javascript, trying to figure out the best way to access a google sheets from a chrome extension ? Looks like this might be something to look into .

  19. RoboPandaX February 2, 2020 at 1:35 am - Reply

    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.

  20. Philippe Caron-Boutin February 2, 2020 at 1:35 am - Reply

    Hello Tim, it is possible the module name change from oauth2client to google.oauth2 ? with the function Credential?

  21. Eli Simic February 2, 2020 at 1:35 am - Reply

    Notice: oath2client is now deprecated. Now use https://google-auth.readthedocs.io/en/latest/user-guide.html

  22. Sloth YouTube February 2, 2020 at 1:35 am - Reply

    Thank you very much for the super helpful tutorial!

  23. Adept Creative February 2, 2020 at 1:35 am - Reply

    Mad props! This was very helpful!

  24. Thyme February 2, 2020 at 1:35 am - Reply

    Just a head up, incase your pyCharm might not have some interpreters installed.
    Follow the steps below:
    – Open "Preferences"
    – Select "Project: coding"
    – Then "Project Interpreter"
    – Click on the "+" at the bottom
    – look for "gspread" and "oauth2client" then install each of them
    Now your "import" should be happy

  25. Вадим Парницький February 2, 2020 at 1:35 am - Reply

    You helped me very well. Thanks!

  26. Adam S February 2, 2020 at 1:35 am - Reply

    This was super-useful. Thanks!

  27. Hanzala Khan February 2, 2020 at 1:35 am - Reply

    Can I use it for IoT. I think that it is slower , is there any alternative for making database using python.

  28. Alberto Cartagena February 2, 2020 at 1:35 am - Reply

    addRow() doesn't work with my code but appendRow() works! :D, very helpful Thanks!

  29. John C. Ardussi February 2, 2020 at 1:35 am - Reply

    I am planning on releasing an app that accesses a users sheet. How much of the API and credential work will I have to get the end user to do? I am concerned this will become a support nightmare if it is too techy for regular people.

  30. Rafal B February 2, 2020 at 1:35 am - Reply

    thanks, very helpful 😀

  31. нуриддин юлдашев February 2, 2020 at 1:35 am - Reply

    thanks bro

  32. Niels Ryserhove February 2, 2020 at 1:35 am - Reply

    Do you know how to merge cells?

  33. Dileep XDN February 2, 2020 at 1:35 am - Reply

    Is there any limits like the number of requests and bandwidth usage ?

  34. Андрей Тароватов February 2, 2020 at 1:35 am - Reply

    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 (Спасибо)

  35. Michele Bastione February 2, 2020 at 1:35 am - Reply

    If I can make this to work, it'll save my lazy ass. Thanks a lot!

  36. Spardington February 2, 2020 at 1:35 am - Reply

    Exact same issue….. @BuFFalo BaBa

    "..no module named gspread.."

    Traceback (most recent call last):

    File "C:/Users/**********/Desktop/sheets.py", line 1, in <module>

    import gspread

    ModuleNotFoundError: No module named 'gspread'

    Process finished with exit code 1

  37. BuFFalo BaBa February 2, 2020 at 1:35 am - Reply

    after pip install gspread oauth2client
    i can't import gspread

    "..no module named gspread.."

  38. Fernando Gurgel February 2, 2020 at 1:35 am - Reply

    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.

  39. agatha helena February 2, 2020 at 1:35 am - Reply

    omg is real i got $26,000 paypal hack from vastrangelinks,com

  40. John Tolkien February 2, 2020 at 1:35 am - Reply

    Tim – well done – many thanks for your clear instructions !!

  41. SATSifaction February 2, 2020 at 1:35 am - Reply

    Thanks for the tutorial.

  42. skeeveskeeve February 2, 2020 at 1:35 am - Reply

    very helpful, thank you for posting.

Leave A Comment

*