Python Gspread Tutorial + How To Use the Google Sheets API with Python

In this video I'm going to giving a brief tutorial on how to set up the google sheets and google drive APIs for Python with on the google developers website. I'll also cover some basic functionality with Gspread and how you can use the Gspread package to send and retrieve date to and from a google spreadsheet. Let me know if you have any questions or need anything cleared up.

Please Like, Subscribe, and Comment if you enjoyed this video and would like to follow along on my Dividend Investing journey in 2021 and beyond. It helps other people see this content and it helps my channel grow. I really appreciate all the support. Thanks!

A little bit about myself: My name is Frank Mularcik and I'm a first year student studying computer engineering. I found a passion for investing when I turned 18 (I'm currently 19) so I created this YouTube channel to document my journey of investing, tracking those investments, and learning more and more about computer science along the way.

Feel free to reach out or ask any questions in the comments, through email, or on Twitter or Instagram as listed below.

Books I enjoy/recommend (I earn a small commission on qualifying purchases) :

Disclaimer: I am not a financial advisor; this video is for entertainment and educational purposes only. Please do your own research and consult a professional before making any investment decisions. Some of the links in the description are affiliate links meaning I may receive some financial compensation if you click them.

TIMESTAMPS:
00:00 Intro
01:03 Set Up Google Sheets API
04:45 Python Script Basics
10:19 Google API Limits
12:51 Summary

[pedrooyama]

Perfect video, mate! Straight to the point and very easy to follow.

[jirapatpanyachaoren]

Thanks Frank. This video helps me a lot.

[suhasrao]

thanks for the updated info, got confused with other outdated videos. Love the time.sleep option.

[KeepTheChange]

Great video Frank, I liked the music throughout that was a nice touch!

[HiddenFreedom]

Great job Frank. Way better than I can explain. Next step, create a key and run an Apps script from Python that does something to your sheet. This one was a pain. Plus the darn token expires every 7 days and blows up the script.

[Shred]

Thank you so much! I was really stuck but this was amazing

[Fasyle]

Thanks for the upload, great walk thru.

[akmclemore]

Nice tutorial bro! I've been trying to use google sheets more lately for my budgets

[AntonioInvests]

Nice tutorial Frank, I love the flexibility with the API 😁

[spyderkavin]

Nice tutorial. really helped my project

[siddharthaveluvolu]

Great job! Most of the videos on this topic were relatively old and their tutorials are not consistent with the updated google console UI.

[DapperDividends]

This is really good stuff Frank. Have you created a dividend tracking sheet yet? Much of this is beyond my field of comprehension, but nicely done.

And I agree.... nice touch with the music!

[ryanjames]

Wow I needed this tutorial, thanks! I'm looking a lot into KO decently, do you like KO more than PEP?

[LaurenceParkin]

Hi Frank,
'from oauth2client.service_account' keeps returning an error, saying "No module named 'oauth2client'
Could you help me resolve this error?

[ryanjames]

Hey frank I’m looking more into the energy sector lately and was wondering what you thought was the best play in that industry at these prices? Ive been looking into CVX and XOM .

[miguelhumbertogonzalezzamo]

Hi Frank, it is possible to find partial text of a cell? i see there is the method .find or .findall, and those find the exact word of the cell, for example find the word "university" if the cell has the word university, however can't find "univer". there is a way to find just a partial text into the cell with gspread or other library? Thanks

[kanishmalviya]

Is it possible to update gsheet via g sheet api using API key or OAuth instead of using service account ?

[MegaLokopo]

Any reason why you don't just copy all of the data into your script once, and then only use google sheets for periodic backups?

[jamieparry]

to avoid the quota thing just get the data from the sheet in one hit and then find the length of that data dictionary
like this


data=sheet.get_all_records()

sheet.update_cell(next_edit_row_available, 1, "goodbye frank")

this only does ONE request to the api and the where to put your next addition is worked out on that get_all_records() object you have on your computer now!
this will save on the time.sleep() thing and make it all go quicker for you
i just did it on a sheet with 220 rows so i know that it works as of sept 2021!
cheers
j

[opensourcesabout]

Can I use this package into kivy apps and build Android apk?