Google Sheets A1 notation for a applied Filter

I have a really large sheet I am trying to iterate through to take action. This sheet has 84,000 plus rows which is to much for Retool and my browser to handle at once. I was wondering if there is the ability to apply an A1 notation to identify a filter view to call so I am only bringing back the data I want.

In my use case I iterate through the sheet then set a google sheet column of loaded to done. I'd like to only load the first 2000 that are not marked as done.

Hi @kburnham, Yes you can use A:1 notation in a Read data from spreadsheet query. Under the Data Range section of your query editor, you'd need to select Use A1 notation.

That being said, it sounds like you would be better off using a database here if that's an option!