importing external javascript to google apps script

javascript google-apps-script trello
dixkin picture dixkin · Sep 5, 2013 · Viewed 18.8k times · Source

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!!!

Answer

owyongsk picture owyongsk · Oct 24, 2015

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());

Related questions

Creating hash array in Google Apps Script

I've been trying to work with Trello and the Google Apps Script this week. I am trying to create an array of hashes that I can then use to load the spreadsheet. Google apps script doesn't like the typical javascript …

Read More
TypeError: Cannot read property "0" from undefined

I'm getting a very weird undefined error: function login(name,pass) { var blob = Utilities.newBlob(pass); var passwordencode = Utilities.base64Encode(blob.getBytes()); var ss = SpreadsheetApp.openById(""); var sheet = ss.getActiveSheet(); var data = sheet.getDataRange().getValues(); var i=1; while (name != …

Read More
Count the cells with same color in google spreadsheet

I'm trying count the number of cells with the same background color and put the result in other cell with a script in google apps script, but I can't do it. I have the next script but not work and …

Read More