Every morning, posts a congratulation in Slack for each person whose work anniversary is today.

UsesGoogle SheetsSlack

Celebrate work anniversaries in Slack

Work anniversaries are easy to miss. Each day at 9:00 this reads your Team tab for people whose start date falls on today's date in an earlier year.

For each one it posts a message in your Slack channel with their name and how many years they have been with you. Someone who started today is left out. Your tab needs columns named Name and Start date.

ScheduleRun every day at 09:00.Run every day at 09:00.
Google SheetsFind today's anniversariesRead the rows of (not set). Save it as anniversaries.Google Sheets
Decisions & LoopsCongratulate each personFor each person in anniversaries.rows:
SlackCongratulate them in SlackSend a message to (not set). Save it as posted.๐ŸŽ‰ Happy work anniversary, person.Name! person.years years with us today.Slack