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.

I do e-Commerce and frequently have new listings to be created. I created a data entry sheet for Product Managers to fill out with data needed to create new product listings. I’ve created a column that allows the product manager to mark it as “DONE”. 

I am trying to figure out what is the best way to notify my virtual assistants that the data has been entered by the product manager and is ready to create a listing. I ideally want to use Asana as the “notifier”, but I want it to pull SKU information from the google sheet to create a new Asana task. 

So ideally I would want it to look like this, my google sheet has a column called “send to uploader”. The product manager will click from the drop down “yes”. I want the ‘yes’ or change in the column to trigger a zap to send to asana as a new task and it will pull from my google sheet the SKU and create a task on Asana that says “SKU - ready to upload”

I am getting stuck in the google sheet trigger. Does anyone know what I am doing wrong? Or have a better suggestion?

Hi @eveeeyewear 

 

If you use the Google Sheet zap with the trigger “New or Updated Spreadsheet Row” to trigger the zap.

Then have a task “Filter by Zapier”

 

Chhose your column with your yes/no value (or whatever you decide to use) and select the valid answer.

The move on to your Asana task.

The filter will only progress into Asana if the filter is true.

So you Product managers can construct the row and the zap only progresses when the mark it and ready.

David

Thanks so much for the help, David! It worked! 

Do you know how I can pull certain data from the google sheet row to input into my Asana task? 

Because right now, I have the trigger be a “new google sheet row” and then once the column with the yes/no value will trigger the Asana task. How do I have zapier pull the data from that row and put it into the new Asana task?

You’ll need to change the trigger to “New or Updated Row”

The trigger to use would be “New or Updated Spreadsheet Row”

 

On the Asana side, use “Find or Create Project” if the project has not been created or “Find or Create Task” if the project and task exists.

When you start getting into this, having a clear workflow that everyone sticks to is very helpful.

 

 

Terms & Conditions