Click Up to Google Sheets Sync

I have a scenario where I would like to not only list all the tasks, but each Custom Field I fill out as a result. The main purpose of this is to have a working list of all active projects in our database. I have been able to get the integration set up usting the Watch Tasks from Click Up, a Search Rows for Google sheets (to make sure there are no duplicate ids), then an Add a Row function to add new rows to a specific good sheet.

The biggest problem, is the Company Name field (which is a custom Dropdown in ClickUp), shows up as numbers instead of text for each company.

What do I need to do to get this sorted out? Mostly I just need the customer name, but it would be nice to be able to pull all custom fields.

Can someone help?

Let me know what else is needed to help me figure out this.

Thanks,

Hey Derek,

there is an array called Custom Fields (original) coming from the ClickUp module that you can use to find the exact value of the dropdown field using a get(map()) function combination.