Skip to main content

I have a question regarding a zap between ClickUp and Zapier.

I am building a workflow using ClickUp forms to collect Chocolate Orders from employees in our company in time for the Christmas season. They can fill out the form by indicating the various quanities of each chocolate they’d like to order. The tricky part is mapping out information from the label question type which asks if the chocolate is being charged to their group or to them personally.

For the label question type, there are 4 options, this is created with a custom field called labels. Additionally, there are 2 pieces of conditional logic in this labels question type in ClickUp.

Unfortunately this information doesn't sync very well with Zapier. It just shows the 4 different options but it doesn't show which option was selected by the employee.

In clickup itself I can see which option the client selected as you can see on the image below:

 

Any help would be greatly appreciated, thanks!!

Hi ​@mochi1237 

For us to have more info, post these screenshots:

  • how your Zap steps are outlined
  • the DATA OUT from the ClickUp Zap step

 


All fields contain the information the user inputted, except for which label they chose under the column “Payment Type”. This matches to the ClickUp labels field named, “Choose Order Type”.


@mochi1237 

You did not post screenshots showing the DATA OUT from Zap step 1 for us to have true context.

From your screenshot it looks like you need to map a different variable from ClickUp.

The current mapped variable appears to have a value for all of the custom field options as indicated by the “config” part of the variable name.

 


Did you mean the records pulled after the trigger step? Or something different? I initially thought you mean the DATA OUT onto the spreadsheet.

 

Yes I have tried all the mapping all the variables for the “Choose Order Type” variable, but none of them see to output the label chose by the user.


@mochi1237 

We would need to see screenshots of the DATA OUT from Zap step 1 related to all instances of the custom field “Choose Order Type”.

The one you currently have mapped appears to be metadata about the custom field option labels and not actually the selected custom field value.


 


@mochi1237 

Screenshots do not have enough context to indicate which step those are related to.

You should post screenshots from Zap Step 1 from the DATA OUT tab since that is the data returned from ClickUp.


I am confused, aren’t these screeshots from the Zap Step 1 Data Out? It says Data Out at the top.


@mochi1237 

Screenshots show DATA OUT, but do not show the Zap step those are related to.


Ok I’ll attach the Zap Step here: 

 


@mochi1237 

The newest screenshots show Zap step 1 tabs:

  • Setup
  • Configure

The newest screenshots do NOT show data from these:

  • Zap Step 1
    • Test
      • DATA OUT
  • Zap Step 2
    • Test
      • DATA OUT

To extract selected ClickUp label values into Google Sheets, use the ‘Find Task’ or ‘Get Task’ action to pull in the task details, including labels. Then, in the Zap step that creates or updates your Google Sheet row, map the specific label field(s) received from ClickUp into the correct column. If labels don't appear directly, use a ‘Formatter → Utilities’ step to split the label string into individual values before mapping. This allows you to extract exactly the labels you need into separate Google Sheets cells.
There are for more: Google Sheet and Zapier Community