How to programmatically add custom functions?

Question

I'm trying to build a rather unique google sheets addon. Google's documentation is great for adding custom functions, however I want my addon to programmatically add custom functions.

For instance, the following doesn't seem to be possible:

Assume there's a getScript() custom function where if you do getScript("scraper"), this custom function will do an HTTP call and install a new function scraper() in your google sheet.
Then you can do scraper("https://www.google.com") to get all the text from "google.com".

I know it's possible to define scraper() ahead of time.

Is it possible to do so live?

No, that's not possible. You have define all your custom functions ahead of time. — Henrique G. Abreu
– Henrique G. Abreu, Commented Oct 23, 2014 at 15:24
Ahh that's annoying. Would be nice to dynamically add to list of custom functions. — bumpkin
– bumpkin, Commented Oct 23, 2014 at 18:46

Wicket · Accepted Answer · 2020-06-13 17:49:27Z

1

The Google Apps Script platform have changed a lot since this question was posted back in 2014. Regarding editor add-ons they can't add random custom functions but they could send parameters to an external API that might include a function name and the required parameters by that function by using UrlFetchApp.

answered Jun 13, 2020 at 17:49

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to programmatically add custom functions?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related