Goal Seek Add-On with App Script

[deeksha sharma]

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]

Do you mean the following add-on:

https://workspace.google.com/marketplace/app/goal_seek/583737146763

Does the add-on not work for you?

Do you want code that you can install yourself?

[deeksha sharma]

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]

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.