I created a cold email sender. I want to avoid duplicate emails

[Mike_Stohler]

What is your goal?

I’ve created a cold email system. I’ve linked the second module. I’m scraping 20 Google Map companies a day, putting them into a spreadsheet, and sending out an email. I don’t want to scrape duplicates, but if I do, I want to set up a filter or something that will read the spreadsheet and if title or email exists, it won’t send out an emial to that company. Any suggestions?

What is the problem & what have you tried?

The issue is I don’t know if I need a filter or a variable

Create public scenario page

Cold email system part 2/2 - Make.com Automation Scenario

Screenshots (scenario flow, module settings, errors)

[damato]

Hi @Mike_Stohler

Did you try reading all the rows and aggregating the results? Something like this post, but with Google sheets rows, instead of emails:

Searching Gmail, but removing duplicates

What is your goal? I am trying to automate Unsubscribes in my Gmail. I have a scenario that starts by searching for emails that are unsubscribes from the last week, which then modifies their contact. The problem is, often times people will click unsubscribe multiple times (no idea why), which means there are multiple bundles with the same email address. How can I make sure I am not passing the same email address throughout my entire scenario multiple times? What is the pro…

@damato

[Mike_Stohler]

Great advice. I could do what you said and then send the emails once I’ve aggregated the results.

[Stoyan_Vatov]

Hey there,

Search the Google sheet first to check if the entry exists before adding a new one. Add a filter after the search to block the rest of the scenario if it found a match. Then duplicates will not be processed at all.