can you study this if this will work for you?
your spreadsheet is NOT a data source but as a URL parameter to webapi. you can do all kinds of SQL like queries against it
select…where clause with multiple conditions, group by, limit, etc. -
see below this for details:
after you issue your query what is a returned is a JSON object containing all the columns you specified, ready to be parsed.
i think it works best with a static spreadsheet (ie. not continually updated).
i hope it works for you.