Google Sheets: Search by Query

These actions are meant to be used in synergy.

Search by query

The search query should be in this fashion:   

age < 30 and height = 180

  

Compound searches with parentheses and 'or' commands work as well:    

(name = "john" and pageviews > 5) or engagementrate > 15

     

Make sure that your query is correctly set up. It should have the following : 

a) Column name in small letters without spacing

b) " " Between your data pill

The first thing you need to do is structure your query.

You can either type it out

Or use Data Pills from other steps of the recipe

Using Data Pills means you can manipulate data for your search query using Formula mode

What this action does is it generates an array (list) of the results in the standard data-pill-accessible format.

Do take note of the following limitations:

1. Searching only works for single-word column headers. There must be no spaces in between
   
1. Username works, but not User name
2. Searches are not case-sensitive
   
1. Searching for workato will return workato, Workato and WORKATO
3. Search results are limited to 100 entries returned by the system