Back to Templates
Who's it for?
This template is perfect for teams, communities, or anyone who wants a fun, automated way to remember and celebrate birthdays. If you love space and want to make someone's special day a little more cosmic, this is for you. It's a great way to boost morale and ensure no one's birthday is forgotten.
How it works / What it does
The workflow runs automatically every morning. It reads a list of birthdays from your Google Sheet and checks if any match the current date. If a match is found, it fetches the latest Earth image from NASA's EPIC API and uses an AI model to generate a unique, space-themed birthday greeting. Finally, it sends a personalized HTML email to the birthday person and posts a celebratory message in your designated Slack channel.
Requirements
A Google Sheet with columns for Name, Email, and Birthday (in a format like YYYY-MM-DD).
Credentials for Google Sheets, Gmail, OpenAI, and Slack configured in your n8n instance.
How to set up
Configure Credentials: Add your API credentials for Google (for both Sheets and Gmail), OpenAI, and Slack in the respective nodes.
Set Up Google Sheet: In the "Get Birthday Roster" node, enter your Google Sheet ID and the name of the sheet where the birthday list is stored.
Configure Slack: In the "Post Slack Notification" node, select the channel where you want birthday announcements to be posted.
Activate Workflow: Save and activate the workflow. It will now run automatically every day!
How to customize the workflow
Change the schedule: Modify the CRON expression in the "Every Morning at 7:00" node to change when the workflow runs.
Adjust the AI prompt: Edit the system message in the "Generate Space Birthday Message" node to alter the tone, length, or style of the AI-generated greetings.
Customize the email design: Modify the HTML in the "Send Birthday Email" node to change the look and feel of the birthday message.