How can i send a notification when data is changed on Sheet?

Good morning / afternoon.

I am trying to send notifications depending of the type of text that appears on a cell in my Google SpreadSheet.

image.png (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:

ITClarel_0-1672918098488.png

 

In my action, i have this (CORREO is the header of my e-mail column):

ITClarel_1-1672918181562.png

And also i have this complement in my Google SpreadSheet:

ITClarel_2-1672918397795.png

 

 

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!

 

 

0 7 2,439
7 REPLIES 7
Top Labels in this Space