Back to Templates

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

Created by

Created by: Rahi || rahiuppal

Rahi

Last update

Last update a day ago

Share


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.