Skip to content

Instantly share code, notes, and snippets.

@andyburnett

andyburnett/Trello to Google Spreadsheet

Created November 9, 2014 13:11
Show Gist options
  • Save andyburnett/2212fa88feff30e64a2b to your computer and use it in GitHub Desktop.
Save andyburnett/2212fa88feff30e64a2b to your computer and use it in GitHub Desktop.
Download ZIP
Convert Trello's JSON feed into simple Google Spreadsheet - this abstracts the text of the card, and the list name.
Raw
Trello to Google Spreadsheet
temp1 := ZnEasy get: 'address in here'.
trello := NeoJSONReader fromString: temp1 entity.
trelloLists := trello at:'lists'.
trelloCards := trello at:'cards'.
trelloLists do: [ :each|| listId |
listId := each at:'id'.
each at:'cards' put: ((trelloCards select:[:item|(( item at:'idList')=listId)])collect:[:item| item at:'name']).
].
trelloLists do: [ :each| Transcript show: (each at: 'name'); cr. ((each at: 'cards')do:[:item| Transcript tab; show: item;cr])].
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment