I’m guessing that what you want is (or could be) part of this most excellent ESI/Google Sheets code base:
I don’t think that @Blacksmoke16 has yet implemented the mining data you need but it looks like it’s anticipated in what he’s produced so far. ( “esi-industry.read_corporation_mining.v1” )
I recommend you ask him in this thread
Even if it takes an afternoon to learn it/create the analysis you need from the GESI-supplied raw data, it sounds like it will be well worth the effort.