Yes Sorry come to think of it Smartsheet offer a ‘Get Row’ where you can search for text however, we will always return the most recently updated row if multiple matches are found. Unlike Google Sheets that would return all matches
Are you familiar with storing choices and users options using attributes? this lets you search or Get an attribute across various flows.
As Google Sheets 1000 rows only relates to Searching for data you could still add to a sheet if you wanted some visibility
If that hasn’t helped , There is a more technical approach:
- Adding an api to sheets which would return JSON. That can then be queried and used as data ouputs in a flow.
- Use MY SQL
If you don’t fancy tackling this element of your Bot, I could put you in touch with a company that could build this into your BOT. Just get in touch by email email@example.com I’ll let you know some details.