0

I'm using some Google Sheets add-on which pulls information from API databases, and it has both a free subscription and paid subscriptions which add many additional abilities which I don't really need, plus one I do need which is automatic scheduled data-pulls.

The product page even explains why the scheduling is limited in some ways due to how Google itself provides timing for automatic triggering.

So my question is, is it possible to write a separate Apps Script that simply tells an available add-on when to run?

Thanks.

Improve this question
2

1 Answer 1

Reset to default
1

I do not think that you can trigger an add-on to run using Apps Script. The easiest solution, and the right thing to do, would be to pay the add-on developer the subscription fee they request for the scheduling feature.

Improve this answer
2
  • While that might be reasonable in some situations, I think that subscribing for several dozens of dollars per month for basically the ability to tell Google (not the company who made the add-on) to tell its own servers to re-run a the add-on is too expensive. I would have definitely paid if there was a reasonable one-time purchase, although as I said beyond the features already available in the free version I only need to automatic triggering
    – TLSO
    Oct 24, 2021 at 16:29
  • This one specifically is called API Connector, although if this option is possible in principle I suppose it shouldn't matter what add-on is in question.
    – TLSO
    Oct 24, 2021 at 22:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.