An n8n automation workflow to simplify lead outreach with personalized HTML emails!
🔹 How it works:
Lead Upload – Start by selecting a leads file (CSV, XLS, or XLSX) via form input.
Google Drive Integration – File is uploaded to Google Drive for safe storage, then automatically downloaded for processing.
Smart File Handling – A Switch node detects the file type (CSV, XLS, XLSX) and routes it to the correct parser.
Data Extraction – Lead details (name & email) are extracted from the chosen file format.
Field Selection – Workflow ensures only the required fields are mapped for email sending.
Loop Processing – Iterates over each lead one by one.
Automated Email Sending – Sends personalized HTML emails to every lead using Gmail (or other email integrations).
✅ With this setup, You can upload any type of lead file, and the system handles everything—from storage and parsing to automated outreach—without manual intervention.
This workflow makes lead management scalable, efficient, and error-free.
Top comments (0)