Little script for formatting Google Takeout JSON book lists into Goodreads compatible CSVs

bookformat.rb

#! /usr/bin/env ruby
require 'json'
require 'csv'
files = Dir.glob('**/*.json')

CSV.open('googleplay.csv', 'wb') do |csv|
  csv << ['ISBN', 'Date Read', 'Bookshelves']
  files.each do |f|
    begin
      x = JSON.load(IO.read(f).gsub(/\[\]\z/,''), :quirks_mode => true)
      row = []
      isbn = x.dig('volumeInfo','industryIdentifiers')&.first&.dig('identifier')
      next if isbn.nil?
      row << isbn
      row << DateTime.parse(x.dig('userInfo', 'acquiredTime')).strftime('%F')
      row << 'google-play read'
      csv << row
    rescue StandardError
    end
  end
end