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

Asana custom fields not showing in "Insert Data" section when trying to map in Google Sheet columns

  • 27 August 2023
  • 6 replies
  • 89 views
camcooper

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.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
camcooper

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?

Troy Tessalone
Userlevel 7
Badge +14

@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 - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
camcooper

@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?

Troy Tessalone
Userlevel 7
Badge +14

@camcooper 

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Dconnors

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

Reply


Terms & Conditions