Google Sheets + Python Integration

Published: 01 November 2018
on channel: PyLenin

34,290

747

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

On this page of the site you can watch the video online Google Sheets + Python Integration with a duration of hours minute second in good quality, which was uploaded by the user PyLenin 01 November 2018, share the link with friends and acquaintances, this video has already been watched 34,290 times on youtube and it was liked by 747 viewers. Enjoy your viewing!

13,912

323