Personalized Cold Email Outreach Case Study

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

  1. Fetch
  2. Detect
  3. Generate
  4. Send
  5. Track
  6. 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.

Gallery

  • Personalized Cold Email Outreach
  • Lead Filled with Outreaching Client Details
  • Airtable filled with CLient Details for Outreaching
  • Email send Via Gmail to client for outreaching
About Nexoryn Nexoryn Services Nexoryn Portfolio Client Reviews Contact Nexoryn Privacy Policy Terms of Service Cookie Policy