I am running a zap which triggers when a catch a hook is received.
One the webhook is received, the next step is to search a google sheet for a Yes value and return a number in a column. Following this, the next step is to mark that Yes as No.
After this, it sends a webhook to passkit to create a member.
It all works fine except for when we have an influx of people signing up… We have seen multiple people signing up at the same time and getting the same value in google sheets as there hasn’t been enough time to update the value to No. This then causes the passkit step to fail as the member already exists.
I would love to be able to rerun the search steps if it fails BUT those steps were in theory, completed.
Is there a way to reun or loop back to that if there is an error OR is there a way I can provide a list of predetermined codes to use.