Google Sheets A1 notation for a applied Filter

Queries and Resources
1

Hello,
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.

2

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.

2468×1148 153 KB

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