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?
Question
Distribute Facebook Lead Ads to different Excel spreadsheets
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31481 replies
Hi
You can add a Filter step to the Zaps: https://zapier.com/apps/filter/help
Zap Steps
- Trigger: FB Lead Ads - New Lead Ad
- Action: Filter
- Condition: City = Berlin (example)
- Action: GSheets - Create Row
- GSheet: Berlin
Troy Tessalone wrote:
Hi
You can add a Filter step to the Zaps: https://zapier.com/apps/filter/help
Zap Steps
- Trigger: FB Lead Ads - New Lead Ad
- Action: Filter
- Condition: City = Berlin (example)
- Action: GSheets - Create Row
- 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...
+14- Zapier Expert
- 31481 replies
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.