I am trying to add path condition that when you find the same date in google sheets submitted from google form, it will go to path B, if not, it will go to path A. I’ve tried a lot of things but I just don’t get the results which is sending a an email. I have tested every step and everything has check mark on it.
Am I doing it right in Lookup Spreadsheet Row?
Best answer by peter.harrison
Hi
To route submissions to Path B when the same date is found in your Google Sheet, set your Path B condition to check if the “Zap Search Was Found Status” (from your Lookup Spreadsheet Row step) is true. Since your Lookup step is searching by ‘Date’, this will mean a matching date was found, so Path B will run.
For Path A, the condition is already set to “Zap Search Was Found Status” is false (no matching date found).
This setup will ensure your Zap follows the correct path based on whether the date already exists in your sheet.
Hope this helps!
Edit: It works now, however, when I had someone use the same day, it goes to path A , where it shouldn’t have since there is a duplicate date in googlesheet therefore it should go to path B
+14Hi
For us to have info, post screenshots showing how your Zap Path Filter steps are configured in EDIT mode with the field mappings visible.
+14
Based on your configured Path Filter conditions only 1 path will run each time the Zap is triggered to run.
Try turning your Zap ON and testing live, then check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and check: https://zapier.com/app/history/
How do I make the path so that when it finds the same date in the google sheets, it will go to Path B?
Hi
To route submissions to Path B when the same date is found in your Google Sheet, set your Path B condition to check if the “Zap Search Was Found Status” (from your Lookup Spreadsheet Row step) is true. Since your Lookup step is searching by ‘Date’, this will mean a matching date was found, so Path B will run.
For Path A, the condition is already set to “Zap Search Was Found Status” is false (no matching date found).
This setup will ensure your Zap follows the correct path based on whether the date already exists in your sheet.
Hope this helps!
+14
Here is your issue with the Path Filter condition…
Try using these Path Filter conditions:
+11Hi
Let us know how it went, would love to get a best answer marked here to help surface the solution to others in the Community! 🙏
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
