Skip to content

Instantly share code, notes, and snippets.

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/fd7f5fe9f4bf55ba7c394b181d172f95 to your computer and use it in GitHub Desktop.
Save iaindooley/fd7f5fe9f4bf55ba7c394b181d172f95 to your computer and use it in GitHub Desktop.
Export cards with checklist to spreadsheet
function exportCardsWithChecklistToSpreadsheet()
{
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
new Trellinator().board("My Board").cards().each(function(card)
{
sheet.appendRow([card.link(),card.name()]);
card.checklists().each(function(cl)
{
sheet.appendRow([,,cl.name()]);
cl.items().each(function(item)
{
sheet.appendRow([,,,item.name()]);
});
});
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment