Goal Seek Add-On with App Script

417 views
Skip to first unread message

deeksha sharma

unread,
Apr 14, 2021, 2:18:23 PM4/14/21
to Google Apps Script Community
Hi All,

I want to use the goal seek add-on functionality for google sheets through app-script, please help me a way out for this.
Thanks in advance.

Deeksha

Alan Wells

unread,
Apr 14, 2021, 3:54:26 PM4/14/21
to Google Apps Script Community
Do you mean the following add-on:

Does the add-on not work for you?
Do you want code that you can install yourself?

deeksha sharma

unread,
Apr 14, 2021, 10:51:51 PM4/14/21
to google-apps-sc...@googlegroups.com
The add-on works for me on google sheets, but i don’t want to use it through console, want to automate my procedure, so was trying calling it through an app-script.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/wkCVHBlqFEM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/057129e8-e19e-474b-a9c7-d895ef3448dbn%40googlegroups.com.

Alan Wells

unread,
Apr 15, 2021, 10:29:58 AM4/15/21
to Google Apps Script Community
Unless the add-on developer provides a way to trigger the add-on code, then you can't do it.
And the only way to do that is through an On Change event trigger that's done in a special way.
If the add-on doesn't have instructions on how to do that, then I guarantee that it's not possible.

Reply all
Reply to author
Forward
0 new messages