Скачать или смотреть Understanding Google Apps Script Deployment Permissions for Spreadsheets

Discover why you need to set permissions separately for your Google Apps Script and the spreadsheet. Learn how to share your web app effectively with your colleagues.
---
This video is based on the question https://stackoverflow.com/q/64142841/ asked by the user 'LiamK' ( https://stackoverflow.com/u/14369068/ ) and on the answer https://stackoverflow.com/a/64143304/ provided by the user 'TheMaster' ( https://stackoverflow.com/u/8404453/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Google apps script deployment permissions required separately for spreadsheet?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Understanding Google Apps Script Deployment Permissions for Spreadsheets

If you're working with Google Apps Script and trying to deploy a web app that interacts with Google Sheets, you might encounter some confusion regarding permission settings. Specifically, you may wonder whether you need to set permissions separately for the spreadsheet and the application itself. Let’s unravel this important topic to ensure a smooth experience while sharing your app with colleagues.

The Problem: Permission Errors When Accessing Spreadsheet

You may have deployed a Google Apps Script as a web application, set permissions to 'Anyone', and selected 'User accessing the web app' for execution. However, upon running your app, you encounter an error message that states:

“You do not have permission to access the requested document.”

This error can be frustrating, especially when trying to share your app. Let's explore why this issue arises and how to resolve it.

The Solution: Understanding Permissions

Separate Permissions Required

Yes, you absolutely need to set permissions separately for both the spreadsheet and the web application. Specifically, if you have configured the web app to run as User accessing the web app, the following applies:

Spreadsheet Permissions: The user (your colleague) must have necessary permissions to the spreadsheet you are accessing with the script.

Web App Permissions: The web app also needs to be set properly to ensure that it can be accessed by the intended audience.

Permissions Setup

1. Spreadsheet Permissions

For your colleagues to access the spreadsheet:

Go to the spreadsheet in your Google Drive.

Click on the Share button.

In the sharing settings, enter the email addresses of your colleagues or share the link with edit/view permissions as per your requirements.

Make sure to set the correct access level (Viewer, Commenter, Editor).

2. Web App Permissions

To configure the deployment of your Google Apps Script web application:

In the Google Apps Script editor, choose Deploy and then New Deployment.

Set the following options carefully:

Who has access to the app: Choose Anyone or customize it based on your needs.

Execute as: If you want users to access documents as themselves, select 'User accessing the web app'. If you want the app to run under your own account with all access, select 'Me'.

Conclusion: Share with Confidence

After setting up both the spreadsheet and web app permissions correctly, your colleagues will be able to access the app without encountering permission issues. This ensures a seamless collaborative experience when working on projects that use Google Sheets and Google Apps Script.

Final Tip: Always double-check both permissions whenever you deploy a new version of your web application or change any document settings. This will help prevent future access issues!

With the knowledge of how to properly configure your Google Apps Script and the associated spreadsheet, you're now ready to share your app effectively. Feel free to reach out with any other questions or clarifications regarding Google Apps Scripts!