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.
Trigger - Call received
Lookup Spreadsheet Row in Google Sheets
If Row exists - terminate
If Row does not exist
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?
Best answer by kenserView original