goodreads.rb

require "csv"
require "rainbow/refinement"

using Rainbow

headers = ["Book Id", "ISBN", "Title", "Author", "Date Read"]
CSV.open("output.csv", "wb") do |csv|
  csv << headers
  CSV.foreach(ARGV.shift, headers: true) do |row|
    puts format("%s %s (%d/5) %s", row["Date Added"].cyan, row["Title"], row["My Rating"], row["Exclusive Shelf"].yellow)
    if row["Exclusive Shelf"] == "read"
      row["Date Read"] ||= row["Date Added"]
      row["Date Read"] = row["Date Read"].tr("/", "-")
      row["ISBN"] = row["ISBN"][2..-2]
      csv << row.to_h.slice(*headers).values
    end
  end
end