SpreadG is a small wrapper around the Google Sheets API (v4) and gspread 3.6.0 to provide more convenient access to Google Sheets from Python scripts and plot graphs with the help of Matplotlib.
Turn on the API, download an OAuth client ID as JSON file, and start working.
# pip install -r requirement.txt
pip install spreadgThis will also install google-api-python-client and its dependencies, notably httplib2 and oauth2client, as required dependencies.
from spreadg import *
data=dataloader('credentials.json', "Sheetname")
df=to_df(data)
fig = plotter(df, X, y)
fig.savefig("something.png")author: Himanshu Pal
mailto: palhimanshu997[at]gmail[.]com