Skip to main content
Question

How do I properly extract a ClickUp dropdown value to Google Sheets?


MischaDR99
Forum|alt.badge.img+1

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

I work with clickup forms for my clients. They can fill out the question and answer form so I can gather all project requirements.

One of the question I ask is the amount of images they want. There are 3 options, this is created with a custom field called dropdown in ClickUp.

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

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

 



I also found that there are actually 66 references to the question of how many images the client wants to purchase (see screenshot). I am not sure why this number is so high?

 



Here's (a part of the) data that is pulled in by Zapier, I highlighted the actual options the client has in bold
 

Name: Hoeveel afbeeldingen wil je afnemen?
- Type: drop_down
- Type Config:
  - Default: 0
  - Placeholder:
  - Options:
    1. ID: a7d14444-caa9-4fa0-9693-2778bf73d28f
       Name: 6 afbeeldingen (159 exc.)
       Color: #bf55ec
       Order Index: 0
    2. ID: 4b1c1020-7b52-4a56-8aca-ef1bb82a9130
       Name: 8 afbeeldingen (179 exc.)
       Color: #7C4DFF
       Order Index: 1
    3. ID: d5958ad5-3ae1-473a-a21b-5f536b41c530
       Name: 10 afbeeldingen (197 exc.)
       Color: #667684
       Order Index: 2
  - Date Created: 1692179423352
  - Hide from Guests: false
  - Required: false

Name: Hoeveel afbeeldingen wil je afnemen?
- Type: drop_down
- Type Config:
  - Default: 0
  - Placeholder:
  - Options:
    1. ID: 36a76665-c269-4c51-858f-0b939e6da7cd
       Name: 6 afb. (159 exc.)
       Color: 
       Order Index: 0
    2. ID: 58206b92-7001-444a-911a-751d7593a1a3
       Name: 8 afb. (179 exc.)
       Color: 
       Order Index: 1
    3. ID: d61ab173-ed3e-4f68-aad1-4daedb7ae5c1
       Name: 10 afb. (197 exc.)
       Color: 
       Order Index: 2
  - Date Created: 1629811712658
  - Hide from Guests: false
  - Value: 0
  - Required: false
 

Does anyone know how I can properly extract the number of images and thus the revenue which is generated for our company?

Any help is greatly appreciated! 

Did this topic help you find an answer to your question?

6 replies

jayeshkumarbhatia
Forum|alt.badge.img+6

Hi @MischaDR99 , Can you send one more test data of any other submission? 


MischaDR99
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 11 replies
  • August 16, 2023
jayeshkumarbhatia wrote:

Hi @MischaDR99 , Can you send one more test data of any other submission? 

Hi @jayeshkumarbhatia thanks for your reply! Here's more test data of another submission:

      Name: Hoeveel afbeeldingen wil je afnemen?

  • Type: drop_down
  • Type Config: default
  • Placeholder:
  • Options:
    1. 6 afbeeldingen (159 exc.)
    2. 8 afbeeldingen (179 exc.)
    3. 10 afbeeldingen (197 exc.)
  • ID: a7d14444-caa9-4fa0-9693-2778bf73d28f
  • Color: #bf55ec
  • Order Index: 0
     
  • Name: Hoeveel afbeeldingen?
  • Type: drop_down
  • Type Config: default
  • Placeholder: new_drop_down
  • Options:
    1. 6 afb. (159 exc.)
    2. 8 afb. (179 exc.)
    3. 10 afb. (197 exc.)
  • ID: 2d884097-da95-4282-82a3-76bab1a392a1
  • Color:
  • Value: 0

jayeshkumarbhatia
Forum|alt.badge.img+6

Hi @MischaDR99 , In the 2nd second form submission did your customer select 8 afbeeldingen (179 exc.) ? 


MischaDR99
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 11 replies
  • August 16, 2023
jayeshkumarbhatia wrote:

Hi @MischaDR99 , In the 2nd second form submission did your customer select 8 afbeeldingen (179 exc.) ? 

Hi @jayeshkumarbhatia thanks for your reply. It was actually 6 afbeeldingen 


jayeshkumarbhatia
Forum|alt.badge.img+6

OK @MischaDR99 . I will suggest you to open a ticket with Zapier team. 


MischaDR99
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 11 replies
  • August 17, 2023
jayeshkumarbhatia wrote:

OK @MischaDR99 . I will suggest you to open a ticket with Zapier team. 

Thanks! Will do 


Reply