/grapher_public

This project extracts data from a set of Google Sheets worksheets and graphs the result using Google Drive API and gspread and matplotlib 📈

Primary LanguagePythonMIT LicenseMIT

Google Sheets Summarizer

About

This project uses Google's poorly documented API to clone a defined template and clone it to another folder

This project extracts data from a set of Google Sheets worksheets and graphs the result using Google Drive API and gspread and matplotlib

Result

Alt text

Show have in dir when finished

  • credentials.json - credentials to access Google's API
  • sheets.json - Google sheets credentials
  • token.pickle - pickler acts as credentials. if available, let the user log in

Resources

Modules used

  • gspread
  • google-api-python-client
  • google-auth-httplib2
  • google-auth-oauthlib
  • matplotlib
  • numpy

Nothing more, nothing less