Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Distribute Facebook Lead Ads to different Excel spreadsheets

D

Hello, im using Zapier for Facebook Lead Ads → Excel.
Company have now many branches, with different budget. I need to manage leads in better way. So here is what i need:
1. Warsaw - Budget 300$
2. London - Budget 500$
3. Berlin - Budget 100$

I need from zapier to manage leads in way where i can control how many leads will go to Warsaw, London, and Berlin. So it should looks like this:
Facebook generated 9 leads:
3 Leads are going to Warsaw excel/google sheets.
5 Leads are going to London excel/google sheets.
1 Lead are going to Berlin excel/google sheets.

I just cannot figure how i can do this…

Is there any chance i can do this with Zapier?


 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Troy Tessalone
Forum|alt.badge.img+14

Hi @DominikC 

You can add a Filter step to the Zaps: https://zapier.com/apps/filter/help

 

Zap Steps

  1. Trigger: FB Lead Ads - New Lead Ad
  2. Action: Filter
    1. Condition: City = Berlin (example)
  3. Action: GSheets - Create Row
    1. GSheet: Berlin
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D
Troy Tessalone wrote:

Hi @DominikC 

You can add a Filter step to the Zaps: https://zapier.com/apps/filter/help

 

Zap Steps

  1. Trigger: FB Lead Ads - New Lead Ad
  2. Action: Filter
    1. Condition: City = Berlin (example)
  3. Action: GSheets - Create Row
    1. GSheet: Berlin

Yea but Facebook Campaign is set Worldwide so i can’t use filter Berlin, because there is no Berlin or any city in FB Lead Ads...

Troy Tessalone
Forum|alt.badge.img+14

@DominikC 

There needs to be some sort of identifier in order to do Filtering/Routing to the correct GSheets.

Otherise, consider configuring 1 FB Lead Ad Form per location, then you can have a 1:1 relationship per FB Lead Ad Form to GSheet.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions