How to pull these 2 data fields from Goodreads?

Hi there!

I made a spreadsheet of books that I want to read, and now I want to update it with live info from goodreads.com. The essential 2 fields I want to get are the number of votes and book score (with only the decimals, omitting number 4 & that dot in the end result). If possible, I want to get the book name and author into the sheet too, with links embedded to click from excel.

I’ve tried to follow instructions on the net about Data => Get external data => From web… but excel can’t load goodreads page without failing many scripts, and I can’t select the values I want. So, is it possible? Are there any ways to do it kinda automatically? Like, when I want to add a new book to my list, I’ll just press some button, paste the book link and it’ll retrieve all the above info & paste them neatly into a new row?

Thank you!

I don’t think there’s any easy way to do it, and maybe no difficult way either, since Goodreads have deprecated their API.

But you can download whatever you have in ‘My Books’. There’s an option (left, bottom) under Tools, that lets you export the info to a CSV file that you can open in a spreadsheet.

You could program a data scraper in your favorite programming language to take in the URL and retrieve the data. The score at least is neatly identifiable as:
<span itemprop="ratingValue"> 3.92 </span>

You could.

The number of ratings and reviews are in

<span data-testid="ratingsCount">27,341<!-- -->&nbsp;<!-- -->ratings</span>

and

<span data-testid="reviewsCount" class="u-dot-before">3,796<!-- -->&nbsp;<!-- -->reviews</span>

The OP could get someone to write a program to do that, and even write the results automatically into his spreadsheet, as long as the URLs of each book are known. I could do that myself.

The question is whether it’s really worth the time and effort. Also, the next time Goodreads changes their interface, the scraping program may stop working and have to be modified again.

Yeah, I didn’t say it would be worth it. :slight_smile:

If it were me I’d use the “want to read” tag in Goodreads and export that data. But I already keep track of all my reading there and I don’t know how the OP uses their spreadsheet or if the export contains the fields they want.

A small stand-alone database would also be better than a spreadsheet, but then you’re putting time into something too elaborate for a simple, nice-to-have reading list. :wink:

That’s right, haha. Thank you guys. It’s not worth the efforts, better use goodreads’ internal feature. If only I can add a note to some books.

There are many reading list apps out there.

LibraryThing seem quite popular.

Also:

You can, but it’s a column not visible by default. I googled “goodreads add notes to book” and found this:

You can add private notes via the desktop site but I am not aware of any ability to do this from the Android app. You could access GR desktop from your Android device using a web browser and depending on screen size it may work for you.

From the GR desktop site go to My Books → Want to Read → Settings → check the ‘notes’ column → then click ‘Save current settings to your “to-read” shelf’

When the page refreshes you will have a new visible column which you can edit to add recommendation info.
Goodreads Help

I don’t know if going to “Want to read” actually enables it just for that category, but it can’t harm to follow it to the dot.

Whew, I’ve done the transformation. Not the best stuff but OK to use.