Google Sheets and Python




About this tutorial:

Video duration: 6:53
Learn more from the blog post at

Check out the wonderful gspread library on Github:

If you have any questions, leave them in the comments or find me on Twitter at

If you’re running into insufficient permission errors, update the scope in the code to:
scope = [‘ ‘

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

33 thoughts on “Google Sheets and Python

    Twilio

    (April 20, 2019 - 1:17 am)

    If you're running into insufficient permission errors, update the scope in the code to:
    scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive'%5D

    Dan

    (April 20, 2019 - 1:17 am)

    heheh you said pp

    Jaime Rojas

    (April 20, 2019 - 1:17 am)

    I try it out and was pretty fun actually lol

    Jaime Rojas

    (April 20, 2019 - 1:17 am)

    Very interesting, I don't see an actual use for me right now but looks really fun I'd like to try it out XD

    candr

    (April 20, 2019 - 1:17 am)

    Great video. Easy to follow and very concise without being too dense. Very nice!

    André Salazar

    (April 20, 2019 - 1:17 am)

    I wonder how would this work for a relational database, can I program the keys in Python? If it can replace relational databases its a total game changer in my case

    kawthar SMAILI

    (April 20, 2019 - 1:17 am)

    Soo great Thank u 🙂

    Harsh Jaiswal

    (April 20, 2019 - 1:17 am)

    Benefit of this ? Can anyone brief me a little.

    jsakul

    (April 20, 2019 - 1:17 am)

    Amazing. I needed this …

    [MM] Survivian

    (April 20, 2019 - 1:17 am)

    I now have renewed vigor to try to learn Python again.

    Malvator

    (April 20, 2019 - 1:17 am)

    I'm doing this but with pandas. Much more easier for me.

    Trevor Cardoza

    (April 20, 2019 - 1:17 am)

    Learning to add JSON to a unity project and came across this video is there any google sheet support for unity?

    Александр Яркин

    (April 20, 2019 - 1:17 am)

    wow, its a cool!

    Kieran Martin

    (April 20, 2019 - 1:17 am)

    what was that editor you were using?

    MemeNode

    (April 20, 2019 - 1:17 am)

    Thanks, it was really useful 😀

    Kai DeDonato

    (April 20, 2019 - 1:17 am)

    Theres no chance that I'm the only one who chuckled at pp pprint. Right??

    Hi I'm Henry

    (April 20, 2019 - 1:17 am)

    OKAY YOUTUBE ILL WATCH IT, THANK YOU

    Keya Kinan

    (April 20, 2019 - 1:17 am)

    Isn't there an option to execute code inside Google Sheet itself?

    Andrew900460

    (April 20, 2019 - 1:17 am)

    Another programmer from Pennsylvania! Who woulda thought.

    Cleptuno

    (April 20, 2019 - 1:17 am)

    This has a lot of potential!

    Nova Aquarius

    (April 20, 2019 - 1:17 am)

    Why didn't I find it earlier? Just brilliant. On point. No complicacy. Clap worthy really👏👏👏👏👏👏

    magicbuskey

    (April 20, 2019 - 1:17 am)

    This is AWESOME!!! Thank you!

    QuestWalker KO

    (April 20, 2019 - 1:17 am)

    there is a python module that allows you to edit an Microsoft excel sheet

    Abraham Nelson

    (April 20, 2019 - 1:17 am)

    Eyyy a fellow Pennsylvanian

    Just a Random Gamer

    (April 20, 2019 - 1:17 am)

    I’ve got no idea what any of this means but I liked this video

    John Penguin

    (April 20, 2019 - 1:17 am)

    This works great… unless you’re in China 🤪

    Holobrine

    (April 20, 2019 - 1:17 am)

    But can you query for all instances that meet certain criteria?

    TheAnimeKid10oo Awesomeness

    (April 20, 2019 - 1:17 am)

    Google sheets is cool. Subscribe to me.

    Doodles

    (April 20, 2019 - 1:17 am)

    2 year ago I knew nothing about coding and found this video fascinating and confusing.
    Today I needed to manipulate Google Sheets via code and found yet again this amazing video, it's pretty cool to see how things change.

    Svetlana Semenova

    (April 20, 2019 - 1:17 am)

    This is life changing

    Alexandre Marcq

    (April 20, 2019 - 1:17 am)

    What if you need a permanent connection to the spreadsheet such as a bot? I need to get refresh tokens but have no idea how to…

    Lucas van Wijk

    (April 20, 2019 - 1:17 am)

    So could you get this to work on muliple devices. I am building a app for my boss and it has to work on both her work PC and her home PC. Could you pull this of with this method?

    Malcom Clark

    (April 20, 2019 - 1:17 am)

    I actually never thought about doing this even though I use google's javascript API all the time in spreadsheets.

Leave a Reply

Your email address will not be published. Required fields are marked *