Send AI savings nudges from Google Sheets with Gmail and Gemini

Goal-Based Savings Tracker with Email Nudges > n8n, Google Sheets & Gemini AI --- This workflow automates goal-based savings tracking by pulling user data from Google Sheets, calculating progress and sending AI-generated motivational nudges via email. It evaluates whether users are ahead, on track or behind schedule and dynamically adjusts savings advice using an AI model. Quick Start Guide (Get Running in Minutes) 1. Login to your n8n account. 2. Connect your Google Sheets account and map required columns 2. Add your Gemini API credentials (or any LLM provider) 3. Connect your Gmail account for sending emails 4. Replace the Manual Trigger with a Schedule Trigger (daily) 5. Test the workflow with sample data 6. Activate the workflow What It Does This workflow acts as a smart financial assistant that helps users stay on track with their savings goals. It fetches savings data from a Google Sheet, processes it to calculate key metrics like progress percentage, expected savings and remaining days and determines whether the user is ahead, on track or behind schedule. Based on this evaluation, the workflow generates personalized financial nudges using an AI agent. These nudges include motivational messages, practical advice and updated daily savings targets tailored to the user's current progress. Finally, the workflow formats this information into a structured email and sends it directly to the user, creating a fully automated feedback loop that encourages consistent saving behavior. Who It's For - Individuals tracking personal savings goals - Financial coaches and advisors - Fintech startups building savings tools - Automation enthusiasts using n8n - Anyone who wants automated financial motivation Requirements To use this workflow, ensure the following: Accounts & Credentials - n8n account - Google Sheets account (OAuth connected in n8n) - Gmail account (OAuth for email sending) - Google Gemini API (or any supported LLM provider) Google Sheet Structure (Required) Your sheet must include the following columns: | Column Name | Description | |-----------------|--------------------------------------| | Name | User's name | | Email | Recipient email address | | Goal Amount | Total savings target (USD) | | Total Saved | Current saved amount (USD) | | Start Date | Savings start date | | Target Date | Goal completion date | How It Works & Set Up Workflow Overview 1. Fetch data from Google Sheets 2. Normalize and calculate savings metrics 3. Evaluate user progress 4. Generate AI-based savings advice 5. Format email content 6. Send email notification Setup Instructions Step 1: Replace Trigger with Schedule - Remove or disable Manual Trigger - Add Schedule Trigger - Configure it to run daily (e.g., 8 AM) Step 2: Configure Google Sheets Node - Connect your Google Sheets account - Select your spreadsheet and sheet - Ensure column names match the required schema Step 3: Prepare & Normalize Data - This node calculates: - Total days between start and target - Days passed and remaining - Expected savings by now - Progress percentage - Daily required savings - No changes required unless modifying logic Step 4: Evaluate Progress (IF Node) - Compares: - Total Saved vs Expected Savings - Outputs: - Ahead / On Track → Positive path - Behind → Recovery path Step 5: Set Messaging Context - Two branches: - Ahead/On Track → Encouraging messages - Behind → Catch-up strategy - Prepares base tone before AI processing Step 6: Configure AI Savings Coach - Connect your Gemini API credentials - You may replace with: - OpenAI - Claude - Any LLM supported in n8n - AI generates: - Motivation - Advice - New daily savings target Step 7: Format Final Output - Structures email content: - Subject - Body (Motivation + Advice + Target) - Recipient Step 8: Configure Gmail Node - Connect Gmail OAuth - Ensure sender permissions are correct - Test email delivery Step 9: Activate Workflow - Run a test execution - Activate workflow for daily automation How To Customize Nodes