Google Sheets does not handle well heavy sheets with a lot of data. When working with large datasets, Google Sheets can behave very slowly, unreliable and even crash your browser. The solution is 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.