How can I extract checklists items names in trello ? Edited

[Hana ha]

Hello, 

I am using zapier in order to extract data from trello cards and store them in a googlesheet spreadsheet.

I mostly used regular expressions and it works very well, but one thing remains complicated for me. I'm trying to get the names of the checked items on a checklist. The only things I can use seem to be : 

- check item states

- ID checklists

- badge check items

- badge check items checked

I used the last two, but I'd really like the name of those items and not the total number.

By any chance, do you know how I can do that ? 

If what I am saying is not clear, don't hesitate to ask me!

Thank you very much for your help !

[Iain Dooley · Accepted solution]

@Hana ha when you get the check item states, does it return the item ids or item names along with the state? 

[Hana ha]

@Iain Dooley  thank you for your answer. When I try to get the check item states it just says 'no data' and nothing is returned. But I have 5 items checked though...

[Iain Dooley]

@Hana ha hmmm I don't know how else you would do it in Zapier. This Trellinator function would append a row to a spreadsheet whenever a card is moved to the "Export" list with a link to the card, its name and a list of all checklists on the card along with their completed items:

https://gist.github.com/iaindooley/4682199a988a330cf77b85e734f21930

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

[Hana ha]

Thank you very much @Iain Dooley , I will try with Trellinator !

[Iain Dooley]

@Hana ha cool free to ask if you have any questions, you can see lots of examples here:

https://gist.github.com/iaindooley

and more docs here:

http://docs.trellinator.com/