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 to Google Sheets issues

  • 19 December 2022
  • 1 reply
  • 56 views
W

Hi everyone.

 

I’m trying to track Asana tasks and their status in a Google Sheets document. I have set up two Zaps: The first Zap will create a new row in Google Sheets once a task in Asana has been created, the second Zap will update the row in Google Sheets (via Lookup spreadsheet rows) when there are changes to the Asana task. Setting up the Zaps has been successful and the first Zap (creating the new row in Google Sheets for a new Asana task ) works just fine, but the second Zap (data transfer from Asana to Google Sheets) has been very unreliable - most of the fields of the Asana tasks (including native Asana fields such as Due Date as well as custom fields with text, numbers or dates) will not be transferred and the respective cell in Google Sheets will be empty. This doesn’t apply to all fields as some are transferred successfully, so I’m assuming the Lookup Row functions is working. The Zaps are run successfully but I receive a ‘fields no value’ message for the fields that end up empty.

 

Any ideas as to what causes the unreliability and how to fix it?

 

Thanks.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Danvers
Userlevel 7
Badge +12

Hi @wimac4, welcome to the Community!

Hmm, this could be caused by different things so we’ll need to dig a bit more to see if we can figure it out. 

First, go to your Zap history and click into a Zap run for the Zap. For the update row step, take a look at the Data in and Data out - what can you see for the fields that aren’t coming through? Could you share a screenshot of them if you need some help interpreting them? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

Also, is the Zap always missing the same fields every time the Zap runs or are some Zap runs successfully sending all of the information?

Thanks!

Terms & Conditions