Google Sheets Script to Fetch MTG card prices. Functions start with MTG and will auto-fill like other google sheet functions.
Card prices are fetched from MTGGoldfish.com and card metadata provided by Magicthegathering.io.
Prices are cached for 24 hours for performance and so that the script doesn't batch MTGGoldfishes servers over the head repeatedly.
To install:
- Open Code.gs using the link above.
- Select all the code from the file and copy it to the clipboard.
- Open the spreadsheet to which you wish to add the add-in.
- Select "Tools > Script Editor"
- Paste the code from Code.gs.
- Save your code, the name doesn't matter but "MTG Price Fetcher" is recommended for clarity.
- Close the code window and return to your spreadsheet.