Personalized Cold Email Generator with Supabase, Smartlead & Google Gemini AI

Nodes

c271cce3-82fc-4582-b314-f282e190a2e32e3e39e3-0e17-4fae-9ac5-9ee31f9711ed1c04dd23-ae91-4772-b6db-e7ce81fc2f71+3

Categories

Created by

raRahi

Last edited 58 days ago

n8n Workflow: AI-Personalized Email Outreach (Smartlead)

🔄 Purpose

This workflow automates cold email campaigns by:

  • Fetching leads
  • Generating hyper-personalized email content using AI
  • Sending emails via Smartlead API
  • Logging campaign activity into Google Sheets

🧩 Workflow Structure

  1. Schedule Trigger

    • Starts the workflow automatically at scheduled intervals.
    • Ensures continuous campaign execution.
  2. Get Leads

    • Fetches lead data (name, email, company, role, industry).
    • Serves as the input for personalization.
  3. Loop Over Leads

    • Processes each lead one by one.
    • Maintains individualized email generation.
  4. Aggregate Lead Data

    • Collects and formats lead attributes.
    • Prepares structured input for the AI model.
  5. Basic LLM Chain #1

    • Generates personalized snippets/openers using AI.
    • Tailored based on company, role, and industry.
  6. Update Row (Google Sheets)

    • Saves AI outputs (snippets) for tracking and QA.
  7. Basic LLM Chain #2

    • Expands snippet into a full personalized email draft.
    • Includes subject line + email body.
  8. Information Extractor

    • Extracts structured fields from AI output:
      • Subject
      • Greeting
      • Call-to-Action (CTA)
      • Closing
  9. Update Row (Google Sheets)

    • Stores finalized draft in Google Sheets.
    • Provides visibility and audit trail.
  10. Code

    • Formats email into Smartlead-compatible payload.
    • Maps fields like subject, body, and recipient details.
  11. Smartlead API Request

    • Sends the personalized email through Smartlead.
    • Returns message ID and delivery status.
  12. Basic LLM Chain #3 (Optional)

    • Generates follow-up versions for multi-step campaigns.
    • Ensures varied engagement over time.
  13. Information Extractor (Follow-ups)

    • Structures follow-up emails into ready-to-send format.
  14. Update Row (Google Sheets)

    • Updates campaign logs with:
      • Smartlead send status
      • Message IDs
      • AI personalization notes

⚙️ Data Flow Summary

  • Trigger → Runs workflow
  • Get Leads → Fetch lead records
  • LLM Personalization → Create openers + full emails
  • Google Sheets → Save drafts & logs
  • Smartlead API → Send personalized email
  • Follow-ups → Generate and log structured follow-up messages

📊 Use Case

  • Automates hyper-personalized cold email outreach at scale.
  • Uses AI to improve response rates with contextual personalization.
  • Provides full visibility by saving drafts and send logs in Google Sheets.
  • Integrates seamlessly with Smartlead for sending and tracking.

New to n8n?

Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!