I finally got around to making a fully Automated google spreadsheet version of my jewelcrafting and enchanting spreadsheet. This will now work for people who don’t have Microsoft Office.
The pages look exactly the same the only difference is in how the data is downloaded. You fill in your Api Key, Region and server as outlined in my post about the xlsx version of my spreadsheet here.
The formulas in this sheet will automatically download the prices as soon as you have filled in your ApiKey, Region and Realm with no extra presses needed. I rely on the google sheet importdata() function to get the data.
The spreadsheet is a bit slow when downloading data, so don’t be scared if it takes several minutes to get all the prices.
I now use a different API method than in my other sheet. This gets the price per item instead of downloading all the pricing data for the entire AH. This API-call is limited to 500 calls per day. The spreadsheet contains 54 different items, so you can do a full update 9 times per day maximum before you run our of possible calls to the TSM API.
Anyway, Happy hunting with this one!
Feel free to pop any questions or report bugs to me either through my blog, twitter or my discord found here: https://discord.gg/cYKRGxw