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

Description

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.