Simple script to resolve Google Books IDs in Reading List export files

readinglist-googlebooksid-resolver.js

// NOTE: filenames hardcoded!

const got = require('got')
const csv = require('csv')
const fs = require('fs')

async function fetchGoogleBookId(isbn) {
    const queryUrl = `https://www.googleapis.com/books/v1/volumes?q=isbn:${isbn}`
    const response = await got(queryUrl)
    const json = JSON.parse(response.body)

    if (json.totalItems > 0) {
        return json.items[0].id
    }

    return null
}

const processFile = async () => {
    records = []

    const writer = fs
        .createWriteStream('./output.csv')
    const parser = fs
        .createReadStream(`./file.csv`)
        .pipe(parse());

    const stringify = csv.stringify()
    stringify.pipe(writer)

    for await (const record of parser) {
        const isbn = record[0]
        if (record[1] == '' && record[0] != '') {
            record[1] = await fetchGoogleBookId(isbn)
            console.log(`fetch googleBooksId for ${isbn}:`, record[1])
        }
        records.push(record)
        stringify.write(record)
    }
    writer.close()
    return records
}

processFile()
    .then((records) => {
        console.log(records.length)
    })

This is a workaround for Reading List's UX challenge w/ importing Goodreads exports (and losing artwork).