咨询Sheets的Publish to the Web功能权限变更：Bug还是预期调整？

Hey there, from what I've gathered through Google Workspace update announcements and community discussions, this isn't a bug—it's an intentional policy change rolled out around November 17-18, 2020.

Here's a clear breakdown of the shift:

• Prior to November 17, 2020, the "Publish to the Web" feature allowed direct URL-based downloads without requiring the sheet's sharing setting to be set to "Anyone with the link". The publish functionality operated independently of the core sharing permissions.
• The updated behavior now links the published URL's download capability directly to the sheet's sharing settings. You must set the sheet's sharing to "Anyone with the link" (with at least "Viewer" access enabled) for the published URL to allow downloads.
• Google framed this as a security improvement, ensuring that published content's accessibility aligns with the sheet's intended sharing restrictions, preventing accidental public access to sheets that were meant to remain private even after publishing.

If you need to maintain restricted access to the sheet while still enabling downloads for specific users, consider these workarounds:

• Share the sheet directly with individual users or groups who need access, instead of relying on "Publish to the Web". They can download the sheet via the standard Google Sheets interface.
• Use Google Apps Script to create a custom, controlled download mechanism that verifies user permissions before serving the sheet data.

Quick tip: If you've configured the sharing settings correctly and downloads still aren't working, check if your organization's Google Workspace admin has implemented any organizational-level restrictions that might be overriding your sheet's individual settings.

内容的提问来源于stack exchange，提问作者Michael Boegner