About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Custom fields transferring as numbers instead of text in ClickUp to Google Sheets integration

  • 22 April 2023
  • 1 reply
  • 44 views
frnndmntr

Hello Zapier Community,

I am facing an issue with the Zapier integration between ClickUp and Google Sheets. I have set up the integration to transfer data from a table in ClickUp to a spreadsheet in Google Sheets. However, I am having trouble transferring data from custom fields in ClickUp, as they are being transferred as numbers instead of text.

For example, one of my custom fields is "Client", and in one of the rows in the ClickUp table, the value of this field is "Client X". When the integration runs, the value sent to the Google Sheets spreadsheet is "19", instead of "Client X".

I have checked the integration configuration in Zapier and verified that I am correctly mapping the custom field to the corresponding column in the Google Sheets spreadsheet. However, it seems that Zapier is sending the value of a custom field ID from ClickUp, instead of the value of the custom field itself.

I would like to know if anyone has faced a similar issue and if there is any solution to this problem. Is it possible to make the integration send the correct value of the custom field to the Google Sheets spreadsheet?

Thank you in advance for your help.

Best regards,

1 reply

Charie
Userlevel 3
Badge +4

Hi @frnndmntr

Thanks for reaching out to the Community!

I’m sorry that you’re having issues with you’re Zap.

Before we dig deeper into this, could you send screenshots of how you’ve configured the steps of the Zap so far? (If there’s any personal information, kindly blur them.)

That’ll help me make sure I give you the best suggestion possible.

Looking forward to your response!

Reply


Terms & Conditions