Send personalized birthday and anniversary emails with Google Sheets, Gemini, and Gmail

Birthday & Milestone Message Automation (n8n Google Sheets + Gemini AI + Gmail)

This workflow automatically sends personalized birthday and anniversary emails to clients. It runs daily, checks a Google Sheet for matching dates, generates a warm AI message using Google Gemini and sends it via Gmail. It also includes a thoughtful investment idea tailored to the client’s age, risk profile and relationship type.

Quick Implementation Steps

Connect Google Sheets OAuth2 Add your Google Gemini API key Connect Gmail OAuth2 Update the Google Sheet ID Ensure your sheet has required columns: Client Name, Email, Advisor Name, Birthday, Anniversary, Relationship Type (Premium / Normal), Client Age, Risk Profile Activate the workflow

What It Does

This workflow automates client relationship engagement for financial advisors by sending personalized messages on important milestones like birthdays and anniversaries. It eliminates the need for manual tracking and ensures that no important date is missed.

Every day at a scheduled time, the workflow reads all client records from a Google Sheet and checks if any client has a birthday or anniversary on that day. If a match is found, it prepares detailed variables including client information, tone and occasion.

The workflow then intelligently selects a suitable investment idea based on the client’s age group and risk profile. This context is passed to Google Gemini, which generates a warm, human-like message. Finally, the message is formatted and sent as a text email via Gmail.

Who’s It For

Financial advisors
Wealth managers
Investment consultants
Relationship managers handling client portfolios
Firms managing high-value or premium clients

Requirements

To use this workflow, you need:

n8n instance (Cloud or Self-hosted) Google Sheets account with client data Google Gemini API key Gmail account for sending emails Proper OAuth2 credentials configured in n8n A Google Sheet with the following columns: Client Name
Email
Advisor Name
Birthday
Anniversary
Relationship Type (Premium / Normal)
Client Age
Risk Profile

How It Works & Setup Guide

🧩 Step-by-Step Workflow Execution

Schedule Trigger Runs every day at 9:01 AM Read Client Data Fetches all rows from Google Sheets Settings Node Stores configuration such as: Message tone Default values Subject line format Labels for birthday and anniversary Date Matching (IF Node) Checks if today matches: Client Birthday OR Client Anniversary If no match → workflow stops Prepare Variables Extracts and formats: Client details Occasion type Message tone (premium or normal) Email subject AI prompt Investment Suggestion Logic (Code Node) Selects suggestion based on: Age group (Young / Mid / Senior) Risk profile (Low / Moderate / High) Adds a meaningful explanation AI Message Generation Google Gemini generates: Warm personalized message Includes emotional investment suggestion Format Email Converts AI output into clean text format Send Email Gmail sends the message directly to the client

How To Customize Nodes

Schedule Node** Change time based on your preference Settings Node** Modify: Tone (formal, friendly) Subject lines Default age or risk values Advisor firm name Google Sheet Node** Replace Sheet ID with your own data source Code Node (Investment Logic)** Add or modify: Investment ideas Age group logic Risk mapping Gemini Node** Adjust prompt for: More emotional tone Shorter or longer messages Gmail Node** Change sender name or email behavior

Add-ons (Enhancements)

Add WhatsApp or SMS integration for multi-channel messaging
Store sent messages in Google Sheets or CRM
Add Slack notifications for internal tracking
Include attachments (PDF reports or offers)
Add client segmentation logic for advanced personalization

Use Case Examples

Automatically send birthday wishes to all clients without manual effort
Strengthen relationships with premium clients using personalized messages
Promote subtle investment awareness without sounding salesy
Maintain consistent engagement across a large client base
Improve client retention through thoughtful communication

There can be many more such use cases depending on how you want to extend and customize this workflow.

Troubleshooting Guide

| Issue | Possible Cause | Solution | |------|--------------|---------| | No emails are sent | No matching date found | Verify birthday/anniversary format in sheet | | Workflow stops early | IF condition not satisfied | Check date comparison logic | | Incorrect client data | Column mismatch | Ensure exact column names are used | | Gemini not generating response | API key issue | Verify Gemini credentials | | Emails not delivered | Gmail authentication issue | Reconnect Gmail OAuth | | Wrong message tone | Settings misconfigured | Check tone values in Settings node |

Need Help?

If you need assistance setting up this workflow, customizing it for your business or building advanced automation solutions, feel free to reach out to our n8n workflow development team at WeblineIndia.

Our team can help you design scalable, production-ready workflows tailored to your exact requirements.