One of the biggest problems that Shadowlands introduced for goblins is the way ilvl of leggos and Crafter's Marks are implemented. Most of our current data sources do not distinguish between ilvls from the same base crafted gear (whether this is due to Crafter's Marks or Leggo ranks.) This creates problems knowing what to craft and how profitable it will be. The loss of the TSM web api only compounds this issue.
I can't fix the TSM API for you but reddit user /u/jmpcallpop
created a spreadsheet and related queries that will download data directly from the Blizzard API and provides that context for the ilvl of items listed. I've taken his base and added onto it a fairly complete set of crafting calculations, comparing the AH pricing with the crafting cost for each recipe by ilvl where applicable.
It is now ready for release. You can find it here:https://drive.google.com/file/d/13O4Ngx0GcMEPQCnnJJNDY7yQ0ML0WJpb/view?usp=sharing
A word on requirements:
It requires Excel, there is no Google spreadsheet version. It works best with Office 365 although I've had some reported success with Excel 2016
- If you get errors related to refreshing the "Query - Auction House Data" it is probably an issue with privacy levels. Go into your Data menu -> Get Data -> Query Options -> Current Workbook | Privacy and set it to "Ignore the Privacy Levels..."
- Realm is a dropdown but if you enter it yourself it is all lowercase, replace <spaces> with a '-' and remove special characters. E.g., Zul'jin is entered as zuljin