view results of google SQL query
Posted on 2016-10-18
With google sheet I can query any data sheet with one formula, eg:
=query(importRange(SourceDataKey, "regular!A:Z"),"SELECT * where upper(Col1)='F61' and upper(Col2)='IN'", true)
The output is an array of data.
I would like to be able to view this output automatically from a URL. I would generate a URL in google sheets and clicking it would show the results on a separate sheet.
myURL/... SourceData=.... Sheet=.... SQL= .....
Any suggestions welcome. I'm new to scripts but this might be an option too.