Share a custom google sheet function with another email address without showing the source code

1
votes

Iv'e written a custom google sheet function using Google Apps Script, and i would like to share it with another spreadsheet user, but i do not want to share the functions source code.

I've converted the Google Apps Script to a project, but now i have no idea how to link the project back to my sheet, so the function will work again.

I also do not want to publish the AddIn to the marketplace.

Test As Addin also doesn't work, the sheet is opened in a new tab, but the cells with the custom function says #NAME?.

What am i missing?

1
google-apps-scriptgoogle-sheetscustom-function
It says #NAME? because the custom function is not part of the active spreadsheet. Like you said, it is saved on a different project. The error says that a function with this name does not exist. I believe what you are asking is not possible. – soMario
So the goal, sharing a custom function to other others, but not the source code is not possible? in that way or other? – Jew

1 Answers

2
votes

Explanation / issues:

  • The error #NAME? indicates that you are trying to use a function that does not exist. As you also mentioned, this function does not belong to the active spreadsheet but on a different project.

  • Unfortunately, it is not possible to share a custom function with other spreadsheets directly.

Possible Workarounds:

  • You can create an add-on.
  • Another workaround solution would be to create a library. That is a great alternative and the documentation is quite straightforward.

Related: