Lead-to-CRM automation — how to connect ads, forms and sales

1. Lead source

Website form, Facebook Lead Ads, Instagram Lead Ads, Google Ads landing page, trade show form, manual entry.

2. Automation platform

Make.com, Zapier or n8n captures the lead the moment it's created and processes the data.

3. Business logic

The system checks: does this contact already exist in CRM (deduplication)? Which sales rep to assign? What status to set? What source to tag?

4. CRM

Contact and deal appear in the system with full data, assigned to the right person, with the correct source.

5. Notification

Sales rep gets an SMS, email or push notification: "New lead from Facebook Ads, John Smith, interested in offer X."

6. Customer confirmation

Automatic email or SMS: "Thank you for reaching out, we'll contact you within 30 minutes."

1. Facebook and Instagram Lead Ads

The most popular lead source for SMBs. The customer clicks an ad, fills out a native form inside Facebook or Instagram and submits data — without leaving the platform.

Native form = higher conversion rate (data auto-filled from profile), but no UTM (customer doesn't go through the website). You identify the lead source via the integration channel and campaign metadata.

Make.com and Zapier have native triggers for Facebook Lead Ads. The lead enters the automation the moment the form is submitted.

2. Website form

Customer fills out a contact form, quote request or newsletter signup. Data goes to the form system (Fillout, Typeform, Google Forms, built-in CMS form) and from there to the automation.

Here UTM works — if the customer arrived from an ad, the URL contains utm_source, utm_medium, utm_campaign parameters. The automation platform reads them and passes them to CRM as the lead source.

3. Google Ads landing page

A dedicated page for a specific campaign. Works identically to a website form, but the landing page is optimized for conversion. UTM from Google Ads campaigns allows you to precisely tag which campaign and keyword the lead came from.

4. Offline leads (phone, referrals, trade shows)

Not every lead comes online. A sales rep returns from a trade show with 30 business cards. Someone calls from a referral. A business partner forwards a contact via email.

These leads can also be pulled into automation: a simple internal form (e.g., in Fillout or Google Forms) used only by the team. The sales rep enters data, selects a source ("trade show," "referral," "phone") — the rest works automatically.

CRMs with native Make.com and Zapier integration

CRMs with Zapier integration

CRMs with API integration (HTTP)

Enterprise CRMs

Salesforce, Microsoft Dynamics 365 — native integrations with Make.com and Zapier, but typically implemented by dedicated partners. Usually too expensive for SMB budgets.

What about Airtable?

Airtable isn't a CRM, but many SMBs use it as a lightweight CRM — especially when they need flexibility that a rigid traditional CRM structure doesn't provide. Native modules in Make.com and Zapier, full control over data structure. Good starting solution, but won't replace a full CRM with 10+ sales reps.

Leads from native forms (Facebook/Instagram Lead Ads)

The customer doesn't go through the website — there's no UTM. You identify the source by which trigger fired. Facebook Lead Ads API returns metadata with each lead: platform (Facebook vs Instagram), campaign name, ad set, form. You capture this data in Make.com/Zapier and map it to the "source" field in CRM.

Important: most CRMs (including Berg System, Pipedrive, HubSpot) have a "source/origin" field based on a dictionary — a predefined list of values. You need to create a mapping: platform=facebook → CRM dictionary "Facebook Ads."

Leads from website forms (with UTM)

Customer clicked a Google Ads ad with UTM in the link, landed on the page, filled out a form. The form system captures utm_source, utm_medium, utm_campaign parameters from the URL and passes them along with the lead data to the automation. Make.com reads UTM and maps it to the CRM dictionary value: utm_source=google → "Google Ads."

Offline leads

Source is set manually — the sales rep selects from a list ("trade show," "referral," "phone") in the internal form.

Deduplication: what if the contact already exists?

Customer John Smith submitted data a month ago via the website form. Now he clicked a Facebook ad and submitted data again. Without deduplication you have two contacts in CRM — chaos.

Solution: automation first searches for a contact by email address. If found — adds a new deal to the existing contact. If not — creates a new one. In Zapier this is a standard pattern (Find or Create Contact → Create Deal). In Make.com you build it via Search module + Router.

When does it pay off?

Example: a company spends €1,200/month on FB ads. Generates 100 leads per month. Without automation, 10% of leads are lost (not entered into CRM, late contact). That's 10 leads × average deal value of €700 = €7,000 in potential revenue lost.

Even if only 1 of those 10 leads converts — the €1,000 implementation pays for itself in the first month.

You have fewer than 10 leads per month

Manual CRM entry takes 20 minutes a day. Automation is overkill. Better to invest in better ads.

You don't have a CRM

There's nothing to automate if leads end up in Excel anyway. First implement a CRM (even free HubSpot or Airtable), then automate.

You don't have a repeatable sales process

If every lead is handled differently, automation won't help. First establish the process, then automate it.

Your ads aren't generating leads

If the problem is in campaigns (bad targeting, bad landing page), CRM automation won't improve conversion. Fix the source first.

1. No contact deduplication

The biggest CRM mess happens when the same customer is entered 3 times — from a form, from FB Lead Ads and manually by a sales rep. Email deduplication is the absolute minimum for every implementation.

2. Lead enters CRM but nobody gets notified

A contact in the system isn't enough. The sales rep needs to know about a new lead — immediately. SMS or push notification is a must-have, especially for ad leads.

3. No lead source tagging

A month later the boss asks: "Which ads bring customers?" If CRM doesn't have a "source" field filled automatically — you can't answer. Source mapping is the foundation of campaign ROI reporting.

4. Automation without an established sales process

"Lead enters CRM — then what?" If you don't know who calls, when, and what they say — automation will deliver leads faster, but conversion won't improve.

5. Testing on production data

A test lead "aaa@test.com" goes to the real CRM, sales rep calls a fake number. Always test on a separate pipeline/stage in CRM, not on production.

Does lead automation work with my CRM?

How many leads per month do I need for automation to make sense?

How does CRM know which ad a lead came from?

What if the same customer fills out a form twice?

How much does lead-to-CRM automation cost?

Can I build lead-to-CRM automation myself?