nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I extract checklists items names in trello ?

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 !

Accepted answers

Iain Dooley

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

All comments

Iain Dooley

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

trello

google-sheets

zapier