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?
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>
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.
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.
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.