How to split leads from Zoho Forms into 2 Google Sheets?

  • 9 April 2022
  • 1 reply

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


first lead to A sheet

2nd lead to B sheet

3rd lead to A sheet and so on…

Thank you in advance..



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

1 reply

Userlevel 7
Badge +14

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)