Python script that takes just a few inputs from an Google sheet to query for additional details from https://comicspriceguide.com.
Result is an updated sheet with current values, description, and other helpful features as well as a helpful HTML page with your entire collection in s nice visual layout.
Provide the following columns in a google sheet:
- Title - Your Comics Title (Amazing Spider-Man)
- Issue - The Issue Number (101)
- Grade - Grade of the book (.5 increments .5-9.0 / .2 increments above that 9.2, 9.4, 9.6, 9.8)
- CGC - Yes/No if the Book has been graded by a professional grading service
- Variant - Some Issues have multiple printes/covers, this is where yoo indicate the specific cover you have (E)
- Price_Paid - The Price you paid for the book
- Book Link - Sometimes the app may notselect the right book, this allows you to provide the direct URL, when populated the app uses this rather than searching.
Sheet enriched with:
- Publisher - Publisher of the title
- Volume - Volume
- PublishDate - Original Publish Date
- KeyIssue - Is the book considered a "Key Issue" (Yes/No)
- Cover_Price - Original Cover Price
- Graded Price - Value of book if professionally graded
- Ungraded Price - Value of book if not professionally graded
- Value - Value of book in current state
- Comic_Age - Comic "Age" (Silver, Modern)
- Notes - Short description of the comic, including references to 1st appearances
- Confidence - Confidence the app had when attempting to match
- Book Link - If not provided as input
- Cover Url - Cover image
- CURRENTDATE - The date the scan was performed and the value of the book at that time, allowing you to scan periodically and easily identify price fluctuations.
HTML Results:
- A single HTML page with the covers of each of your books, formatted to look stunning on any format
- Hover-over any book to see book details (Title, Grade, Value, CGC Graded, Key Issue)
- Click any book to go directly to that book on https://comicspriceguide.com
IMPORTANT NOTE: Though I have taken an effort to try and simulate a normal user session wtih delays there is a chance the bot could be detected. If you run this and are detected by https://comicspriceguide.com you stand a chance of having your IP banned from that site.