If that "pull data directly from API" is about updated prices, change24, volume, CMC-rank, etc. - then you have found your solution. A solution, at least.


My system has two components:

- the frontend is a GoogleSheets spreadsheet, with additional GoogleScript functions to do cool stuff

- a dataserver backend which can compile data from many different sources, and concurrently.


The second was necessary, because every exchange has a different API format, and because GoogleSheets just collapsed under the load of too many concurrent requests.