Open Source Web API integration into Google Sheets

We need to populate our google sheets with about 7 columns worth data from Helium Systems API https://docs.helium.com/api/blockchain/introduction/

We will have a spread sheet with all the Helium HotSpot Names we want to look up the transaction history for.
We want lists of all transactions and the transactions arrogated into earnings for a 24HR period, 48HR period, 7Day, 30Day, and All Time earning for each hotspot name.

Were going to need this to work for multiple spreadsheets that have different lists of hotspots names.
Also these Google Sheets with lists of hotspot names should allow us to add or remove hotspots and auto populate relevant information from the API for those hotspots.

An example of our google sheet may look is attached. We will likely have 500+ to 1,000 HotSpot names we are needing to manage on one google sheet.

Please let us know how fast the frequency will be of the updates. The fields we are pulling from are updated every few minuets, but if that’s not possible please let us know what is more realistic.

We want to make sure Google sheets will not have loading issues, so if another platform would work better we are open to suggestions, but our preference is to work in Google Sheets.