I have a Google Sheet with four columns: Email address, thing 1, thing 2, and thing 3.
The possible values for the “thing” fields are “Yes” and NULL (empty / no data).
Is there a way to create a Zap that periodically (say weekly) looks for rows in the table that do NOT have a “Yes” in ALL three “thing” fields and then sends an email to the address in the row(s) with a message about what’s missing? (The message would need to be verbose and not just the column heading.)
So the trigger would need to be “time” rather than creation or update of a row.
And I’d need something that translates a NULL value in, say, the thing 1 and thing 3 columns to something like, “You’re missing your widget and your doohickey” in the email body.
Is this possible via Zapier or too tricky? TIA
Best answer by XRay Tech
View original