How do I use a filter or a query?

Please let us know below the article if you found it helpful. Thank you!

Each connection supports to select only a fraction instead of the entire sheet.

This feature is called filter or query.

You can access filter when editing or creating a connection.

Filter comes with two modes which are explained below. 

1. Filter by condition

This allows you to only import those rows whose value match a condition defined for a specific column.

2. Filter by query

This allows you to select your data using an SQL-like query statement. This allows you to perform various operations prior to connecting. Please familiarise yourself with the official query documentation.

This will only select columns A, B and E of the connected sheet.

Have more questions? Submit a request


Please sign in to leave a comment.