关于Google Sheets自定义菜单添加已保存Filter Views的可行性确认

As of the current version of Google Sheets, there is no way to directly add saved Filter Views to a custom menu.

Current Workaround #

To access your pre-saved filter views, you have to rely on the default navigation path:

• Navigate to Data in the top menu bar
• Hover over Filter Views
• Select your desired view from the dropdown list

Desired Feature & Limitation #

You’re aiming to create a top-level custom menu named Our Views that lists all your saved filter views for one-click access—this would definitely make the workflow way more efficient! However, the key roadblock here is that there’s no supported Apps Script method to programmatically open an existing saved filter view.

While building a custom menu with Apps Script is straightforward, you can’t link those menu items to trigger the opening of your pre-saved views because Google hasn’t made the necessary function or API available yet.

内容的提问来源于stack exchange，提问作者Randal Oulton