Skip to main content

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!

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?


@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