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.