Contents
How do I protect an app script in Google Sheets?
Bounded projects inherit permissions from the container so users with edit access to the spreadsheet will have edit access to the code in the bounded project. One alternative to protect the code from editing is to move it to another project to be used as a library. Another alternative is to create an add-on.
To share a container-bound project, you simply share the parent container file. For example, if you have a script bound to a Google Sheet, you can make someone an editor of the script by making them an editor of the Google Sheet.
What can we do with Apps Script?
What can Apps Script do?
- Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.
- Write custom functions and macros for Google Sheets.
- Publish web apps — either standalone or embedded in Google Sites.
- Interact with other Google services, including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.
What are simple triggers in Google Apps Script?
Simple Triggers. Triggers let Apps Script run a function automatically when a certain event, like opening a document, occurs. Simple triggers are a set of reserved functions built into Apps Script, like the function onOpen(e), which executes when a user opens a Google Docs, Sheets, Slides, or Forms file.
Scripts may not request authorization if you access the script as a web app that runs under the script owner’s user identity. Warning: Web apps and other scripts that use sensitive scopes are subject to review by Google.
Do you need permission to use Apps Script?
Apps Script requires user authorization to access private data from built-in Google services or advanced Google services. Apps Script determines the authorization scopes (like access your Google Sheets files or Gmail) automatically, based on a scan of the code. Code that is commented out can still generate an authorization request.
Do you need authorization to use Google Sheets?
An opposing annotation, @NotOnlyCurrentDoc, is available if your script includes a library that declares @OnlyCurrentDoc, but the master script actually requires access to more than the current file. Add-ons for Google Sheets, Docs, Slides, and Forms generally follow the same authorization model as scripts that are bound to a document.