In this post there is a custom function built that returns data based on gviz query. How to use Google sheets query or Google visualization api from apps script?
But it is little slower, is there any way to make it fast or any other technique? like using out:csv ?
