Good morning / afternoon.
I am trying to send notifications depending of the type of text that appears on a cell in my Google SpreadSheet.
(For example: To every row that has the text "1 EN DIA Y HORA" in my column E)
I have a custom bot created with the "Event Type = Data Change", that realizes the action in "All changes", to my table of my SpreadSheet, and with that condition:
In my action, i have this (CORREO is the header of my e-mail column):
And also i have this complement in my Google SpreadSheet:
But it doesn't matter what data appears on the cells of my "E" column, that any notification is sent.
Could you help me, please?
Thank you so much!
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |