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.