Call specific data from google sheet

dear team,

please guide me how i call specific data from google sheet in Listview through blocks. reference screen shot is attached.

We have a lot of topics about this. Show what you have tried. If you didn't try anything start by searching the community.

1 Like

Is your google sheet "restricted" or "anyone can view" ?

Gviz Query

Gviz Query Restricted

Anyone

I want blank screen when screen initialize then user search their ID and show record accordingly.

  1. How do they enter their ID on a blank screen ?
  2. What do you want to happen when there is more than one record for a specific ID ?

To show any sheet data in a ListView:

Blank screen means when someone enter his ID then show only ID relevant record instead of all sheet record.