How to create blocks for fetching and filtering(by specifying a field n its value) Google Spreadsheet data

[TechSupport]

I am trying to create Kodular blocks for fetching, displaying data it in a grid form from Google Spreadsheet and filtering records as per the field value specified such as Name = Karan. And also can we update a selected cell in grid view by clicking on after that. Please guide me with this asap.

[Still-learning (1-2-3-4...)]

Both the methods are possible Did you try anything , just show us.

Search Bar & Filter Google Sheet!?

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