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

Source Code:

⭐ Kite is a free AI-powered coding assistant for Python that will help you code smarter and faster. Integrates with Atom, PyCharm, VS Code, Sublime, Vim, and Spyder. I’ve been using Kite for 6 months and I love it!

💻 Enroll in The Fundamentals of Programming w/ Python

📸 Instagram:
🌎 Website
📱 Twitter:
⭐ Discord:
📝 LinkedIn:
📂 GitHub:
🔊 Podcast:

💵 One-Time Donations:
💰 Patreon:

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

– Tech With Tim
– Pygame
– Python Tutorials
– Google sheets api tutorial
– Google sheets
– Google sheets python


36 thoughts on “Python Google Sheets API Tutorial – 2019”
  1. If the code gives you this error on vs code:

    FileNotFoundError: [Errno 2] No such file or directory: 'creds.json'

    Just change:

    creds = ServiceAccountCredentials.from_json_keyfile_name('creds.json', scope)


    creds = ServiceAccountCredentials.from_json_keyfile_name('*copy and paste the relate path*, scope)

  2. Great video! Is it possible to trigger a python script on linux VM on cloud by cell value change on google sheets?! for instance if A1 in sheet1 is not blank run the python script… I wrote a code to trace the cell but there are some limitations for executing the scripts/minute/user &… I need google sheets to trigger my python script. Thanks for your advice in advance.

  3. 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

  4. Hey there! Thanks! You nicely explained the techniques. Even though i am not familiar with any coding or programming languages, i used coding language for integration. But it makes me feel a bit confused, so i was looking for some automated API tools to integrate my google sheet so i could collect data from my websites automatically. although , most of the API tools dissatisfied me. After a few months, i found another API tool, call sheet dot best , which is easy to integrate and secure that makes my data clark work so easy. I think you can also try this out if needed, it might help you. What do you think of the API platform?

  5. Hey Tim

    This video helped clear things up so much I appreciate it. One question though, when I run the python file I get back an error that says refresherror: no access token in reponse, followed by a combination of numbers and letters. Anyway of knowing how to fix that?

  6. I love how Google documentation doesn't match Google's own platform, which leads Google's users to Google's Youtube to watch a video that made by a helpful individual, but the video shows a process that is now outdated… Meanwhile at Google… $$$$$$$$$$$$$$$$$$$$$

  7. hello, my spreedsheet contains multiple fields with headers, my client want me to pull all data without touching or changing all data from spreedsheet. is theres any way to do this job done? it is a messy spreedsheet to be exact

Leave a Reply

Your email address will not be published.

Captcha loading...