Birthday reminders from dates in Google Sheets
Keep names and dates in the spreadsheet you already use, then email the right person before each date. The sheet stays the list. The email is the reminder.
Why a birthday list in Google Sheets still gets missed
Plenty of teams already keep birthdays in a spreadsheet: a name, a date, sometimes a team. The list is easy to maintain and hard to remember. Someone has to open it in the right week.
A reminder from that sheet is an email to the address stored on the row. After the email arrives, the team uses whatever celebration process it already has. The spreadsheet does not need to become a greeting-card tool for the date to be useful.
What to put on a birthday reminder spreadsheet
One person and one date per row. Google Sheets holds the list. Date & Email Reminders reads only the columns you map.
| Field | What it stores | Why keep it | Reminder |
|---|---|---|---|
| Name | The person the date belongs to | The email and the sheet both need a label for the row | Map this as the name |
| Date | The birthday, or another date you want followed | This is the date the email is timed against | Map this as the date |
| Type | Birthday, work anniversary, or another label you choose | Lets you filter one sheet without mixing the meaning of each row | Sheet only |
| Team or department | Where that person sits, if this is a work list | Useful when a manager only wants their own group | Sheet only |
| Reminder email | Who should hear about the date | Often a manager or the person who runs the list, not necessarily the person named in the row | Map this as the recipient |
| Notes | Anything the team already jots down | Dietary notes, a gift idea, or a reminder of who usually organizes the card | Sheet only |
| Link | An optional URL you already use | A team page or a shared doc, if you want it in the email | Optional mapped link |
Age, days remaining, and a next-birthday formula are spreadsheet math. Add them if you want a sorted view. They are not part of the add-on.
Birthdays, work anniversaries, and other personal dates
These are different dates that can share one sheet. A type column keeps them readable. A second row is the way to give each date its own email, because each reminder follows one date column.
Team birthdays
HR or a team lead keeps the names and dates. The recipient is usually the manager or the person who already organizes the team's cards. The email tells them the date is coming. It does not write the card.
Work anniversaries
Store the anniversary as its own date, with type set to work anniversary. If the same person also has a birthday on the sheet, that is a second row with its own date and its own recipient.
A personal or family list
The same columns work when the recipient is you. Team and department can stay blank. The difference is whose dates you typed in, not a separate product.
How to set up birthday reminders in Google Sheets
Build the list first. The add-on is the last step, and only if you want the email.
1. Start with the sheet you already have
If the names and dates are already in Google Sheets, keep them there. Add a date column in a consistent format if the birthday is currently written as text that Sheets does not treat as a date.
2. Use one row per date
A person with a birthday and a work anniversary gets two rows when both dates should send an email. Put a type on each row so a filter can show only birthdays or only anniversaries.
3. Decide who gets the email
Type that address in the recipient column. For a team list it is often a manager. For a personal list it is often you. Leave the cell blank only on rows that should not send anything.
4. Add the columns you will actually look at
Team, notes, and a link are optional. Add them when someone reading the sheet needs them. Skip them when the list is only names and dates.
5. Map the date and the recipient
Install Date & Email Reminders from the Marketplace, choose the date column and the recipient column, and pick 30 days before, 7 days before, 1 day before, and/or the date itself. A notice exactly three days before is not one of those choices.
6. Keep the sheet as the list
When someone joins, leaves, or changes team, edit the row. The email follows the sheet. You do not copy the list into another database to make the reminder run.
Example: a mixed birthday and anniversary list
Fictional rows. Birthdays and work anniversaries sit together because the type column says which date is which. The reminder follows the date and the email on that row.
| Name | Type | Date | Team | Reminder email |
|---|---|---|---|---|
| Alex Kim | Birthday | 14 Mar | Design | manager@example.com |
| Alex Kim | Work anniversary | 2 Aug | Design | manager@example.com |
| Priya Shah | Birthday | 2 Nov | you@example.com | |
| Jordan Lee | Birthday | 19 May | Support | hr@example.com |
| Sam Ortiz | Work anniversary | 4 Jun | Operations | lead@example.com |
| Riley Chen | Birthday | 15 Jan | Finance | riley.manager@example.com |
Example addresses only. Notes and a link can sit in extra columns if the team wants them. There is no file to download.
What happens when the date gets close
The sheet is still the list. The email is a nudge to the person who already handles whatever comes next.
Without a reminder
- Someone keeps the birthday list
- They have to remember to open it
- A date in a busy week gets skipped
- The celebration process never starts
With a date email
- The same person keeps the list
- The mapped date approaches
- The address on that row gets the email
- The team uses the card, lunch, or note it already uses
A greeting-card app, an employee-engagement product, or a Google Calendar entry is a different job. Use one of those if you want cards, public posts, rewards, or a calendar event on your own account. Stay with the sheet if the missing piece is an email before a date you already store.
Questions
Not by itself. A birthday list can sit in Google Sheets, and Date & Email Reminders can email the address on that row before the date, or on the date. You choose 30 days before, 7 days before, 1 day before, and/or the date itself.
The reminder uses a date column, a name, a recipient email, and an optional link. Team, notes, and a type label can stay in the sheet for the people reading it.
Whoever you type into the recipient column. That can be you, a manager, or someone else who already handles the team's birthday list. The email is a notice about the date, not a card.
Yes. Use a type column so you can filter them, and use a separate row when both dates need their own email. Each reminder follows one date.
That is ordinary spreadsheet work: a formula for the next occurrence, then a sort. Date & Email Reminders does not calculate ages or next-birthday formulas. It sends the email from the date you map.
No. Mapping the date and the recipient is enough for this email. How to send email reminders from Google Sheets
A certification or another employee file with an expiry date is a different list from a birthday. Employee document expiry reminders
Related pages
Date-based email in general, and employee files that expire, are different jobs from a birthday list.
Start from the list you already keep
Install Date & Email Reminders from the Google Workspace Marketplace, map the date column and the recipient email, and save. There is no template file to download. You can start on the free plan.