We have connect our website form with Google sheet.
Users sometime do fill inquiry form two times.
I want to zapier to check existing email id of user in spreadsheet before creating new row.
We have connect our website form with Google sheet.
Users sometime do fill inquiry form two times.
I want to zapier to check existing email id of user in spreadsheet before creating new row.
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
Thanks in Advance!
Mye
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!
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.