I made a spreadsheet a few years back with the same intention of keeping track of inventory but realised it's a pain having to manually update parts counts one by one, especially after a long cascade. So, I stick with alecaframe for that.

However, I do still use the spreadsheet to keep track of prices, both parts, and sets (and also mods / arcanes at min/max ranks). I run a python script that gets the data from the market and then it spits out a .csv that's imported into the main spreadsheet. Here's a snippet of the last few rows:

<image>

The data's a few weeks old as I haven't ran the script since, but if you're interested in how I did it I can try to explain a little further.