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 need help figuring out how to use filters in Zapier.
I have a master spreadsheet of leads that I will update daily. I will copy and paste those leads in the same format every day. I'm trying to make a zap that looks at new rows created then looks up previous rows by a column called "Project Name". If project name does not already exist then I want it to continue forward with the zap and write a draft email. The zap works perfectly however the filter is not filtering out duplicates.  Here is what I have. How can I change this?
 


 

Hey ​@Aaron White,

I think it’s because of the logic of the Lookup Spreadsheet Row as if it doesn’t find anything it will return no data. Try doesn’t exist filter to check for duplicates. Also map the the value from Lookup Spreadsheet Row action.

 

Hope it helps!

Terms & ConditionsAccessibility statement