Sign in Subscribe

Custom Functions — Privacy Policy

Custom Function's use of information received from Google APIs will adhere to the Google API Services User Data Policy, including the Limited Use requirements.

your personal data

  • does not leave the add-on window inside your workspace
  • is not accessed by, used, stored or shared with anyone else (including the developer of this add-on) except you

this add-on does

  • retrieve an OAuth token by means of the ScriptApp.getOAuthToken() function but only to make authenticated api requests to google apps script's rest apis
  • makes use of the properties services to store document and script related data (example: script id, script version number, url of the web app deployed etc.)
  • makes use of the cache service to store publicly available API related data (i.e. via GitHub)
  • connects to external services using UrlFetchApp
  • uses 1 non-sensitive scope
  • and 2 sensitive scopes

scopes

the add-on will make use of a following scopes -

  1. https://www.googleapis.com/auth/spreadsheets.currentonly — this scope will be used to A) read the sheet id which will in-turn be used to create a container-bound apps script project using this endpoint B) store, update & retrieve document and script related data in the properties services
  2. https://www.googleapis.com/auth/script.external_request — this scope will be used to A) make API requests to the apps script rest apis that will help create & update a container-bound apps script project and B) to fetch open-source code that can be used to update the newly created container-bound apps script project
  3. https://www.googleapis.com/auth/script.projects — this scope will be used to create & update a container-bound apps script project using this endpoint

a more detailed explanation of what these scopes make use of can be found in the images displayed here.

contact

  • sourabh choraria - all modes of contact can be found here
  • email: code@script.gs