Filtering Duplicates from One Sheet to the Next

[techstackmatt]

Hello,

I apologize as this is a very basic questions but I am new to Make and having trouble. Didn’t see anything on the forums that fit this scenario.

I am trying to filter out duplicate leads using Google Sheets. What I have come up with is this:
3 Distinct Google Sheets, “Initial Leads,” “Master Leads,” and “Ready Leads.”

What I would like to do is input my initial leads into the first sheet and check them against “master leads” for duplicates. The data that has no duplicates is then added as a row to “Master Leads” and “Ready Leads.” Then I would clear the data from initial leads until ready to go again.

My issue is with the route/filter. It is currently checking each email against every email instead of just checking for duplicates. For example, if matt@example.com is present in both sheets, it will reject matt@example.com but then pair it against the next email, let’s say matthew@example.com. Since this is not a match it will successfully route it and ends up adding dozens of duplicates. I’m assuming I’ve set this up wrong but I can’t figure out the right filter criteria. Does anyone have advice, or is there an even simpler way to do this?

Thank you in advance for the help, I really appreciate it. Obviously I am a beginner but this is all super interesting to me, albeit challenging.

[Probotic_Solutions]

Hi @techstackmatt,

Instead of using a route/filter, a better approach would be to use “filter in Search Rows”, as it only returns a result if there’s an exact match and otherwise, it comes back empty. (attached screenshot)

From there, you can route based on the “Total Number of Bundles”:

• If 1 match is found (i.e., the email exists in “Master Leads”), you can skip or update accordingly.
• If no match is found, go ahead and create the entry in both “Master Leads” and “Ready Leads”.

If this helps, please consider marking it as the solution