Never miss an important deadline, expiration, or follow up again. Trigger Slack messages based on dates in a Google Sheet to remind your team about upcoming deadlines, follow up on late invoices, and more.
This automation checks to see if today's date matches a date specified in a spreadsheet and automatically sends a Slack message if TRUE.
Once per day pull the latest records from a Google sheet
IF(TODAY() = C2,SENDGMAIL(<tim@gmail.com>,B2,”Reminder, task due”….)
Send a Slack message for each Google Sheets row that meets the criteria
SENDSLACK(<my_credential>,"#updates","Deadline in 3 days","[Task] is coming due in 3 days")