Trigger slack notification when an item is expired in google sheet with 15 days prior of the expiration date

[Abi_Sabau]

Get name & expiration date from google sheet and trigger a slack notification with 15 days before the expiration date. (see screenshot “end date”)

send a slack massage {Name}'s contract is expiring in 2 weeks. Don’t forget to send a new contract"

Hope it makes sense. I am new here and I’m not sure how to set up this notification.

Include screenshots of

[samliew]

Hmm I think you are using the wrong Sheets trigger module. Don’t you want to search rows that match a criteria, instead you are currently only watching new rows?

[Abi_Sabau]

yess, makes sense. thank you!! and what would be the filter formula I should use?

[samliew]

See Update a Sheets Row When a Date Filter is Met - #7 by samliew for examples.