At the moment, I am leveraging google sheets for a range of complex analytics. I rely upon the Atlassian provided "Jira Cloud for Sheets" add-on.
There are few issues I've found including the daily scheduled refresh failing, for which there is no retry option. Further, this refresh doesn't support a thoughtful stateful comparison and update changes, which would be great.
Is it possible to access the functionality of this plug-in via AppScript?
It seems as though there are only two options.
1. Use appscript to set / update a formula (..setFormula("=JIRA(....))
2. Use the UrlFetchApp to query the API directly (though it seems like it requires embedding your token in the script (bad) or in a protected and hidden sheet (decent).
Any suggestions or ideas if the plug-ins' functionality us App Script... able?
Thanks,
