This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Send Automated Personalized Birthday Emails Using Google Sheets, OpenRouter AI, and Gmail
This workflow sends personalized birthday greetings via email every morning using data from Google Sheets and messages generated with AI. It’s great for communities, schools, small businesses, or anyone who wants to automate meaningful connections.
🗓 Daily Birthday Check — Runs every day at 9 AM
📋 Google Sheets Integration — Reads user data: Name, Email, DOB
🔍 Smart Date Matching — Extracts day & month from DOB to match today’s date
🤖 OpenRouter AI Integration — Generates a custom subject + email message
🛠 Function Node Cleanup — Separates AI response into subject & body
📬 Gmail Node — Sends personalized birthday wishes instantly