Skip to content

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

License

Notifications You must be signed in to change notification settings

Zeyu-Li/grapher_public

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

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

Topics

Resources

License

Stars

Watchers

Forks

Languages