Skip to content
GitLab

[not ready] csvgoog command

Closed Administrator requested to merge github/fork/sbma44/google-sheets into master

Created by: sbma44

I took a pass at https://github.com/onyxfish/csvkit/issues/48

I would love one or more additional sets of eyes on this!

Notes:

  • csvgoog --configure to start a web-based authentication workflow
  • repeated calls to --configure will result in invalid credentials unless you delete the app in your Google account's permissions dialog (they'll be missing a refresh token URL). This seems to be a PyDrive bug
  • I'd like to do fuller testing, comparing spreadsheets' actual uploaded content, but this would either require a PyDrive patch or another dependency
  • the presence of client_secrets.json and settings.yaml seems to be necessary despite PyDrive docs implying that tidier solutions are possible
  • I wasn't able to get my tox environment working properly with python3 so while I have written with compatibility in mind, help evaluating py3 tests would be appreciated.
  • Credentials for a throwaway test account are included for testing; if you need the login information please let me know.