Google app script within Coda packs

[Gabriel_de_Almeida]

Is it possible to use Google App Script within CODA packs?
I want to create functions in Coda packs to create documents from templates in Google Drive using Google App Script functions.
Thank you.

[Agile_Dynamics]

There is quite a long thread on this topic in the forum already.

It is possible, but it is not simple.

Trigger Google Apps Script from Coda

Hi @Hannah_Strong - As @Scott_Collier-Weir alluded to Apps Script has a REST API you can use to execute a script remotely: However you can’t easily create a generic Pack for this, since the execute endpoint requires that you authenticate with: The same Google Cloud project used by the script. The unique set of scopes that the script requires. The OAuth2 support in Packs doesn’t allow users to swap in different a client ID in secret or a dynamic set of scopes. You can however build a one-o…

[Eric_Koleda]

The Apps Script Pack I mentioned in that thread has a TriggerWebApp action now, which does make it easier to connect the two, but still with the limitations mentioned.

[Gabriel_de_Almeida]

Thanks Agile and Eric.
I had seen this thread, it is a viable solution.
But my question was about executing commands from the app script itself, like SpreadsheetApp, inside the Coda pack.
I imagine that this is not possible.
Thanks for the answers.

[Eric_Koleda]

That’s correct, the Apps Script interfaces (SpreadsheetApp, DocumentApp, etc) are not part of the Packs SDK. You can use the Fetcher in the SDK to make requests to Google APIs for those products (Sheets API, Docs API, etc), but it can be a bit more complicated than using the Apps Script interfaces.