Google Sheets + Python Integration

Google Sheets is one of the great tools that businesses use to store and analyze data. However, maintaining a large number of sheets manually is a very tedious job. This tutorial describes setting up the integration between google sheets and python and the different ways for reading and writing data to google sheets using python's gspread and oauth2client library. ================== Sections and Timeline:- ================== 1) Google Sheets Introduction - 0:10 2) Understanding Requirements - 0:52 3) How to enable Google Sheets API in Google API Console? - 1:18 4) Create Access key for accessing Google Sheets - 2:42 5) Install gspread and oauth2client libraries using Pycharm - 5:09 6) Creating an Oauth2client to connect to Google Sheets - 5:58 7) Reading Data from google Sheets - 9:57 8) Writing data to google sheets - 14:04