I am trying to use Trello from a Google Spreadsheet (Google Docs) and am not sure how to import/reference/link the javascript files required to use their library. My only other option is using their REST API directly (fine, but I'd rather use their js helper classes).
This is what Trello needs us to use:
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script src="https://api.trello.com/1/client.js?key=substitutewithyourapplicationkey"</script>
How would I import/include these in a Google Apps Script?
THANKS!!!
Based on the answer here by Cameron Roberts, you can use the eval() function on the appscript UrlFetchApp function.
eval(UrlFetchApp.fetch('http://path.to/external/javascript.js').getContentText());
you actually can . In the script project create another new file and simply just paste the JavaScript library copying from the source and save it then start referencing it from other file. It is that simple.
Or you can create another project with the .js lib and publish it and reference that script from the caller project, I wont do that unless that needs to be shared in multiple projects.
You cannot use external javascript libraries this way in Google Apps Script. (You can do so in html files used with the HtmlService. Since so much of Trello is client-side anyway, this may be just what you need.)
In server-side apps script, you should be able to access the library code using the technique from this answer. It doesn't say, but I'd imagine that you would put that eval
outside of all functions in your script, to make the objects in the library available to the rest of your code.
Download them and put them in the script.
The rest api is easy to use. Ive used trello rest from appscript.
Yes you can use JavasSript libraries in Google script. Copy all content of the libraries JavaScript and post it in new GS file.
You can try this 2 options:
- Use it as a normal script tag
<script src="https://unpkg.com/babel-standalone@6/babel.min.js"></script>
- Download the js files and reference them as google says in the docs https://developers.google.com/apps-script/guides/html/best-practices
<?!= include('JavaScript'); ?>
Hope this helps