Halt Zap if Row is found.

Question

I have a zap that sends an automated text if someone calls but does not leave a message. Sort of a “Sorry we missed your call ...” message

Sometimes people call/hang-up/call again and I don’t want to be a pest by sending them the automated text each time.

My thought was to create a google sheet w/ a log of the phone numbers that have been texted, then check that sheet and only continue if the number is not found.

So …
Trigger - Call received
Lookup Spreadsheet Row in Google Sheets
If Row exists - terminate

If Row does not exist
Send Text
Add Row to Spreadsheet with phone #

However, this doesn’t seem to work. If the row doesn’t exist, it terminates. Any thoughts on how to accomplish this?

kenser · Accepted Answer

The problem was it was stopping execution totally if no row was found … so it wouldn’t have gone to the filter step.

I figured out a work around.

Trigger - Call received
Lookup Spreadsheet Row in Google Sheets
If Row does not exist - create it and set count (column) to 1
If Row exists - increment count

Filter If Count =1 Send Text

ikbelkirasan · Answer

@kenserTry adding a filter step right after the step that searches for a row in the spreadsheet. The filter step should check and let the zap continue running only ifthe spreadsheet stepoutputdoesn’t have aphone number.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded