Skip to main content

Hi Zapier community, I would like to allocate my web form leads to different Google Sheets.

 

I have a real estate website to collect leads, and it’s connected using web hooks to Zapier. As there will be different properties and agents on my website, how can I set up the automation to send leads to different Google Sheets for the agents?

 

I’m confused by the “Filter” & “Paths” app, which app should i use to automate the tasks?

Hi @winson 

 

Read more about paths here: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

Read more about filters here: https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters

 

For your request you can use path after your triggering app, and in the Path 1 you can define which data should go to sheet 1 and in the path 2 you can define which data should go to sheet 2.


Got it. Thank you robschmidt.


@winson 

You can also explore using a Round Robin. 

some articles to get you thinking: https://www.luhhu.com/blog/how-to-create-a-round-robin-in-zapier-video 

https://zapier.com/help/doc/how-get-started-storage-zapier (search for Round Robin)