Skip to main content

Hi.. May I know if there’s a way to split leads from zoho form into 2 different sheets by rotation.

ex

first lead to A sheet

2nd lead to B sheet

3rd lead to A sheet and so on…

Thank you in advance..

 

 

Hi @Haslan 

Good question.

Try this…

Zap Steps

  1. Trigger: Zoho Forms - New Entry
  2. Action: Storage - Get Value
  3. Action: Paths
  4. Action: Path A - Filter (storage value exactly matches A)
  5. Action: Path A - GSheet - Create Row
  6. Action: Path A - Storage - Set Value (set to B)
  7. Action: Path B - Filter (storage value exactly matches B)
  8. Action: Path B - GSheet - Create Row
  9. Action: Path B - Storage - Set Value (set to A)
Terms & Conditions