Built a no-code automation that handles the full cold outreach pipeline for local businesses.
The flow:
Google Maps scrape → filter leads with emails → deduplicate → add to sheet → send personalised email → mark as sent
Tools used:
Make.com (workflow automation)
Apify (Google Maps scraper)
Google Sheets (lead database)
Gmail (email sending)
The interesting part is the duplicate check — before adding any lead, it searches column B of the sheet for that email. If it already exists, the whole branch is skipped. Keeps the sheet clean across multiple runs.
The email is personalised with the scraped business name using {{32.title}} from the Iterator module output.
I released it as a ready-to-import blueprint with docs.
Top comments (0)