About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to setup region specific leads for agents

A
  • Anonymous
  • 0 replies

@GetUWired @christina.d 

Guy's it worked out great, thank you so much.

 

My next challenge now is to make it possible for agent to tell me wich region leads they want to receive. I will start with province. In the Netherlands we only have 12 so I think making 12 copy's of the zap and filtering on province should do it right?

 

The next step is to make it possible for agents to select different city's. The agents in my case are transport companies so in the future I want to make it possible for agent A to receive leads from:

City A to City B

City G to City P

 

Is there a easier way then to make hunders of zaps copy and filter on city?

4 replies

nicksimard
Userlevel 7
Badge +11

Hey@adaptoo!

The way I’d approach this is by using Airtable (if you’re not familiar it’s sort of a cross between a database and a spreadsheet) and let it do a lot of the work for you.

Here you can see that I have a table for agents, linking to a location in a different table (which pulls in the email address of the agents). Then I have a Leads table that uses the location to pull in the email addresses.

 

Then in a Zap I can trigger on new records being added to this Airtable and then use the email addresses in my email app (in this case Gmail):

9cfe0496fec3817ab2d1defb33c9794d.gif

 

Might something like this work in your case? Then the last part would be modifying the agent records to add or remove cities/provinces.

You’d mentioned creating 12 Zaps...no need for that :) As you can see above, you can automatically pull in the relevant email addresses when a lead has a specific location chosen.

How do your leads come to you at the moment?

A

Man guy’s you are so helpfull. @nicksimard this is a great method to get it done. But honestly I don’t even know where to start. 

 

Right now the form entry comes trough Formidable Forms (on a wordpress site). I’m using a Sendinblue account to send the mails to the agents. The agents are being selected now trough a loop with Storage and Format functions of Zapier and in between the leads that are send are being added in per row to whomever receives them in a Google Spreadsheet. 

 

I want agents to be able to select from where to where they can do transports so I can send them the right leads:

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting. 

In the screenshot you see the Regions but the Regions can be expanded and then City’s can me turned on or off.

nicksimard
Userlevel 7
Badge +11

Hey @adaptoo!

Thanks for the extra information. Hmmm...lotta moving pieces to this one. 

In order to determine who gets the lead, do they have to match BOTH the origin and destination?

So, if the form comes in and the person has chosen a route that matches this…

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting. 

 

… then they’d be sent the lead. Is that right? What is the app in the screenshot above?

A

Hi @nicksimard thats right! 

 

A transport agent can choose loading locations and unloading locations (they will communicate this by phone or form or mail and I need to configure it manually). If the lead matches the route it should be send to 5 matching agents not randomly but by order or some kind of way to evenly distribute leads to 5 agents at the time. 

 

The app above is just a screenshot from a competitor that has build a whole agent user environment so that the agents can select the routes themselves.

Im going to start with a Airtable course soon so hopefully i’ll get this done fast! Thanks so much for thinking with me.

Reply


Terms & Conditions