I’ve created a flow to add every ClickUp task that is closed to a google sheet.
The problem is that -among the various columns that I’m populating- I need also to add the value of a specific custom field but I cannot seem to be able to do that.
Since activepieces is providing the list of custom field not based on their ID but rather on their “appearance”. The same custom field could be “Custom field [1]” or “Custom field [4]” based on how many custom fields have been filled out in the task (or at least that is the logic I’m seeing).
I would need to simply apply this logic: in the column A of the google sheet, add the value of the custom field X that is identified by the ID “xyz” in the ClickUp task.
How can I do it? Thank you in advance.