adjust Filter View range?

[Ed-alt Wu]

Is there a way to adjust Filter View ranges via script? We have Filter Views where the row ranges constantly get messed up when people and/or other scripts add/delete rows.

e.g. if a Sheet currently has 100 rows...so a Filter View is set so it covers e.g. A1 to D100...

after rows are deleted/added manually or via script, eventually it'll end up something like the Sheet has 109 or 88 rows, but the Filter View now only covers say A1 to D76.

I'd like to "reset" the Filter View daily so it automatically covers A1 to D(last row)

Can this be done?

[Romain Vialard]

Sure. You will need to use the Sheets Advanced Service for that.

Here are some examples on how to play with the standard filters via this advanced service:

https://sites.google.com/site/scriptsexamples/learn-by-example/google-sheets-api/filters

And the documentation of the Sheets API on how to update a filtered view (you need to indicate the filterViewId):

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#UpdateFilterViewRequest