Skip to content

Instantly share code, notes, and snippets.

@iaindooley
Created August 21, 2019 01:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iaindooley/37321429c2732a7f05dad9c8c988046f to your computer and use it in GitHub Desktop.
Save iaindooley/37321429c2732a7f05dad9c8c988046f to your computer and use it in GitHub Desktop.
Populate spreadsheet from list
function exportToGoogleSheet()
{
var list = new Trellinator().board("My Board").list("My List");
var ss = SpreadsheetApp.getActiveSpreadsheet().insertSheet(list.name());
list.cards().each(function(card)
{
ss.appendRow([card.name(),card.description(),card.comments().asArray().join("\n\n")]);
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment