Send personalized client emails with Google Sheets, Gemini and Gmail

Smart Client Email Automation for Financial Advisors This workflow automatically generates and sends personalized client emails using portfolio data and live market trends. It fetches client details from Google Sheets, retrieves market news via API, filters new clients, validates essential fields as a safeguard and uses AI to create professional emails. Finally, it sends emails through Gmail and updates the status to avoid duplicates. Quick Implementation Steps 1. Signup / Login to you n8n account 2. Connect Google Sheets with client data 3. Add your API key 4. Configure Google Gemini API credentials 5. Connect your Gmail account 6. Run manually or replace with a trigger (Cron/Webhook) 7. Test with sample client data What It Does This workflow automates the process of sending personalized financial emails to clients. It retrieves client information such as name, email, portfolio value and risk level from Google Sheets. At the same time, it fetches the latest market news and sentiment using an external API. This combined data helps create relevant and meaningful communication. After collecting the data, the workflow filters only new clients who have not yet received emails. It performs basic validation to ensure important fields like email and portfolio value are present. This step acts as a safeguard to prevent errors during execution. Finally, the workflow uses an AI model to generate a professional HTML email tailored to each client. The email is formatted, sent via Gmail with a delay to control sending rate and the client status is updated to "Sent" in Google Sheets to prevent duplicate communication. Who It's For - Financial advisors managing multiple clients. - Investment firms sending portfolio updates. - Freelancers handling client communication. - Business owners automating email outreach. - Beginners learning AI-powered automation. Requirements To use this workflow, you need: - n8n account (self-hosted or cloud) - Google Sheets account with client data - Google Sheets OAuth2 credentials - Gmail OAuth2 credentials - Google Gemini API access - Alpha Vantage API key (for market news) - Basic understanding of n8n nodes How It Works & Setup Guide Step 1: Prepare Google Sheets Create a sheet with the following columns: - ClientID - ClientName - Email - PortfolioValue - RiskLevel - Status (leave empty for new clients) Step 2: Configure Google Sheets Node - Connect your Google Sheets account - Select your document and sheet - Ensure correct column mapping Step 3: Configure Market News API - Open Fetch Market News node - Add your Alpha Vantage API key - Keep function as NEWSSENTIMENT Step 4: Understand Processing Logic - Filters only new clients (empty Status) - Picks the first new client only - Adds market summary (fallback used if API fails) Step 5: Data Preparation - Set node structures required fields - Ensures consistent format for AI processing Step 6: Validation (Safeguard) - IF node checks: - Email is not empty - Portfolio value is not empty - Prevents invalid data from proceeding Step 7: Configure AI (Google Gemini) - Add Gemini API credentials - Uses prompt to generate: - Personalized email - Professional tone - HTML format output Step 8: Format Email - Maps: - To → Client Email - Subject → Dynamic name-based subject - Body → AI-generated HTML Step 9: Delay Sending - Wait node controls sending rate - Prevents Gmail limits or spam flags Step 10: Send Email - Configure Gmail node - Connect your Gmail account Step 11: Update Status - Marks client as "Sent" - Uses ClientID to match rows - Prevents duplicate emails Step 12: Choose Trigger - Default: Manual Trigger - Optional: - Cron (for scheduled emails) - Webhook (for real-time automation) How To Customize Nodes - Filter Logic: Modify code node to process multiple clients instead of one - AI Prompt: Adjust tone, length or format of email - Validation: Add stricter checks (email format, numeric values) - Subject Line: Customize based on portfolio or risk level - Delay No