How to get a value from google sheets?

Hi, How can I get all the values form google sheets? Like if the text = any username which is in the google sheet plz Tell me I need this so badly

Go to data sources.
And Use a get list of values block.
And check if the list contains the text.

1 Like

It’s not working Did you meant like this?


No i mean check if the lists contains the text item.
You can find that block in the list drawer.

1 Like

What is list drawer?

How can I find it?

I am not on the new mod.

Its thiss one:

1 Like

oh thanks but which block?

1 Like

@thunkabot display help

Use the does list contain block

1 Like

like this?


Like this:
Replace the navigate to screen blocks with custom blocks.

1 Like

ok but now I want if the text is not = table plz help

Add a else to the if statement.
And put your code there.

1 Like

hope this one works. thanks for your time

1 Like

Edit each of your posts instead of posting several questions in a row. This is supposed to be a formal (for the most part) discussion.

Discourse lets you make a maximum of 3 posts in a row, so that tells you it is not a fan of continuous spamming either.

As codeswept told you in another topic of yours, this is a forum, not a chat room.