Pete Bowen's site

How to get leads from different sources into your CRM automatically

I’ve got a client in the motor trade who gets about 2 000 leads a month from 22 different online sources:

As you can imagine, keeping track is hard. He had a gut feel that their online advertising was producing sales. But he couldn't tell exactly where each sale came from. He didn't know if Facebook leads were profitable. He didn't know if it was worth investing more in Google or if he should reduce the budgets. He couldn't tell if the suppliers were sending as many leads as they promised.

This wasn't from a lack of trying...

His assistant spent the first two weeks of every month prising last month's results from the sales managers. Then she typed all 2 000 leads into a huge spreadsheet. By the end of the month he had a rough idea of how profitable each lead source had been the previous month.

But, trying to optimise your ad budget from stale shaky data is only slightly better than guessing.

A few months ago he hired me to build a custom sales engine to give him the data he needs to make the right decisions about his advertising.

The first problem we faced was getting the leads into the sales engine.

Each lead source delivers the leads by email. Obviously we could have had someone copy and paste from the lead emails into the sales engine. But, with a few thousand leads a month that was going to be a boring job, and there would inevitably be mistakes.

Transfer leads from your inbox to your CRM without expensive computer code or human intervention.

Enter Zapier.

Zapier is a service that lets you connect web applications and automate workflow. It can slurp information like name, email address, phone number etc from lead delivery emails and pass it to your lead management system.

Here's a high-level view of how to use Zapier to put your leads into your lead management system.

  1. Set up an email address for each lead source in Zapier’s email parser. One email address for your website leads, another email address for your Facebook leads etc. You need an address for each source because the emails are different from each source.

  2. Tell the lead source to send your leads to the Zapier email address. If they can't send to Zapier you can set up a rule in your inbox to forward the lead emails to the right Zapier email address.

  3. Tell Zapier what information to extract from the email.

  4. Tell Zapier how to send that to your lead management system.

Once it's set up it'll run automatically and new leads will appear in your lead management system as if by magic.

Here's an example.

The screenshot below shows a MarketingMotor lead email in my regular inbox.

The next screenshot is what Zapier shows me the first time I get an email.

You’ll see I’ve highlighted the name, email and phone number. That’s what I want Zapier to extract.

You only have to do this once. After that Zapier will extract the name, email and phone number from new messages as they arrive. Then it'll send that information to the lead management system without any work on my part.

I found a video on YouTube that illustrates this well.

Need some help with this?

I offer 1-to-1 mentoring and consulting. You’ll get help, advice, support and answers without having to commit to a long-term contract. Details here.

Want to increase your conversion rate?
I’ve seen conversion rates double, triple and even 10X after a few quick and easy changes to the enquiry form. Subscribe now, and I'll send you a free copy of my in-depth ebook High-Converting Enquiry Forms.
You're already paying for clicks. Now turn them into conversions. Privacy policy. Unsubscribe at any time.

Related articles

Why we lost sales. Losing potential sales always hurts. But, if you know why you lost the sale you can make changes that'll help you win more sales down the line.

"Forget about reducing the CPC" In money terms my client paid Google about $1 400 per client he contracted with. He could live with spending $500 per new client. Here's how we're going to hit that target.

What to do if leads don't answer when you call. Last month a client got 4 150 leads but their sales team was unable to contact 1 277. Here's how we're going to reduce the number of non-contacted leads and help the client make more sales.

An easier way to sell services. Bigger value projects take a lot of work to sell. You have to have the discovery calls, meeting notes, customised proposals and quotes. And, you often need several follow-up meetings. There is another way.

Why I don't just delete fake leads from my inbox If the only thing you do with fake leads from Google Ads is delete the lead delivery email you risk getting swamped by fake leads. Here's why and what to do to improve lead quality.

Why I never use reCAPTCHA on Google Ads landing pages Nobody wants an inbox full of spam, but preventing fake leads from submitting your form is wrong if you’re paying for online advertising. Here's why...

What to say on the first call to an internet lead. Calling leads back fast is the best way to ensure you get a sale if there is one going. Here's what to say on that call.

More sales are lost because of inertia than price. Most of your potential clients want what you sell but haven't handed over the money because they've run out of steam. Here's how to keep them moving towards a sale.

How to win more quotes without lowering your prices In a perfect world you'd win every quote but the reality is that most quotes don't turn into sales. It is possible to turn a lot more quotes into sales without lowering prices. Here's one way.

You could be shooting yourself in the foot if you send quotes in Excel or Word. There is a problem with emailing quotes in Word or Excel: There is no guarantee that the quote will look like it should.

Is your sales process chaotic? I was surprised when three small business owners used the same word - chaos- to describe how they currently handle leads.

The weak link that might be causing you to lose leads Some of your leads never make it from your website to your inbox. And, there is a good chance you don't know about the missing leads.

Leads ghosting you? A business owner complained that his leads were ghosting (ignoring) him after initially showing interest. As we worked together we uncovered a mismatch between lead temperature and his response.

60 leads a week and no sales Their first instinct was to change the adverts. It sort of makes sense. Adverts aren’t producing sales so the adverts must be broken. Fix the adverts and you'll get more sales. But, they could change their ads, spend a load more money and get no sales. This is because the adverts might not be the real problem

Google Ads delivers leads not sales What’s the most important problem in your industry? In my industry the most important problem is that Google Ads delivers leads but doesn’t deliver sales. Here's what I've been doing about that...