I want to collect data about books by searching their titles in WorldCat ( https://search.worldcat.org/ ). For example, if my input was “Remarkable Creatures”, I want it to output:
Author Name: Tracy Chevalier
Genre: Historical fiction
Publication Date: 2010
Cover Image: https://coverart.oclc.org/ImageWebSvc/oclc/+-+784064419_140.jpg?allowDefault=false&client=WorldcatOrgUI
I want the end-result to be in a Google Sheet, so I would prefer if I could use Google Sheets or App Script to get this result, but I am aware that Google Sheets doesn’t have a built-in function to import from pages using javascript, so I’ll accept any help I can get. I’ve looked at a few solutions, but I haven’t found one that has worked for me yet; this might just be because I’m pretty new at coding.
I’ve tried using Google Sheets functions like ImportHTML and ImportXML with no success (due to the javascript functionality, I’ve learned). I’ve also looked for AppScript solutions, but I haven’t been able to find the appropriate code for what I’m trying to do.