Easily can be achievable by using gviz query
Your url must be, (use text join block, use three fireld. 1st filed URL, 2Nd field textbox text block and 3rs block ’ (hypen alone)
https://docs.google.com/spreadsheets/d/<Ur gsheet I'd>/gviz/tq?tqx=out:csv&gid=<your sheet gid number>&tq=Select A,B where A contains 'Appl
You have to replace the textbox text block in place for Appl.
For more info