Remove Filter on Google Sheets

26 views
Skip to first unread message

Don Beck

unread,
Jul 11, 2025, 10:59:44 AMJul 11
to GAM for Google Workspace
I have 4 Google Sheets that I need to remove filters from on a weekly basis for a bit.

Is there a command I can run to remove the filters from all 4 at the same time?  and of course put them back?

Thanks
Don

Don Beck

unread,
Jul 11, 2025, 3:18:52 PMJul 11
to GAM for Google Workspace
Ross helped me create a json file
{"requests": [{"clearBasicFilter": {"sheetId": <192963956id>}}]}
then a gam command calling the sheet and the json request
gam user ad...@domain.com update sheet <id> json file <name>.json

Worked great - so created 4 more json files and combined all the 5 gam commands into a batch command
Thanks Ross

Reply all
Reply to author
Forward
0 new messages