How do I create an Asana task when a specific cell in Google Sheets is updated?

Hey there, @Islamic Warnings! Thanks for reaching out in community. 🤗
Since Zapier is a self-serve product we don’t offer implementation services currently but totally a valid question!

If you are interested in someone taking this on for you, as Brem mentioned earlier, I might recommend hiring a Zapier Expert!

Looking at your screenshots though as you mentioned the trigger column is “Video Check”

And the filter is set for a “Video Upload” column
 

These fields should match for whichever column you’d like it to monitor for the word “Go”. In addition, you’ll want to check that the sample you’re pulling in to test has that field filled out. Once you’ve confirmed this you can refresh your sample and test again to make sure it creates the Asana task.

It’s worth mentioning that Google Sheets is a little finicky when it comes to formatting. So it might be worth checking your spreadsheet to make sure it’s formatted to work with Zapier.

I hope some of this helps! 🧡

could you make a zap of my google sheet and show me how to do that?

Hi ken,

just now I went through the steps but still no success. I see at the filter I see video upload sheet instead of video check. Is this correct?
I cannot find video check

Hey there @Islamic Warnings,

I’m jumping in to see if I can help.

Could you try changing the trigger to "New or Updated Spreadsheet Row" (without the Team Drive)? And make sure to select the right "Trigger Column" on the trigger step.

Also, here's a helpful article that could shed some light on why your Zap might not be triggering: https://help.zapier.com/hc/en-us/articles/8495995099533-Common-Problems-with-Google-Sheets-on-Zapier.

Please give that a try, and keep us posted.

Thanks! 😊

what is the difference when choosing spreadsheet a,b,c?

Starting to feel a little sad now that it still won't work out. Pretty behind with my work now

Hi @Islamic Warnings 

If you have any other questions, please feel free to continue the conversation with our Support Team. They can dig into the error logs of your Zap with you to look for the cause of the errors.

@Brem  it's been half an hour now but still nothing

Hi @Islamic Warnings 

Yes, that’s correct!

my zapier plan is starter.

i see now the upload time is 15 min.
Does that mean it will only be visible in Asana after 15 min?

Hi @Islamic Warnings 

What is your Zapier plan?

You can check the update time of the Zapier plans in this link: https://zapier.com/app/pricing.

Hi Brem,

when I write GO! in my sheet nothing happens in asana.

it seems like the data is not arriving in asana.
How long does it take for it to show up in asana?

Hi @Islamic Warnings 

Welcome to the Community! Thanks for your interest in Zapier.

I can see that the Support Team replied to your ticket, and you’re in conversation with them. This was the last reply:

Upon checking the Zap, it seems that you have mapped all the necessary fields correctly. Could you please let me know which part is not working? Also, I'm sorry to say this but while we do not have an internal service for building custom Zaps, we do have a Zapier Experts program where you can get in touch with someone who can help with setup:

https://zapier.com/experts/

In our Community, we have a specific forum called "Hire a Pro" where you can hire a freelancer, consultant, or agency to help you build workflows and systematize your processes. You can find that forum here:

https://community.zapier.com/hire-a-pro-12

In this case, it will be best to keep the conversation going over with them.