How to protect the Apps Script code in a Google spreadsheet?

by

Short Answer

Publish your script as an editor add-on or as a Google Workspace add-on. Bear in mind that you could make it private, by selecting unlisted or making it available only for your G Suite / Google Workspace organization.

Explanation

Add-ons were added on 2014. This is better than using a library because there will be nothing shared from your add-on.

Please note that

  • it’s not possible to access Google Apps Script server-side code by using Chrome Developer Tools or another similar software.
  • there are some restrictions for add-ons, study them carefully as maybe this alternative will not work for you.
  • nowadays add-ons require a Google Cloud Project and an oAuth consent screen. If the add-on will be shared with external users it will requires an oAuth verification and an app review.

If publishing as add-on is not an option for you, you should rethink your solution considering the use of a web application, using the Apps Script API or the Google Sheets API.

References

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How do you create a “reverse pivot” in Google Sheets?
  3. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  4. Automatic timestamp when a cell is filled out
  5. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  6. Apps Script: how to get hyperlink from a cell where there is no formula
  7. Retrieving Google Sheets cell border style programmatically
  8. Determining the last row in a single column
  9. Cannot find method getRange(number,number)?
  10. You do not have permission to call openById
  11. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  12. Single Google Form for multiple Sheets [duplicate]
  13. Adding Buttons To Google Sheets and Set value to Cells on clicking
  14. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  15. How to replace text in Google Spreadsheet using App Scripts?
  16. Custom function throws a “You do not have the permission required to setValue” error
  17. Refresh data retrieved by a custom function in Google Sheet
  18. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  19. Margins parameters for Google spreadsheet export as PDF
  20. Google Apps Script: Dynamically creating spreadsheet menu items
  21. Script to convert .XLSX to Google Sheet and move converted file
  22. Hidden field in a Google Form
  23. Apply multiple font colors to the text in a single Google Sheets cell
  24. How to evaluate a spreadsheet formula within a custom function?
  25. Google Sheet use Importxml error could not fetch url [duplicate]
  26. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  27. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment