Скачать с ютуб Using Google Sheets with Python (COMPLETE Beginner GSpread Tutorial!) в хорошем качестве

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. ACCESS THE NOTES & CODE ► https://bit.ly/notesandresources SUBSCRIBE TO MY CHANNEL ► https://bit.ly/subscribethemillibit VISIT THE BLOG FOR FREE WRITTEN TUTORIALS ► http://themillibit.com 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 Hello, I'm Ruchir. I'm the founder of www.themillibit.com, a platform I created to explain difficult coding concepts without the complexities, bit by bit. On this Youtube channel you will find some of the highest quality coding tutorials ranging from Python to Android to IOS programming. I'm a firm believer in learning by doing, so make sure to head over to https://bit.ly/notesandresources to access the code for this tutorial, and run it on your own computer at home. All of these resources are 100% free. #themillibittutorials #python #gspread #beginners #database #pythonlibrary #googlesheetsapi #googledriveapi #learntocode