Flatly will refresh a Google Sheet every 10 minutes, hourly, daily or weekly.
If you set Filters in Google Sheets, your Filters will be preserved during every refresh.
This means you only need to define your Filter once.
Note: Due to the way Google designed Google Sheets Filter views, you may need to periodically update your RANGE to accommodate additional rows. (the range can't be dynamic).