Replaced a manual, error-prone lead collection process with a fully automated Make.com pipeline — centralising data from LinkedIn and web forms, eliminating duplicates, and delivering instant team notifications.
The agency was collecting leads from two sources — LinkedIn Lead Gen Forms and their website contact form. Both required manual CSV exports into Google Sheets. This process was slow, created duplicate entries, and meant leads sometimes sat uncontacted for days.
They needed everything centralised, instant, and automatic.
Make.com watches both LinkedIn Lead Gen Forms and the website contact form simultaneously. Any new submission triggers the workflow instantly — no manual checking required.
Before writing anything to Sheets, the workflow checks if the email already exists. Duplicates are flagged and skipped automatically — keeping the database clean.
New leads are written to a structured Google Sheet with source tracking — the team can see whether a lead came from LinkedIn or the website, and when.
A notification fires immediately when a new lead is logged — so the team can follow up within minutes, not days.
No more manual exports. The team stopped touching CSVs entirely. Every lead flows in automatically from the moment it's submitted.
Clean, duplicate-free data from day one — no more spending time cleaning the spreadsheet before using it.
Faster follow-up. With instant notifications, the agency was able to respond to new leads significantly faster — improving conversion rate.
I build automated lead pipelines that keep your team focused on selling, not data entry.