How to Use Google Sheets in Python

This video demonstrates how to use Python to interact with Google Sheets as an alternative to using a database.

WORK WITH ME👇🏼

✅ Implement features and fix bugs in your app: Live, one-on-one screenshare

💻 Code written in video

[meksaldi]

Well, googling about all technical stuff didn't bring a solution. However, a 15 min. video contains more info than the Google developer site itself. Well done.

[kenocontreras]

First of all, thank you for your video.
Guys, if some of you get an error about "invalid_scope: Empty or missing scope not allowed"
I fixed doing this:

credentials =
credentials =
gc =

[stillinmusic]

I was banging my head against the wall when reading google developer site. Thank you so much for saving my head.

[dlepro]

Dude, thank you very much. I was struggling with the incomplete documentation from google and after hours I find a brilliant 15 min solution.

[TheTeachinggeek]

Thank you so much! I am a teacher using python in my classroom. Not an expert by any means, but what a boon this skill is now. I have watched a few videos on the topic, but your video gave me the 'aha!' Thank you thank you thank you!

[SilvianDragan]

This is a fantastic video. Literally the template I go to when I need to get started on gsheets manipulation using python.

[larsjohansson]

I do not know python, I just followed the video and it worked, easy peasy. Good tutorial.

[yuvigerstein]

I'm kind of new to python and to Google APIs, and your tutorial actually worked for me. Awesome work! thank you sir!

[devve]

Excellent explanation, clear, direct, complete. Congratulations, good work !! Regards.

[eliz]

Thanks much! I googled around and read so many documents that didn't really help. Your video is exactly what I need!

[hfrnd-hukz]

Dude, you are awesome. Clear and concise, can't ask for anything more.

[UkiDLucas]

Thank you, I was missing the copy the email and share my own spreadsheet part till now!

[quaternion-pi]

Excellent! Looking forward to additional videos on using Python with Google Sheets.

[isaaccoltrain]

This was a fantastic tutorial. Please keep making great content like this. Looking forward to checkout out the rest of your channel.

[AestheticVodka]

Excellent tutorial, still relevant and super helpful several months down the line, all the best!

[s_p_a_c_e_m_a_n]

Awesome video, been trying to figure this out via Goolgle QuickStart and failed, your fixed that! THANK YOU!

[sharvilpopli]

very precise, thanks! using gspread for raspberry pi data logging

[jaypod]

That's awesome. Thank you so much! It worked. I'm trying to figure out the Google APIs though. Hopefully I'll be able to figure out how to use them instead of the gspread library.

[SolidBuildersInc]

Awesome solution. This may be the issue with some other problems I am having with Google Credentials that have been deprecated. Are you still going to provide some examples of this gspread library and the popular Query() Function? This is got me on the edge of my seat.

[yendys]

cant thank you enough, this super helpful