I’m using Zapier to manage and email clients collected from a form response sheet. I want to trigger 1 of 4 types of emails by adding a conditional selection in a column.
I was able to make multiple zaps referencing a single sheet, and implement the trigger of “New or Updated Spreadsheet Row” for an update to a specific column.
The issue I’m running in to is that if I update one row in a specific column, it is sending 4 emails to the email connected to the row.
I set up my sheet to include a column for each of the 4 options like below:
name | email | 2-hour | half day | full day | waitlist
————————————————————————
row 1 | email | | x | |
row 2| email | x | | |
row 3| email | | | x |
I want to offer a person in row 3 a full day booking (1 of 4 options: 2-hour, half day, full day, waitlist)
I manually add “x” to row 3 column “full day” - this should technically trigger the “full day” email to the single customer email for the person in row 3.
The issue I’m having is that if I add an “x” to any row, any column, each version of the email is sent to each row again.
Best answer by frickinprofile
View original
