Share
Explore

Automated Birthday and Anniversary Slack Posts

Add Team Member
Team Birthdays and Anniversaries
0
Search
People
Handle
Birthday Post
Birthday Message
Anniversary Post
Anniversary Message
Birthday
Anniversary
Anniversary Year
This Year
Anniversary Number
Birthday Button
Anniversary Button
1
Michael Davis
@mdavis
Happy birthday, @mdavis! 🎉
Happy birthday,
Happy 7 years at SEV, @mdavis! 🎉
Happy 7 years at SEV,
1/7
8/1
2015
2022
7
Birthday
Anniversary
2
Susanna Cio
@susanna
Happy birthday, @susanna! 🎉
Happy birthday,
Happy 3 years at SEV, @susanna! 🎉
Happy 3 years at SEV,
11/10
8/1
2019
2022
3
Birthday
Anniversary
3
Jordan Smith
@jordan
Happy birthday, @jordan! 🎉
Happy birthday,
Happy 2 years at SEV, @jordan! 🎉
Happy 2 years at SEV,
7/22
6/12
2020
2022
2
Birthday
Anniversary
4
Damian Leigh
@damian
Happy birthday, @damian! 🎉
Happy birthday,
Happy 4 years at SEV, @damian! 🎉
Happy 4 years at SEV,
1/21
6/24
2018
2022
4
Birthday
Anniversary
There are no rows in this table
Purpose
I love celebrating our team member’s birthdays and work anniversaries, but it’s difficult to keep track of everyone’s dates in gcal and I’m nervous about forgetting something. The automated posts are a great systematic approach to acknowledging everyone, and because these messages go to our #team Slack channel the rest of Sweat Equity Ventures can also join in on the celebrations.
Set-Up
When a new team member joins your company add their details by clicking the Add Team Member button. I recommend waiting until their second day so the bot does not confuse their Start Date with their Anniversary.
The Automations of the doc are set to post any messages at 8:00 am Pacific Time every day, but you can update the settings based on what works best for your organization.
What it looks like in Slack
image.png
Columns
Note: * designates that I would normally hide the column to clean up the look of the table
People
I recommend setting the column type to People so you can easily select team members. In this instance I have it as text so as not to share any team member’s contact details.
Handle
This is the person’s handle in Slack ー the @ mention will automatically tag them in Slack.
Birthday Post
This is a concatenated formula that combines the Birthday Message, Handle, and an emoji. We have the Birthday Messages to all be the same (”Happy birthday, (person)! 🎉”), but you could personalize a message for each team member.
Birthday Message*
The standardized “Happy birthday, “ text that is pulled into the concatenated Birthday Post.
Anniversary Post
This is also a concatenated formula that combines the Anniversary Message, Handle, and an emoji. You can similarly personalize it.
Anniversary Message*
The standardized “Happy X year(s) at (Company), “ text that is pulled into the concatenated Anniversary Post. It is written as an If formula, so if the person is celebrating their first work anniversary the “year” is singular, and if it’s >1 then “years” is plural.
Birthday
A Date column that only includes the person’s DD/MM of their birthday.
Anniversary
A Date column that only includes the person’s DD/MM of their anniversary.
Anniversary Year*
The year the person started working, in a Number format so it can be subtracted from This year.
This Year*
The current year so it can be used in subtraction with Anniversary year.
Anniversary Number
The formula of (This year - Anniversary year) to get how many years the person has been working.
Birthday Button
The Birthday button is integrated with the Slack Pack and will post the Birthday Post to the designated channel when pressed. I have it set up so it posts from my personal Slack account into the #team Slack channel.
Anniversary Button
The Anniversary button is integrated with the Slack Pack and will post the Anniversary Post to the designated channel when pressed. I have it set up so it posts from my personal Slack account into the #team Slack channel.
Edge Cases Not Accounted For
Duplicative Birthdays & Anniversaries
If someone shares the same birthday or work anniversary with someone else, the bot will post separate messages for each person.
While we don’t see this as a problem (our team only has a couple instances of shared birthdays and start dates), companies with many people on the same start dates or duplicative birthdays may want to build out the doc further so it posts something like “Happy birthday to X, Y, and Z! 🎉” instead of 3 separate messages.
We also actually prefer the separate messages because the team can post emojis or threaded messages with personalized reactions for each team member celebrating that date.
Weekends
If someone’s birthday or anniversary falls on a weekend it is less likely the team will see the message and be able to share their celebratory reactions on that date.
You could build out the doc so it posts a message like “Happy (weekend!) birthday to @mention! 🎉” on the Friday before their celebration date, but it gets more complicated for birthdays that fall on holiday weekends or holiday breaks.
Departures
Because this Coda doc is not integrated with HRIS data it does not remove someone’s row in the table if they depart. To work around this I’ve added “Updating Birthday/Anniversary Bot” to my list of tasks to complete when someone leaves.
Support
If you have any questions on implementing the Birthday and Anniversary Automations feel free to reach out to me on LinkedIn!
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.