Hi,
I am currently Zapping from Gravity Forms to Google sheets. The Zap has various filters and a lookup.
Now I would like to alternate the new entries between 2 sheets so I can split the leads between two teams.
I would like to know:
- If this at all is possible
- Since the lookup is built to avoid duplicate entries, the Zap would have to lookup both sheets to see if the value exists on either of them and then post the new entry on the sheet that didn’t receive the previous entry.
Thanks in advance