'gdplot' is a library to generate charts of predefined format and produce a chart of specific nature, i.e average sales and timeperiod, using the data available in google sheets. It requires your google credentials and the file access to produce a chart.
- No credentials saved
GitHub: https://github.com/sumankumar0091/gdplot
PyPI: https://pypi.org/project/gdplot/
Documentation:
Issue Tracker:https://github.com/sumankumar0091/gdplot/issues
Download:
This package runs under Python3.5+, use pip to install:
- $ pip install gdplot
Log into the Google Developers Console with the Google account to the spreadsheets you want to access. Create (or select) a project and enable the Drive API and Sheets API (under Google Apps APIs).
Go to the Credentials for your project and create New credentials > OAuth client ID > of type Other. In the list of your OAuth 2.0 client IDs click Download JSON for the Client ID you just created. Save the file as client_secrets.json in your home directory (user directory). Another file, named storage.json in this example, will be created after successful authorization to cache OAuth data. On you first usage of gsheets with this file (holding the client secrets), your webbrowser will be opened, asking you to log in with your Google account to authorize this client read access to all its Google Drive files and Google Sheets.
If this does not work refer to link under See also section.
Syntax:
> import gdplot as gd
> gd.create_chart($credentials, $URL)
e.g.:
> import gdplot as gd
> gd.create_chart(/gcp_credentials/client_secret.json, https://docs.google.com/spreadsheets/d/1pzmXgLMMMWdsfuNuq3a15tP7kbsHpijVAU0BGAJrOAP/edit#gid=0)
'' https://medium.com/swlh/google-drive-api-with-python-part-i-set-up-credentials-1f729cb0372b (Source: https://medium.com/@billydharmawan) https://medium.com/@osanda.deshan/getting-google-oauth-access-token-using-google-apis-18b2ba11a11a (Source: https://medium.com/@osanda.deshan) ''
This package is distributed under the MIT license.