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

Schedule Trigger Starts the workflow automatically at scheduled intervals. Ensures continuous campaign execution.

Get Leads Fetches lead data (name, email, company, role, industry). Serves as the input for personalization.

Loop Over Leads Processes each lead one by one. Maintains individualized email generation.

Aggregate Lead Data Collects and formats lead attributes. Prepares structured input for the AI model.

Basic LLM Chain #1 Generates personalized snippets/openers using AI. Tailored based on company, role, and industry.

Update Row (Google Sheets) Saves AI outputs (snippets) for tracking and QA.

Basic LLM Chain #2 Expands snippet into a full personalized email draft. Includes subject line + email body.

Information Extractor Extracts structured fields from AI output: Subject Greeting Call-to-Action (CTA) Closing

Update Row (Google Sheets) Stores finalized draft in Google Sheets. Provides visibility and audit trail.

Code Formats email into Smartlead-compatible payload. Maps fields like subject, body, and recipient details.

Smartlead API Request Sends the personalized email through Smartlead. Returns message ID and delivery status.

Basic LLM Chain #3 (Optional) Generates follow-up versions for multi-step campaigns. Ensures varied engagement over time.

Information Extractor (Follow-ups) Structures follow-up emails into ready-to-send format.

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.