Using Google Sheets with Python (COMPLETE Beginner GSpread Tutorial!)

Learn how to use Google Sheets with Python, even if you've never used GSpread before. This is the complete tutorial (a combination of multiple part) designed for beginners to get started on an easy database option without the hassle of setting up complicated frameworks.

This tutorial is a combination of three parts. If you'd rather go part by part, head over to the GSpread playlist on my channel for shorter, individual videos tackling one concept at a time.

Time Stamps
0:00 Intro
0:44 Create spreadsheet
1:25 Enable Google Drive & Sheets API
3:06 Creating a Service Account
5:20 Using Python to Modify Spreadsheet
5:40 Installing GSpread and Writing Code to Authenticate
8:14 Filling Spreadsheet
9:55 Code Run with Error
11:10 Code Run without Error
11:17 Talk about GSpread’s functionality
11:49 Ways to Open a Spreadsheet
13:30 Getting values
15:05 Getting values by row
15:53 Conclusion
_________________
ABOUT ME


#themillibittutorials #python #gspread #beginners #database #pythonlibrary #googlesheetsapi #googledriveapi #learntocode

[StopLossLOL]

Thank you very much. I learned a lot from this video! The keyboard in this video is really loud, so an external microphone would really improve the production quality. keep up the good work!

[MrMahankumar]

Hey dude. I will be here when you have a million.
Subscribers that is

[hanskalders]

thank you, how do you to the text to columns function in gspread? Or is there an equivalent

[Conetopiatv]

Isn't it bad to share the API & Tokens? so confused.

[rckaushik]

when I am reading through gspred_dataframe it's also reading empty rows, how to stop that?

[michaelshea]

Jeeze- please get rid of that stupid keyboard clicks.