Hi there! A simple way to do this is to replace your “Create row” action with a “Lookup spreadsheet row” action (screenshot).

Set that step to search by email address, and then check the box at the bottom to create a new row if none is found (screenshot).

If one is found, nothing will happen. But if one isn’t found, a new row will be created (like you have now). Hope that helps!

Solved. Thanks a ton.

Hi @Noah Manger, just saw this thread because my client encountered the same error, he encountered a duplicate entry ( twice last March but not yet since then and he didn’t change anything on the set-up), he asked me to figure it out, but when I checked the Zap flow it was set up correctly as you suggested here. Do you think there’s another cause of duplicate entry?

Thanks in Advance!

Mye

@Mye very strange. I would expect the “Lookup spreadsheet row” to not throw that error and instead just create a new row. I’d recommend reaching out to our Support Team with a link to the Zap and they can take a look: zapier.com/app/contact-us

Sorry I can’t be more help, but if you get an answer that works, I recommend sharing it back here so others can benefit!

@Noah Manger, thank you so much for your reply. I asked my client to let me monitor the entry if we will still get a duplicate entry since it's been already two months when we got a duplicate. If we still get a duplicate that was the time that I will reach out to the Zapier Support team. And yes, will definitely share here the answer when that happens.

Thank you!