Hello, currently I am transferring leads from Perspective to Google Sheets using the Zap "Create Spreadsheet Row in Google Sheets" and then sending them to my clients using the Zap "Send Outbound Email in Email by Zapier". I have the issue that sometimes people sign up twice, and I don't want to create a new spreadsheet row or send an email to my clients for the duplicate entries. How can I set it up so that the Google Sheet is first checked to see if the email address already exists, and if so, stop the process at that point? I have already looked into deduplication, but I find too little information to implement it correctly. I would appreciate a guide on how to do this. Thank you very much.
How to prevent duplicate entries from being added to Google Sheets and sent via Email by Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 1
Hi
To achieve that you need a couple of things to change in this automation
- Change the trigger. Instead of using “When a new spreadsheet row is added to google sheet” to the trigger where people are submitting the form through which this google sheet is populated
- Then add a step to “Lookup spreadsheet row” This is an amazing function that looks up for a certain value in a column and returns the complete row when match is found. If no match is found, it adds the data in the spreadsheet
- Then from there, using Zapier path to check if an existing row was returned or new data was created
- In case existing row was returned, you don’t need to generate an email
- In case of new row was added, then generate an email to your client.
Happy to help. Thanks
Hi
thank you very much for the support. The Zap "Lookup Spreadsheet Row in Google Sheets" now works, and no additional row is generated when an email address already exists in it. However, the next Zap "Send Outbound Email in Email by Zapier" is still triggered regardless. Is there a solution for this?
Userlevel 1
For the check, add a Path step in between and check the trigger’s response. There might be a variable in its output that will tell whether a new row was created or not. Define that condition in the “Path” step’s filters (there will be 2 paths).
one path will generate an email and another will do nothing.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.