Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hello!

 

I’m trying to create a zap where when a new Asana task is inputed in a particular section it will be added to a Google Sheet tab. We have quite a few custom fields in Asana but when I try to search for them in the Google Sheets action, it only shows things like “Data Custom Fields Enum Value Name”, “Data Custom Fields Display Value”, etc.

Is it typical for Zapier not having the ability to identify/pull the exact custom field?

 

I don’t think I’ll be able to share images as the data is confidential but happy to provide more context.

Hi @camcooper 

Good question.

I believe the Asana Custom Fields get treated as an array of objects.

e.g. “Data Custom Fields Display Value” would contain all the Display Values for the Custom Fields.

Usually that means Formatter or Code steps have to be used to isolate the desired custom field value.

Hi @Troy Tessalone thank you for the info! Let’s say a field name was something like Item_ID if i used Formatter to parse that field name an inputed to a particular column, would Zapier know to pull anything under that field name since the Formatter really only parsed out the text?

@camcooper 

You have to essentially combine 2 arrays Item ID and Item Value to create a new variable for Item ID which has a value to then map into the following Zap steps.

 

e.g. Custom Field arrays as pre-parsed by Zapier.

Label: A,B,C

Value: 1,2,3

 

If you wanted Label A that has a value of 1.

Then logic needs to be applied to create a new variable called A that has a value of 1.

@Troy Tessalone sorry for the delay on this! Is there any example Zaps you may be able to share that could help get me started with the configurations?

@camcooper 

This can be done with a Code step which is an advanced approach.

Hi @camcooper Did you figure out a workaround for this?

Reply


Terms & Conditions