An AI-powered cold outreach agent for sales teams. It generates hyper-personalized email openers for every prospect, sends them at scale through Gmail, logs every contact in Airtable to avoid duplicates, and automatically follows up with anyone who hasn't responded.
Service
Automation
Industry
SaaS & Tech
Category
AI Automation
Built with: n8n, Llama, Airtable, Gmail.
Overview
The Problem
Manually writing personalized cold emails for hundreds of prospects is time-consuming and inconsistent
Sales teams waste hours researching each prospect to craft relevant opening lines
No centralized tracking of who's been contacted, replied, or ignored
Follow-ups are ad-hoc and often missed
The Solution
AI generates hyper-personalized opening lines based on prospect name, company, and job title
Emails are sent automatically with consistent formatting and branding
Every contact is logged in Airtable for full visibility and compliance
Automatic follow-up emails sent to non-responders after set periods
Solution Workflow
Fetch
Detect
Generate
Send
Track
Follow Up
Full Technical Breakdown
1. Lead Intake & Deduplication
Pulls prospect records from Google Sheets containing name, company, title, and email. Checks Airtable database to ensure the prospect hasn't been contacted previously, preventing wasted outreach and unintended duplicate emails.
2. Batch Processing & Loop Logic
Processes leads in batches rather than one-at-a-time, dramatically improving efficiency. The "Loop Over Items" node handles each prospect sequentially while maintaining data integrity throughout the workflow.
3. AI-Powered Personalization
Llama 3.2 (3B) model generates unique, contextual opening lines by analyzing the prospect's name, job title, and company. Uses sentiment analysis to ensure tone is conversational, not salesy.
4. Intent-Based Email Composition
Combines the AI-generated opener with a standardized closing and signature. Creates the subject line dynamically, then formats both for Gmail delivery with proper encoding and headers.
5. Gmail Integration & Sending
Sends the personalized email directly through Gmail OAuth2. Tracks delivery status and timestamps. All sent emails logged with full headers for compliance and audit trails.
6. Airtable Logging & CRM Sync
Creates a permanent record in the "Leads" table with contact details, outreach status ("Contacted," "Replied," "No Response"), timestamp, and AI-generated copy for future reference and A/B testing.
Results
Key Features
AI-powered personalization: Automatically generates unique, context-aware opening lines for each prospect based on their role, company, and seniority level, eliminating generic cold email templates.
Duplicate detection: Before sending, searches Airtable for existing contacts to prevent redundant outreach and wasted sends to prospects already in the pipeline.
Batch processing at scale: Handles hundreds of leads in a single workflow run. The loop logic ensures each prospect is processed completely before moving to the next.
Multi-turn email sequences: Remembers contact history in Airtable and sends follow-up emails only to prospects with no previous interaction, respecting email frequency preferences.
Gmail integration: Sends emails directly from your branded Gmail account with full OAuth2 authentication, maintaining sender reputation and authentication (SPF/DKIM).
Centralized lead tracking: Every outreach action (send, follow-up, status) is logged in Airtable with timestamps, creating an auditable record for sales operations and compliance.
Before
Manual research and email writing for each prospect, inconsistent messaging, no centralized tracking, forgotten follow-ups, zero data on what messaging actually works.
After
AI generates personalized emails instantly, all outreach logged and tracked, automatic follow-ups based on response status, clear metrics on open rates and reply patterns, consistent brand voice at scale.
What This Proves
This system demonstrates that AI can handle high-volume, repetitive outreach tasks while maintaining personalization, freeing sales teams to focus on relationship-building and closing deals rather than manual email writing.
Tech Stack
AI Layer
Llama 3.2 (3B) — Local LLM for personalized opener generation
n8n — Workflow orchestration engine
Data Layer
Google Sheets — Lead list source and prospect database
Airtable — Outreach tracking & CRM layer
Communication Layer
Gmail API — Email delivery and sending
Google Sheets API — Real-time lead syncing
Scalability & Flexibility
LLM Provider Flexibility: Currently runs on local Llama (3.2 3B) for cost-free inference; can swap to OpenAI GPT-4o, Anthropic Claude, or Gemini for higher-quality personalization and tone refinement.
Lead Source Flexibility: Currently pulls from Google Sheets, but can extend to pull from HubSpot, Pipedrive, LinkedIn Sales Navigator, or custom CRMs via API without reworking core logic.
Email Template Customization: Signature, closing lines, and subject line templates can be versioned in Airtable for A/B testing different messaging strategies.
Outreach Channel Expansion: Built on normalized input structure, so the same personalization and tracking logic can extend to LinkedIn Messaging, Twitter DMs, or SMS by adding a new sending node.
Approval Workflow Optional: Can insert a Slack approval step before sending to review AI-generated copies before delivery, then auto-send after approval.
Follow-Up Rule Engine: Currently sends one follow-up after a set period. Can expand to multi-touch sequences (3–5 email drip campaign) with sentiment-based prioritization.
Analytics Dashboard: The Airtable log is structured for direct export to Looker Studio, Power BI, or custom dashboards to track open rates, reply rates, and conversion by prospect segment.
Frequency Capping: Can add logic to respect max-emails-per-day caps and rate-limit across domains to maintain sender reputation.