Question

Round Robin for Facebook Leads to two different Google Sheets


Hi Guys,

I need to create the following zap and need some help in doing so:

  1. Lead from Facebook
  2. Sends lead to Google Sheet A
  3. Sends next lead to Google Sheet B
  4. Sends next lead to Google Sheet A
  5. Sends next lead to Google Sheet B
  6. And so on. 

Your help will be super helpful. 

Thanks!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Badge +4

Hi @dean.lederle,

One way of solving this would be to use a gsheet that had a number in one of the cells, either a 1 or a 2. In the automation, it would look up what that value of that number was, and based on if it was a 1 or a 2, it would run a different path in your automation. Then in that path, add a step to change the value from either a 1 or a 2 so that when the zap is triggered again, it will go down the other path.

 

If you do not have paths available for your zapier plan, you can always use two separate zaps, and have a filter step as the third step of the automation to only filter based on the gsheet number look up.

Hope this helps!
Happy zapping 👍🤓

Thanks so much, this does make sense. 

You wouldn’t happen to have a tutorial on setting up the paths would you?

Userlevel 7
Badge +14

@dean.lederle 

Here’s an article about Paths: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

You can also use the Formatter > Utilities > Pick From List (Choose Random) to achieve the same results instead of a GSheet: https://zapier.com/help/doc/how-use-formatter-functions#using-pick-from-list