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 sur…

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?

yess, makes sense. thank you!! and what would be the filter formula I should use? [Screenshot 2024-03-14 at 6.37.52 PM]

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

Beginner Questions

samliew March 14, 2024, 5:25pm 5

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

Topic		Replies	Views
Automate Sheet > Delay until date > Notify Slack Questions google-sheets	9	291	June 28, 2024
Google sheets SEARCH ROWS Later than filter Questions google-sheets	1	468	May 13, 2024
Search Google Sheet for a date in the past and post to tick tick Beginner Questions google-sheets	3	190	June 23, 2024
Sending notifications before a date Questions google-sheets	3	117	August 21, 2024
Get a Date from google sheets and do an automation if that date is a week old Questions filters , google-sheets , zoho	3	121	March 26, 2025

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

Related topics