/books-gdoc-goodreads

Ad-Hoc data cleanup and export from GDoc to Goodreads

Primary LanguageRuby

Collection of tools to move book lists from GDoc to Goodreads

What we have here

  • Ad-Hoc data cleanup and import/export from source GDoc spreadsheet to Goodreads
  • google_drive to access the GDoc
  • openlibrary to lookup missing ISBNs
  • GLI for the command line

Setup

  • optionally bake your favorite ruby gem environment
  • gem install bundler; bundle install
  • cp example_config.yml config.yml
  • create oauth client at google
  • add the secrets to the config
    • don't commit those secrets! (the .gitignore will help you there)

Watch out

This is all highly specific to my own GDoc, so YMMV a whole lot. You should probably work on a copy of your sheet. If you mess up completely, remember that GDoc lets you view and restore history with File -> See Revision History

Goodreads import has idiosyncrasies which will probably vary over time.

They have an API too but at the time of writing this, I couldn't do what I wanted with it.