A tool to scrape card details from the One Piece TCG website and save them to Google Sheets for easy collection management.
This tool is designed for One Piece TCG enthusiasts who want to track and manage their card collections efficiently. With just a few steps, you can extract card details from the official One Piece TCG website and save them directly to a Google Sheet.
- Web Scraping: Uses Python with
requestsandBeautifulSoupto fetch and parse card details. - Google Sheets Integration: Utilizes
gspreadto save the card details to a Google Sheet.
- Python 3.x
- A Google Cloud account (for Google Sheets API access)
- Follow the guide here to set up the Google Sheets API and obtain your
credentials.json. - Place the
credentials.jsonin the root directory of the project.
Change the name of op_collection to your sheet name, and don't forget to change the index of the sheets in the collection dict the way you want
sheet = client.open("op_collection").get_worksheet(sheet_number)
Feel free to send any customization, bug fix or improvements! Just send your PR!
