Click Up to Google Sheets Sync

How To
,
1

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.

image
image373×144 4.92 KB

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,

2

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.

3

This is definitely along the lines of what I am looking for, but I am not sure how to use a get(map()) function in make. Is there some sort of guide somewhere that would tell me how to do it? I did take a software bootcamp a while back, so I do know what the function will accomplish, I am just trying to understand how to apply it in make.com.

Thanks for the reply!