Custom Functions with add-ons?

by

Answer

According to Eric Koleda in [Code.gs – date_add_and_subtract]( https://github.com/google/google-apps-script-samples/blob/master/date_add_and_subtract/Code.gs) to make available the custom fuctions in an add-on it’s required to include at least one add-on menu, but this is not working at this time on testing mode.

NOTE: The originally referred page was removed but the Date add and substract add-on sample code is available at https://github.com/googlesamples/apps-script/tree/master/sheets/dateAddAndSubtract.

The “solution” to test a custom function add-on is to publish the add-on privately so you could avoid the Google review of an untested add-on. Related Q&A: Publish an add-on privately

NOTES:

  1. You have to create a Google Cloud Project, set OAuth Consent Screen, add the Google Workspaces Marketplace SDK, complete the configuration page, the listing page and to publish the add-on
  2. Setting the OAuth Consent Screen for Internal Use requires to a Google Workspace Account
  3. Setting the OAuth Consent Screen for External Use limited to test account only doesn’t allow to publish the add-on to the GW Marketplace.

One scenario is to use different Google Cloud Projects for testing and production but use the same Google Apps Script project. Another scenario is to have two different Google Apps Script projects each one with their own Google Apps Project and someway copy the code from one to the other i.e. using Google Apps Script GitHub Assistant Chrome Extension, CLASP or the Google Apps Script API.

Remarks

There are a couple of related GAS issues, please star them:

More Related Contents:

  1. You do not have permission to call openById
  2. No permission to call msgBox in Google Apps Scripting
  3. Detect user inserting row or column in a google spreadsheet and reacting in a script
  4. Google apps script error: “You do not have permission to call protect” [duplicate]
  5. Use script in all spreadsheets
  6. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  7. Publish an add-on privately
  8. Refresh data retrieved by a custom function in Google Sheet
  9. How do you create a “reverse pivot” in Google Sheets?
  10. How to protect the Apps Script code in a Google spreadsheet?
  11. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  12. Automatic timestamp when a cell is filled out
  13. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  14. Apps Script: how to get hyperlink from a cell where there is no formula
  15. Retrieving Google Sheets cell border style programmatically
  16. Determining the last row in a single column
  17. Cannot find method getRange(number,number)?
  18. Single Google Form for multiple Sheets [duplicate]
  19. Adding Buttons To Google Sheets and Set value to Cells on clicking
  20. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  21. How to replace text in Google Spreadsheet using App Scripts?
  22. Custom function throws a “You do not have the permission required to setValue” error
  23. Margins parameters for Google spreadsheet export as PDF
  24. Script to convert .XLSX to Google Sheet and move converted file
  25. Hidden field in a Google Form
  26. Apply multiple font colors to the text in a single Google Sheets cell
  27. How to evaluate a spreadsheet formula within a custom function?
  28. Google Sheet use Importxml error could not fetch url [duplicate]
  29. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment