Personalized cold email generator with Supabase, Smartlead & Google Gemini AI

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.