Hey @chevre, welcome to the Community!

I did some checking and it seems we’re not able to detect when a cell changes colour. There is an existing feature request for the ability to trigger a Zap when the styling/colour of a row’s cells change so I’ve added your vote to that. This will allow us to let you know as soon as that functionality is added. We’ll be sure to post any updates here in the meantime.

Until then, as Google Sheets is able to do conditional formatting I wonder you could use that as a workaround. I’m thinking it might be possible to have a checkbox column so that when you select it, it changes the colour of the row. That way the Zap would trigger for the changed value in the checkbox in the row so you’d see the colour change in the row that way. I’ve not tested this theory out so please do let me know if it works!  

Thank you,

Can you explain me step by step how to connect the sheet on my google drive with sending emails on gmail while changes are done? When I am trying to make a new Zap I can’t find a sheet on my google drive :/