I want to exclude a DealID from a zap when it's found in a Google sheet.
Case is:
I have google sheet with DealID's that have already sent an e-mail. And if i receive an new dealID i want to check if the customer didn't get that e-mail. So if DealID (Value) is on the google sheet, it needs to stop.
What i did I checked of it’s possible with lookup of google sheet, but that errored, what is logical because he should not find anything.
With the formatatter ultilities i couldn’t worked it out also.
Does someone have an solution for me?
Best answer by PaulKortman
@rikmaris I think that’s still possible to do with a filter step.
The problem is when the Google Sheets search step doesn’t find a result it will error UNLESS you check the box to create a row if it doesn’t exist.
So you have multiple ways of solving this, I’ll try to present the most simplest way to solve it. Copying your steps from above and numbering them (filters are steps too!)
Step 1: receive an webhook with an Deal ID
Step 2: Check in Google Sheet if Deal ID exists - with the “Create Google Spreadsheets Row if it doesn’t exist yet?”
You can put the Deal ID, but you don’t have to put anything and it will create an empty row
The Cool part about it is when it doesn’t find the row and creates a row, it gives you a true/false statement that you can filter off of:
If not on the list: Continu; If well on the list: Stop zap. Simply set your filter to check _zap_data_was_found if it’s false. Like this:
Step 3 (now step 4): Send e-mail
Step 4(now step 5): Add deal id to Google Sheet document -- In this case you might want to modify the row from step 2 (which is an empty row) just use the output of step 2 (ID) as the Row and It’ll update the empty row so you don’t have too many empty rows. ex:
Let us know how it goes and if that will work for you!
It's not that simple, because it are deal id's. That are numbers. If an number is on that list you can't go continue, but you can't do an search because it isn’t there.
@rikmaris I think that’s still possible to do with a filter step.
The problem is when the Google Sheets search step doesn’t find a result it will error UNLESS you check the box to create a row if it doesn’t exist.
So you have multiple ways of solving this, I’ll try to present the most simplest way to solve it. Copying your steps from above and numbering them (filters are steps too!)
Step 1: receive an webhook with an Deal ID
Step 2: Check in Google Sheet if Deal ID exists - with the “Create Google Spreadsheets Row if it doesn’t exist yet?”
You can put the Deal ID, but you don’t have to put anything and it will create an empty row
The Cool part about it is when it doesn’t find the row and creates a row, it gives you a true/false statement that you can filter off of:
If not on the list: Continu; If well on the list: Stop zap. Simply set your filter to check _zap_data_was_found if it’s false. Like this:
Step 3 (now step 4): Send e-mail
Step 4(now step 5): Add deal id to Google Sheet document -- In this case you might want to modify the row from step 2 (which is an empty row) just use the output of step 2 (ID) as the Row and It’ll update the empty row so you don’t have too many empty rows. ex:
Let us know how it goes and if that will work for you!
