Fetch Column

[gvalero]

no worry Roldy, I suffered the same when I did my own Rest API weeks ago:

A Google Sheet working as a REST API: good or bad idea?

Hola! It’s just a Proof of Concept which I wanted to do since a long time ago to know how reliable and fast a Google Sheet can handle a large amount of data and be used as an API to receive/send data frequently. As you should know, GS is not a native database therefore, some key functionalities (like an indexed file) don’t exist and can’t be used to improve the lookup speed. GS has the Filter() and Query() as tools to search data but it isn’t enough to make a lookup fast or optimal, both of th…

BTW… How many rows are you handling and how fast is your API’ reply?