How to set up path conditions in Google Sheets for form submissions
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?
Page 1 / 1
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
Hi @venger07
For us to have info, post screenshots showing how your Zap Path Filter steps are configured in EDIT mode with the field mappings visible.
@venger07
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 @venger07,
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!
@venger07
Here is your issue with the Path Filter condition…
Try using these Path Filter conditions:
l2. Zap Search Was Found Status] (Boolean) Is True
l2. Zap Search Was Found Status] (Boolean) Is False
Hi @venger07—just checking in to make sure you’re all set here. Did Peter and Troy’s replies help to get things solved?
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!